Download Mimer SQL Reference Manual - Department of Information Technology

Transcript
Deprecated features
D.6
D-5
Datetime scalar functions
The following scalar functions have been deprecated in the current version of
Mimer SQL. They will be re-introduced in a future version with changed
functionality.
D.6.1
CURRENT_TIME
This function, in its present form, has been deprecated. The same functionality
is now provided by the LOCALTIME function. Continued use of
CURRENT_TIME is not recommended as the function will be re-introduced,
with changed functionality, in a future version of Mimer SQL and thus existing
usage will not be forward-compatible.
D.6.2
CURRENT_TIMESTAMP
This function, in its present form, has been deprecated. The same functionality
is now provided by the LOCALTIMESTAMP function. Continued use of
CURRENT_TIMESTAMP is not recommended as the function will be reintroduced, with changed functionality, in a future version of Mimer SQL and
thus existing usage will not be forward-compatible.
D.7
Data dictionary views
The predefined system views on the data dictionary tables, owned by the
system ident called MIMER, that were supported in previous versions of
Mimer SQL have now been replaced by the standard system views belonging to
the schemas INFORMATION_SCHEMA and INFO_SCHEM which are owned
by ident SYSTEM.
Mimer SQL version 8.2
Reference Manual