1.1

SQL-99 Core / SQL-2003 Mandatory
NoteSQL-2003
Mandatory
SQL-99
Core
Feature nameFeature ID
TIMESTAMP literal is implemented as built-in
function. No precision spec in datatype. No timezone
Yes*Yes*TIMESTAMP data type (including
TIMESTAMP literal) with fractional
seconds precision of 0 and 6
F051-03
spec in datatype. {ts 'yyyy-mm-dd hh:mm:ss.f...'} is
according to JDBC specification.
YesYesComparison predicate on DATE, TIME,
and TIMESTAMP data types
F051-04
YesYesExplicit CAST between datetime types
and character types
F051-05
No time zone in datetime value expressionYes*Yes*CURRENT_DATEF051-06
{fn CURTIME()} is according to JDBC specification.Yes*Yes*LOCALTIMEF051-07
NoNoLOCALTIMESTAMPF051-08
NoNoUNION and EXCEPT in viewsF081
YesYesGrouped operationsF131
YesYesWHERE, GROUP BY, and HAVING
clauses supported in queries with
grouped views
F131-01
YesYesMultiple tables supported in queries with
grouped views
F131-02
YesYesSet functions supported in queries with
grouped views
F131-03
YesYesSubqueries with GROUP BY and
HAVING clauses and grouped views
F131-04
YesYesSingle row SELECT with GROUP BY
and HAVING clauses and grouped views
F131-05
NoNoMultiple module supportF181
YesYesCAST functionF201
YesYesExplicit defaultsF221
Yes*Yes*CASE expressionF261
NoNoSimple CASEF261-01
YesYesSearched CASEF261-02
YesYesNULLIF functionF261-03
YesYesCOALESCE functionF261-04
YesYesSchema definition statementF311
YesYesCreate schemaF311-01
In SQLFire tables are not persistent by default.Yes*Yes*CREATE table for persistent base tablesF311-02
YesYesCREATE VIEWF311-03
621
SQL Language Reference