1.1.1

SQL-99 Core / SQL-2003 Mandatory
NoteSQL-2003
Mandatory
SQL-99
Core
Feature nameFeature ID
YesYesNumeric comparisonE011-05
YesYesImplicit casting among the numeric data
types
E011-06
YesYesCharacter data typesE021
YesYesCHARACTER data type (including all
its spellings)
E021-01
YesYesCHARACTER VARYING data type
(including all its spellings)
E021-02
YesYesCharacter literalsE021-03
Called LENGTH. {fn LENGTH(...)} is according to
JDBC specification.
Yes*Yes*CHARACTER_LENGTH functionE021-04
NoNoOCTET_LENGTH functionE021-05
Called SUBSTR. No FROM...FOR, just commas. {fn
SUBSTRING(....)} is according to JDBC specification.
Yes*Yes*SUBSTRING functionE021-06
YesYesCharacter concatenationE021-07
YesYesUPPER and LOWER functionsE021-08
{fn LTRIM(...)} and {fn RTRIM(...)} is according to
JDBC specification.
YesYesTRIM functionE021-09
YesYesImplicit casting among the character data
types
E021-10
Called LOCATE. {fn LOCATE(...)} is according to
JDBC specification.
Yes*Yes*POSITION functionE021-11
YesYesCharacter comparisonE021-12
YesYesIdentifiersE031
YesYesDelimited identifiersE031-01
YesYesLower case identifiersE031-02
YesYesTrailing underscoreE031-03
YesYesBasic query specificationE051
YesYesSELECT DISTINCTE051-01
YesYesGROUP BY clauseE051-02
YesYesGROUP BY can contain columns not in
select-list
E051-04
YesYesSelect list items can be renamedE051-05
YesYesHAVING clauseE051-06
YesYesQualified * in select listE051-07
vFabric SQLFire User's Guide636
vFabric SQLFire Reference