1.1.1

SQL-99 Core / SQL-2003 Mandatory
NoteSQL-2003
Mandatory
SQL-99
Core
Feature nameFeature ID
N/ANoVIEWS viewF021-03
N/ANotable_CONSTRAINTS viewF021-04
N/ANoREFERENTIAL_CONSTRAINTSF021_05
N/ANoCHECK_CONSTRAINTSF021-06
YesYesBasic schema manipulationF031
*SQLFire by default creates non-persistent base tables.
Tables can be made persistent by specifying
PERSISTENT in the CREATE table statement.
Yes*Yes*CREATE table statement to create
persistent base tables
F031-01
YesYesCREATE VIEW statementF031-02
YesYesGRANT statementF031-03
YesYesALTER table statement: ADD
COLUMN clause
F031-04
Yes
(Implicit)
Yes
(Implicit)
DROP table statement: RESTRICT
clause
F031-13
Yes
(Implicit)
Yes
(Implicit)
DROP VIEW statement: RESTRICT
clause
F031-16
YesYesREVOKE statement: RESTRICT clauseF031-19
*Partial support for joins: only on tables declared to
be colocated, with equijoin condition on partitioned
fields.
Yes*Yes*Basic joined tablesF041
YesYesInner join (but not necessarily the
INNER keyword)
F041-01
YesYesINNER keywordF041-02
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
vFabric SQLFire User's Guide640
vFabric SQLFire Reference