1.0

SQL-99 Core / SQL-2003 Mandatory
NoteSQL-2003
Mandatory
SQL-99
Core
Feature nameFeature ID
YesYesLEFT OUTER JOINF041-03
YesYesRIGHT OUTER JOINF041-03
YesYesOuter joins can be nestedF041-05
NoNoThe inner table in a left or right outer
join can also be used in an inner join
F041-07
*Joins that are not equijoins on replicated tables, or
one partitioned table with replicated tables only.
Yes*Yes*All comparison operators are supported
(rather than just =)
F041-08
See below.Yes*Yes*Basic date and timeF051
DATE literal is implemented as built-in function. {d
'yyyy-mm-ff'} is according to JDBC specification.
Yes*Yes*DATE data type (including DATE
literal)
F051-01
TIME literal is implemented as built-in function. No
precision in datatype. {t' hh:mm:ss'} is according to
JDBC specification.
Yes*Yes*TIME data type (including TIME literal)
with fractional seconds precision of 0
F051-02
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
vFabric SQLFire User's Guide590
vFabric SQLFire Reference