Documentation
Firebird RDBMS
Release Notes
Reference Manuals
White Papers & Presentations
FAQ
Books
Drivers Documentation
Third-party Docs and Articles
External Documentation
Licensing
Features
SQL Conformance
Historical Reference
Firebird Butler
Branding Policy
Firebird Brand FAQ
Firebird Brand Blacklist
Logos

Join Firebird!

Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses

Join!

Follow Us

Select your media preference

Newsletter

Subscribe to Firebird’s Newsletter to receive the latest news

SQL Conformance
Assembled by Dmitry Yemanov. Last updated: November 5, 2016.

This document outlines how much Firebird conforms to the current SQL standard. Please note that the following information is not a full statement of conformance, but just information for those interested in the subject.

The formal name of the SQL standard is ISO/IEC 9075 "Database Language SQL". The version this document refers to is ISO/IEC 9075:2003, or simply SQL:2003. The versions prior to that were SQL:1999 and SQL-92. Each version supersedes the previous one, so claims of conformance to earlier versions have no official standing.

Starting with SQL:1999, the SQL standard defines a large set of individual features rather than the three levels (Entry, Intermediate and Full) declared in SQL-92. A large subset of these features represents the "Core" (mandatory) features, SQL implementation must supply in order to claim conformance. The rest of the features are purely optional.

In the following sections, we provide a list of all SQL:2003 features with an indication of whether it is supported by the given Firebird version.

Every feature consists of an unique identifier and a name. Feature identifiers containing a hyphen are subfeatures. If a particular subfeature is not supported, the main feature is listed as partly supported. Comments are provided where necessary.

Legend:
  • (+) : feature is supported entirely
  • (−) : feature is not supported
  • (*) : feature is supported partly or it does not conform to the standard completely
  • (?) : we have no clear opinion about conformance (to be reviewed)

The document is subject to periodic updates, so please feed back if you disagree with any marks of conformance.

Mandatory features
 
Feature ID Feature Name v1.5 v2.0 v2.1 v2.5 v3.0 Comments
E011 Numeric data types * * * * *  
E011-01 INTEGER and SMALLINT data types (including all spellings) + + + + +  
E011-02 REAL, DOUBLE PRECISON, and FLOAT data types + + + + +  
E011-03 DECIMAL and NUMERIC data types * * * * * NUMERIC is not compliant and represents almost the same semantics as DECIMAL
E011-04 Arithmetic operators + + + + +  
E011-05 Numeric comparison + + + + +  
E011-06 Implicit casting among the numeric data types + + + + +  
E021 Character string types * * + + +  
E021-01 CHARACTER data type (including all its spellings) + + + + +  
E021-02 CHARACTER VARYING data type (including all its spellings) + + + + +  
E021-03 Character literals + + + + +  
E021-04 CHARACTER_LENGTH function − + + + +  
E021-05 OCTET_LENGTH function − + + + +  
E021-06 SUBSTRING function * + + + + In Firebird 1.5, SUBSTRING does not accept value expressions as its arguments
E021-07 Character concatenation + + + + +  
E021-08 UPPER and LOWER functions * + + + + In Firebird 1.5, LOWER is not supported
E021-09 TRIM function − + + + +  
E021-10 Implicit casting among the fixed-length and variable-length character string types + + + + +  
E021-11 POSITION function − − + + +  
E021-12 Character comparison + + + + +  
E031 Identifiers + + + + +  
E031-01 Delimited identifiers + + + + +  
E031-02 Lower case identifiers + + + + +  
E031-03 Trailing underscore + + + + +  
E051 Basic query specification * * * * *  
E051-01 SELECT DISTINCT + + + + +  
E051-02 GROUP BY clause + + + + +  
E051-04 GROUP BY can contain columns not in + + + + +  
E051-05 Select list items can be renamed + + + + +  
E051-06 HAVING clause + + + + +  
E051-07 Qualified * in select list + + + + +  
E051-08 Correlation names in the FROM clause + + + + + In Firebird 1.5, keyword AS is not supported
E051-09 Rename columns in the FROM clause − * * * * Supported only for derived tables
E061 Basic predicates and search conditions + + + + +  
E061-01 Comparison predicate + + + + +  
E061-02 BETWEEN predicate + + + + +  
E061-03 IN predicate with list of values + + + + +  
E061-04 LIKE predicate + + + + +  
E061-05 LIKE predicate: ESCAPE clause + + + + +  
E061-06 NULL predicate + + + + +  
E061-07 Quantified comparison predicate + + + + +  
E061-08 EXISTS predicate + + + + +  
E061-09 Subqueries in comparison predicate + + + + +  
E061-11 Subqueries in IN predicate + + + + +  
E061-12 Subqueries in quantified comparison predicate + + + + +  
E061-13 Correlated subqueries + + + + +  
E061-14 Search condition + + + + +  
E071 Basic query expressions * * * * *  
E071-01 UNION DISTINCT table operator * + + + + In Firebird 1.5, keyword DISTINCT is not supported, but the default behaviour conforms
E071-02 UNION ALL table operator + + + + +  
E071-03 EXCEPT DISTINCT table operator − − − − −  
E071-05 Columns combined via table operators need not have exactly the same data type − + + + +  
E071-06 Table operators in subqueries − + + + +  
E081 Basic Privileges * * * * +  
E081-01 SELECT privilege at the table level + + + + +  
E081-02 DELETE privilege + + + + +  
E081-03 INSERT privilege at the table level + + + + +  
E081-04 UPDATE privilege at the table level + + + + +  
E081-05 UPDATE privilege at the column level + + + + +  
E081-06 REFERENCES privilege at the table level + + + + +  
E081-07 REFERENCES privilege at the column level + + + + +  
E081-08 WITH GRANT OPTION + + + + +  
E081-09 USAGE privilege − −
−
−
+  
E081-10 EXECUTE privilege + + + + +  
E091 Set functions + + + + +  
E091-01 AVG + + + + +  
E091-02 COUNT + + + + +  
E091-03 MAX + + + + +  
E091-04 MIN + + + + +  
E091-05 SUM + + + + +  
E091-06 ALL quantifier + + + + +  
E091-07 DISTINCT quantifier + + + + +  
E101 Basic data manipulation + + + + +  
E101-01 INSERT statement + + + + +  
E101-03 Searched UPDATE statement + + + + +  
E101-04 Searched DELETE statement + + + + +  
E111 Single row SELECT statement + + + + +  
E121 Basic cursor support * * * * *  
E121-01 DECLARE CURSOR − + + + +  
E121-02 ORDER BY columns need not be in select list + + + + +  
E121-03 Value expressions in ORDER BY clause + + + + +  
E121-04 OPEN statement − + + + +  
E121-06 Positioned UPDATE statement * + + + + In Firebird 1.5, only non-standard FOR SELECT cursors support positioned updates/deletes
E121-07 Positioned DELETE statement * + + + + (same as above)
E121-08 CLOSE statement − + + + +  
E121-10 FETCH statement: implicit NEXT − + + + +  
E121-17 WITH HOLD cursors − − − − −  
E131 Null value support (nulls in lieu of values) − + + + +  
E141 Basic integrity constraints * * * * *  
E141-01 NOT NULL constraints + + + + +  
E141-02 UNIQUE constraints of NOT NULL columns + + + + +  
E141-03 PRIMARY KEY constraints + + + + +  
E141-04 Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action + + + + +  
E141-06 CHECK constraints + + + + +  
E141-07 Column defaults + + + + +  
E141-08 NOT NULL inferred on PRIMARY KEY − + + + +  
E141-10 Names in a foreign key can be specified in any order − − − − −  
E151 Transaction support + + + + +  
E151-01 COMMIT statement + + + + +  
E151-02 ROLLBACK statement + + + + +  
E152 Basic SET TRANSACTION statement * * * * *  
E152-01 SET TRANSACTION statement:
ISOLATION LEVEL SERIALIZABLE clause		 − − − − −  
E152-02 SET TRANSACTION statement:
READ ONLY and READ WRITE clauses		 + + + + +  
E153 Updatable queries with subqueries + + + + +  
E161 SQL comments using leading double minus + + + + +  
E171 SQLSTATE support − − − + +  
E182 Module language − − − − −  
F031 Basic schema manipulation * * * * *  
F031-01 CREATE TABLE statement to create persistent base tables + + + + +  
F031-02 CREATE VIEW statement + + + + +  
F031-03 GRANT statement + + + + +  
F031-04 ALTER TABLE statement:
ADD COLUMN clause		 + + + + +  
F031-13 DROP TABLE statement:
RESTRICT clause		 * * * * * RESTRICT keyword is not supported, but the default behaviour conforms
F031-19 REVOKE statement:
RESTRICT clause		 * * * * * (same as above)
F041 Basic joined table + + + + +  
F041-01 Inner join (but not necessarily the INNER keyword) + + + + +  
F041-02 INNER keyword + + + + +  
F041-03 LEFT OUTER JOIN + + + + +  
F041-04 RIGHT OUTER JOIN + + + + +  
F041-05 Outer joins can be nested + + + + +  
F041-07 The inner table in a left or right outer join can also be used in an inner join + + + + +  
F041-08 All comparison operators are supported (rather than just =) + + + + +  
F051 Basic date and time * * * * *  
F051-01 DATE data type (including support of DATE literal) + + + + +  
F051-02 TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 + + + + +  
F051-03 TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 + + + + +  
F051-04 Comparison predicate on DATE, TIME, and TIMESTAMP data types + + + + +  
F051-05 Explicit CAST between datetime types and character string types + + + + +  
F051-06 CURRENT_DATE + + + + +  
F051-07 LOCALTIME * * * * * Supported as CURRENT_TIME instead
F051-08 LOCALTIMESTAMP * * * * * Supported as CURRENT_TIMESTAMP instead
F081 UNION and EXCEPT in views − * * * * EXCEPT is not supported
F131 Grouped operations + + + + +  
F131-01 WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views + + + + +  
F131-02 Multiple tables supported in queries with grouped views + + + + +  
F131-03 Set functions supported in queries with grouped views + + + + +  
F131-04 Subqueries with GROUP BY and HAVING clauses and grouped views + + + + +  
F131-05 Single row SELECT with GROUP BY and HAVING clauses and grouped views + + + + +  
F181 Multiple module support − − − − −  
F201 CAST function + +        
F221 Explicit defaults − − * * * Supported only as DEFAULT VALUES in INSERT statements
F261 CASE expression + + + + +  
F261-01 Simple CASE + + + + +  
F261-02 Searched CASE + + + + +  
F261-03 NULLIF + + + + +  
F261-04 COALESCE + + + + +  
F311 Schema definition statement − − − − −  
F311-01 CREATE SCHEMA − − − − −  
F311-02 CREATE TABLE for persistent base tables − − − − −  
F311-03 CREATE VIEW − − − − −  
F311-04 CREATE VIEW: WITH CHECK OPTION − − − − −  
F311-05 GRANT statement − − − − −  
F471 Scalar subquery values + + + + +  
F481 Expanded NULL predicate + + + + +  
F812 Basic flagging − −
−
−
−
 
S011 Distinct data types − − − − −  
T321 Basic SQL-invoked routines * * * * *  
T321-01 User-defined functions with no overloading * * * * + Priot to Firebird 3.0, only external (non-SQL) functions were supported
T321-02 User-defined stored procedures with no overloading * * * * + Priot to Firebird 3.0, only SQL procedures were supported
T321-03 Function invocation + + + + +  
T321-04 CALL statement * * * * * Available as EXECUTE PROCEDURE instead
T321-05 RETURN statement * * * * + Available as EXIT in SQL procedures
T631 IN predicate with one list element + + + + +  

Optional features
 
Feature ID Feature Name v1.5 v2.0 v2.1 v2.5 v3.0 Comments
B011 Embedded Ada + + + + +  
B012 Embedded C + + + + +  
B013 Embedded COBOL + + + + +  
B014 Embedded Fortran + + + + +  
B015 Embedded MUMPS − − − − −  
B016 Embedded Pascal + + + + +  
B017 Embedded PL/I − − − − −  
B021 Direct SQL + + + + +  
B031 Basic dynamic SQL * * * * * Not all standard features are supported
B032 Extended dynamic SQL − − − − −  
B032-01 − −        
B033 Untyped SQL-invoked function arguments − − − − −  
B034 Dynamic specification of cursor attributes − − − − −  
B041 Extensions to embedded SQL exception declarations − − − − −  
B051 Enhanced execution rights − − − − −  
B111 Module language Ada − − − − −  
B112 Module language C − − − − −  
B113 Module language COBOL − − − − −  
B114 Module language Fortran − − − − −  
B115 Module language MUMPS − − − − −  
B116 Module language Pascal − − − − −  
B117 Module language PL/I − − − − −  
B121 Routine language Ada − − − − +  
B122 Routine language C + + + + +  
B123 Routine language COBOL − − − − +  
B124 Routine language Fortran − − − − +  
B125 Routine language MUMPS − − − − +  
B126 Routine language Pascal + + + + +  
B127 Routine language PL/I − − − − +  
B128 Routine language SQL + + + + +  
F032 CASCADE drop behavior − − − − −  
F033 ALTER TABLE statement:
DROP COLUMN clause		 + + + + +  
F034 Extended REVOKE statement * * * * * REVOKE CASCADE is not supported
F034-01 REVOKE statement performed by other than the owner of a schema object + + + + +  
F034-02 REVOKE statement:
GRANT OPTION FOR clause		 + + + + +  
F034-03 REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION ? ? ? ? ?  
F052 Intervals and datetime arithmetic * * * * * Intervals are not supported
F053 OVERLAPS predicate − − − − −  
F111 Isolation levels other than SERIALIZABLE * * * * *  
F111-01 READ UNCOMMITTED isolation level − − − − −  
F111-02 READ COMMITTED isolation level + + + + +  
F111-03 REPEATABLE READ isolation level + + + + + Available as SNAPSHOT
F121 Basic diagnostics management − − − − −  
F121-01 GET DIAGNOSTICS statement − − − − −  
F121-02 SET TRANSACTION statement: DIAGNOSTICS SIZE clause − − − − −  
F171 Multiple schemas per user − − − − −  
F191 Referential delete actions + + + + +  
F222 INSERT statement:
DEFAULT VALUES clause		 − − + + +  
F231 Privilege tables − − − − −  
F231-01 TABLE_PRIVILEGES view − − − − −  
F231-02 COLUMN_PRIVILEGES view − − − − −  
F231-03 USAGE_PRIVILEGES view − − − − −  
F251 Domain support + + + + +  
F262 Extended CASE expression − − − − −  
F263 Comma-separated predicates in simple CASE expression − − − − −  
F271 Compound character literals − − − − −  
F281 LIKE enhancements + + + + +  
F291 UNIQUE predicate − −
−
− −  
F301 CORRESPONDING in query expressions − − − − −  
F302 INTERSECT table operator − − − − −  
F302-01 INTERSECT DISTINCT table operator − − − − −  
F302-02 INTERSECT ALL table operator − − − − −  
F304 EXCEPT ALL table operator − − − − −  
F312 MERGE statement − − + + +  
F321 User authorization * * * * * Only CURRENT_USER is supported
F341 Usage tables ? ? ? ? ?  
F361 Subprogram support ? ? ? ? ?  
F381 Extended schema manipulation + + + + +  
F381-01 ALTER TABLE statement:
ALTER COLUMN clause		 + + + + +  
F381-02 ALTER TABLE statement:
ADD CONSTRAINT clause		 + + + + +  
F381-03 ALTER TABLE statement:
DROP CONSTRAINT clause		 + + + + +  
F391 Long identifiers * * * * * Maximum identifier length is equal to 31
F392 Unicode escapes in identifiers − − − − −  
F393 Unicode escapes in literals − − − − −  
F401 Extended joined table * * + + +  
F401-01 NATURAL JOIN − − + + +  
F401-02 FULL OUTER JOIN + + + + +  
F401-04 CROSS JOIN − + + + +  
F402 Named column joins for LOBs, arrays, and multisets − − − − −  
F411 Time zone specification − − − − −  
F421 National character * * * * * Neither national string literals nor NCHAR VARYING datatype are supported
F431 Read-only scrollable cursors − − − − +  
F431-01 FETCH with explicit NEXT − − − − +  
F431-02 FETCH FIRST − − − − +  
F431-03 FETCH LAST − − − − +  
F431-04 FETCH PRIOR − − − − +  
F431-05 FETCH ABSOLUTE − − − − +  
F431-06 FETCH RELATIVE − − − − +  
F441 Extended set function support + + + + +  
F442 Mixed column references in set functions + + + + +  
F451 Character set definition − − − − −  
F461 Named character sets + + + + +  
F491 Constraint management + + + + +  
F502 Enhanced documentation tables − − − − −  
F502-01 SQL_SIZING_PROFILES view − − − − −  
F502-02 SQL_IMPLEMENTATION_INFO view − − − − −  
F502-03 SQL_PACKAGES view − − − − −  
F521 Assertions − − − − −  
F531 Temporary tables − − * * * Only global temporary tables are supported
F555 Enhanced seconds precision * * * * * Maximum supported precision is equal to 3, precision in datatype declarations are not supported
F561 Full value expressions + + + + +  
F571 Truth value tests − − − − +  
F591 Derived tables − + + + +  
F611 Indicator data types − − − − −  
F641 Row and table constructors − − − − −  
F651 Catalog name qualifiers − − − − −  
F661 Simple tables − − − − −  
F671 Subqueries in CHECK + + + + +  
F672 Retrospective check constraints + + + + +  
F691 Collation and translation * * * + + Prior to Firebird 2.5, CREATE/DROP COLLATION was not supported
F692 Enhanced collation support + + + + +  
F693 SQL-session and client module collations − − − − −  
F695 Translation support − − − − −  
F696 Additional translation documentation − − − − −  
F701 Referential update actions + + + + +  
F711 ALTER domain + + + + +  
F721 Deferrable constraints − − − − −
F731 INSERT column privileges − − − − −  
F741 Referential MATCH types − − − − −  
F751 View CHECK enhancements − − − − −  
F761 Session management − − − − −  
F771 Connection management − − − − −  
F781 Self-referencing operations + + + + +  
F791 Insensitive cursors − − − − −  
F801 Full set function − − − − −  
F813 Extended flagging − − − − −  
F821 Local table references − − − − −  
F831 Full cursor update − − − − −  
F831-01 Updateable scrollable cursors − − − − −  
F831-02 Updateable ordered cursors − − − − −  
S023 Basic structured types − − − − −  
S024 Enhanced structured types − − − − −  
S025 Final structured types − − − − −  
S026 Self-referencing structured types − − − − −  
S027 Create method by specific method name − − − − −  
S028 Permutable UDT options list − − − − −  
S041 Basic reference types − − − − −  
S043 Enhanced reference types − − − − −  
S051 Create table of type − − − − −  
S071 SQL paths in function and type name resolution − − − − −  
S081 Subtables − − − − −  
S091 Basic array support * * * * *  
S091-01 Arrays of built-in data types * * * * * Implementation is non-standard and limited to DSQL only
S091-02 Arrays of distinct types − − − − −  
S091-03 Array expressions − − − − −  
S092 Arrays of user-defined types − − − − −  
S094 Arrays of reference types − − − − −  
S095 Array constructors by query − − − − −  
S096 Optional array bounds − − − − −  
S097 Array element assignment − − − − −  
S111 ONLY in query expressions − − − − −  
S151 Type predicate − − − − −  
S161 Subtype treatment − − − − −  
S162 Subtype treatment for references − − − − −  
S201 SQL-invoked routines on arrays − − − − −  
S201-01 Array parameters − − − − −  
S201-02 Array as result type of functions − − − − −  
S202 SQL-invoked routines on multisets − − − − −  
S211 User-defined cast functions − − − − −  
S231 Structured type locators − − − − −  
S232 Array locators − − − − −  
S233 Multiset locators − − − − −  
S241 Transform functions − − − − −  
S242 Alter transform statement − − − − −  
S251 User-defined orderings − − − − −  
S261 Specific type method − − − − −  
S271 Basic multiset support − − − − −  
S272 Multisets of user-defined types − − − − −  
S274 Multisets of reference types − − − − −  
S275 Advanced multiset support − − − − −  
S281 Nested collection types − − − − −  
S291 Unique constraint on entire row − − − − −  
T011 Timestamp in Information Schema − − − − −  
T031 BOOLEAN data type − − − − +  
T041 Basic LOB data type support * * * * *  
T041-01 BLOB data type + + + + +  
T041-02 CLOB data type * * * * * Available as BLOB SUB_TYPE TEXT
T041-03 POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types * * + + + Partially supported
T041-04 Concatenation of LOB data types − − − − −
T041-05 LOB locator: non-holdable − − − − −  
T042 Extended LOB data type support − − − − −  
T051 Row types − − − − −  
T052 MAX and MIN for row types − − − − −  
T053 Explicit aliases for all-fields reference − − − − −  
T061 UCS support − − − − −  
T071 BIGINT data type + + + + +  
T111 Updatable joins, unions, and columns − − − − −  
T121 WITH (excluding RECURSIVE) in query expression − − + + +  
T122 WITH (excluding RECURSIVE) in subquery − − − − −
T131 Recursive query − − + + +  
T132 Recursive query in subquery − − − − −  
T141 SIMILAR predicate − − − + +  
T151 DISTINCT predicate − + + + +  
T152 DISTINCT predicate with negation − + + + +  
T171 LIKE clause in table definition − − − − −  
T172 AS subquery clause in table definition − − − − −  
T173 Extended LIKE clause in table definition − − − − −  
T174 Identity columns − − − − +  
T175 Generated columns * * * * + Supported as computed columns
T176 Sequence generator support + + + + +  
T191 Referential action RESTRICT + + + + +  
T201 Comparable data types for referential constraints * * * * * Numerics, timestamps and strings are not considered comparable
T211 Basic trigger capability * * * * *  
T211-01 Triggers activated on UPDATE, INSERT, or DELETE of one base table + + + + +  
T211-02 BEFORE triggers + + + + +  
T211-03 AFTER triggers + + + + +  
T211-04 FOR EACH ROW triggers + + + + +  
T211-05 Ability to specify a search condition that shall be True before the trigger is invoked − − − − −  
T211-06 Support for run-time rules for the interaction of triggers and constraints ? ? ? ? ?  
T211-07 TRIGGER privilege − − − − −  
T211-08 Multiple triggers for the same event are executed in the order in which they were
created in the catalog		 * * * * * Execution order is specified by the developer
T212 Enhanced trigger capability − − − − −  
T231 Sensitive cursors − − − − −  
T241 START TRANSACTION statement + + + + + Available as SET TRANSACTION
T251 SET TRANSACTION statement: LOCAL option − − − − −  
T261 Chained transactions − − − − −  
T271 Savepoints + + + + +  
T272 Enhanced savepoint management − − − − −  
T281 SELECT privilege with column granularity − − − − −  
T301 Functional dependencies + + + + +  
T312 OVERLAY function − − − − −  
T322 Overloading of SQL-invoked functions and procedures − − − − −  
T323 Explicit security for external routines − − − − −  
T324 Explicit security for SQL routines − − − − −  
T325 Qualified SQL parameter references − − − − −  
T326 Table functions − − − − −  
T331 Basic roles * * * * + Prior to Firebird 3.0, SET ROLE was not supported
T332 Extended roles * * * * * GRANTED BY CURRENT_ROLE is not supported
T351 Bracketed SQL comments (/*...*/ comments) + + + + +  
T431 Extended grouping capabilities − − − − −  
T432 Nested and concatenated GROUPING SETS − − − − −  
T433 Multi-argument GROUPING function − − − − −  
T434 GROUP BY DISTINCT − − − − −  
T441 ABS and MOD functions − − + + +  
T461 Symmetric BETWEEN predicate − − − − −  
T471 Result sets return value − − − − −  
T491 LATERAL derived table − − − − −  
T501 Enhanced EXISTS predicate + + + + +  
T511 Transaction counts − − − − −  
T551 Optional keywords for default syntax + + + + +  
T561 Holdable locators − − − − −  
T571 Array-returning external SQL-invoked functions − − − − −  
T572 Multiset-returning external SQL-invoked functions − − − − −  
T581 Regular expression substring function − − − − +  
T591 UNIQUE constraints of possibly null columns + + + + +  
T601 Local cursor references − − − − −  
T611 Elementary OLAP operations − − − − −  
T612 Advanced OLAP operations − − − − −  
T613 Sampling − − − − −  
T621 Enhanced numeric functions − − − − −  
T641 Multiple column assignment − − − − −  
T651 SQL-schema statements in SQL routines − − − − −  
T652 SQL-dynamic statements in SQL routines + + + + +  
T653 SQL-schema statements in external routines − − − − −  
T654 SQL-dynamic statements in external routines − − − − +  
T655  Cyclically dependent routines + + + + +  

Assembled by Dmitry Yemanov. Last updated: November 5, 2016.

This document outlines how much Firebird conforms to the current SQL standard. Please note that the following information is not a full statement of conformance, but just information for those interested in the subject.

The formal name of the SQL standard is ISO/IEC 9075 "Database Language SQL". The version this document refers to is ISO/IEC 9075:2003, or simply SQL:2003. The versions prior to that were SQL:1999 and SQL-92. Each version supersedes the previous one, so claims of conformance to earlier versions have no official standing.

Starting with SQL:1999, the SQL standard defines a large set of individual features rather than the three levels (Entry, Intermediate and Full) declared in SQL-92. A large subset of these features represents the "Core" (mandatory) features, SQL implementation must supply in order to claim conformance. The rest of the features are purely optional.

In the following sections, we provide a list of all SQL:2003 features with an indication of whether it is supported by the given Firebird version.

Every feature consists of an unique identifier and a name. Feature identifiers containing a hyphen are subfeatures. If a particular subfeature is not supported, the main feature is listed as partly supported. Comments are provided where necessary.

Legend:

  • (+) : feature is supported entirely
  • (−) : feature is not supported
  • (*) : feature is supported partly or it does not conform to the standard completely
  • (?) : we have no clear opinion about conformance (to be reviewed)

The document is subject to periodic updates, so please feed back if you disagree with any marks of conformance.

Mandatory features
 
  • Feature ID: E011
  • Feature Name: Numeric data types
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments:  
  • Feature ID: E011-01
  • Feature Name: INTEGER and SMALLINT data types (including all spellings)
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E011-02
  • Feature Name: REAL, DOUBLE PRECISON, and FLOAT data types
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E011-03
  • Feature Name: DECIMAL and NUMERIC data types
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: NUMERIC is not compliant and represents almost the same semantics as DECIMAL
  • Feature ID: E011-04
  • Feature Name: Arithmetic operators
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E011-05
  • Feature Name: Numeric comparison
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E011-06
  • Feature Name: Implicit casting among the numeric data types
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E021
  • Feature Name: Character string types
  • v1.5: *
  • v2.0: *
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E021-01
  • Feature Name: CHARACTER data type (including all its spellings)
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E021-02
  • Feature Name: CHARACTER VARYING data type (including all its spellings)
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E021-03
  • Feature Name: Character literals
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E021-04
  • Feature Name: CHARACTER_LENGTH function
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E021-05
  • Feature Name: OCTET_LENGTH function
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E021-06
  • Feature Name: SUBSTRING function
  • v1.5: *
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments: In Firebird 1.5, SUBSTRING does not accept value expressions as its arguments
  • Feature ID: E021-07
  • Feature Name: Character concatenation
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E021-08
  • Feature Name: UPPER and LOWER functions
  • v1.5: *
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments: In Firebird 1.5, LOWER is not supported
  • Feature ID: E021-09
  • Feature Name: TRIM function
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E021-10
  • Feature Name: Implicit casting among the fixed-length and variable-length character string types
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E021-11
  • Feature Name: POSITION function
  • v1.5: −
  • v2.0: −
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E021-12
  • Feature Name: Character comparison
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E031
  • Feature Name: Identifiers
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E031-01
  • Feature Name: Delimited identifiers
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E031-02
  • Feature Name: Lower case identifiers
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E031-03
  • Feature Name: Trailing underscore
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E051
  • Feature Name: Basic query specification
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments:  
  • Feature ID: E051-01
  • Feature Name: SELECT DISTINCT
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E051-02
  • Feature Name: GROUP BY clause
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E051-04
  • Feature Name: GROUP BY can contain columns not in
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E051-05
  • Feature Name: Select list items can be renamed
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E051-06
  • Feature Name: HAVING clause
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E051-07
  • Feature Name: Qualified * in select list
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E051-08
  • Feature Name: Correlation names in the FROM clause
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments: In Firebird 1.5, keyword AS is not supported
  • Feature ID: E051-09
  • Feature Name: Rename columns in the FROM clause
  • v1.5: −
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Supported only for derived tables
  • Feature ID: E061
  • Feature Name: Basic predicates and search conditions
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E061-01
  • Feature Name: Comparison predicate
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E061-02
  • Feature Name: BETWEEN predicate
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E061-03
  • Feature Name: IN predicate with list of values
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E061-04
  • Feature Name: LIKE predicate
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E061-05
  • Feature Name: LIKE predicate: ESCAPE clause
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E061-06
  • Feature Name: NULL predicate
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E061-07
  • Feature Name: Quantified comparison predicate
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E061-08
  • Feature Name: EXISTS predicate
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E061-09
  • Feature Name: Subqueries in comparison predicate
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E061-11
  • Feature Name: Subqueries in IN predicate
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E061-12
  • Feature Name: Subqueries in quantified comparison predicate
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E061-13
  • Feature Name: Correlated subqueries
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E061-14
  • Feature Name: Search condition
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E071
  • Feature Name: Basic query expressions
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments:  
  • Feature ID: E071-01
  • Feature Name: UNION DISTINCT table operator
  • v1.5: *
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments: In Firebird 1.5, keyword DISTINCT is not supported, but the default behaviour conforms
  • Feature ID: E071-02
  • Feature Name: UNION ALL table operator
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E071-03
  • Feature Name: EXCEPT DISTINCT table operator
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: E071-05
  • Feature Name: Columns combined via table operators need not have exactly the same data type
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E071-06
  • Feature Name: Table operators in subqueries
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E081
  • Feature Name: Basic Privileges
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: +
  • Comments:  
  • Feature ID: E081-01
  • Feature Name: SELECT privilege at the table level
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E081-02
  • Feature Name: DELETE privilege
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E081-03
  • Feature Name: INSERT privilege at the table level
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E081-04
  • Feature Name: UPDATE privilege at the table level
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E081-05
  • Feature Name: UPDATE privilege at the column level
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E081-06
  • Feature Name: REFERENCES privilege at the table level
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E081-07
  • Feature Name: REFERENCES privilege at the column level
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E081-08
  • Feature Name: WITH GRANT OPTION
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E081-09
  • Feature Name: USAGE privilege
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments: −
  • Feature ID: −
  • Feature Name:
  • v1.5:
  • v2.0:
  • v2.1:
  • v2.5:
  • v3.0:
  • Comments:
  • Feature ID: −
  • Feature Name:
  • v1.5:
  • v2.0:
  • v2.1:
  • v2.5:
  • v3.0:
  • Comments:
  • Feature ID: E081-10
  • Feature Name: EXECUTE privilege
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E091
  • Feature Name: Set functions
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E091-01
  • Feature Name: AVG
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E091-02
  • Feature Name: COUNT
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E091-03
  • Feature Name: MAX
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E091-04
  • Feature Name: MIN
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E091-05
  • Feature Name: SUM
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E091-06
  • Feature Name: ALL quantifier
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E091-07
  • Feature Name: DISTINCT quantifier
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E101
  • Feature Name: Basic data manipulation
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E101-01
  • Feature Name: INSERT statement
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E101-03
  • Feature Name: Searched UPDATE statement
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E101-04
  • Feature Name: Searched DELETE statement
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E111
  • Feature Name: Single row SELECT statement
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E121
  • Feature Name: Basic cursor support
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments:  
  • Feature ID: E121-01
  • Feature Name: DECLARE CURSOR
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E121-02
  • Feature Name: ORDER BY columns need not be in select list
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E121-03
  • Feature Name: Value expressions in ORDER BY clause
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E121-04
  • Feature Name: OPEN statement
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E121-06
  • Feature Name: Positioned UPDATE statement
  • v1.5: *
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments: In Firebird 1.5, only non-standard FOR SELECT cursors support positioned updates/deletes
  • Feature ID: E121-07
  • Feature Name: Positioned DELETE statement
  • v1.5: *
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments: (same as above)
  • Feature ID: E121-08
  • Feature Name: CLOSE statement
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E121-10
  • Feature Name: FETCH statement: implicit NEXT
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E121-17
  • Feature Name: WITH HOLD cursors
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: E131
  • Feature Name: Null value support (nulls in lieu of values)
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E141
  • Feature Name: Basic integrity constraints
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments:  
  • Feature ID: E141-01
  • Feature Name: NOT NULL constraints
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E141-02
  • Feature Name: UNIQUE constraints of NOT NULL columns
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E141-03
  • Feature Name: PRIMARY KEY constraints
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E141-04
  • Feature Name: Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E141-06
  • Feature Name: CHECK constraints
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E141-07
  • Feature Name: Column defaults
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E141-08
  • Feature Name: NOT NULL inferred on PRIMARY KEY
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E141-10
  • Feature Name: Names in a foreign key can be specified in any order
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: E151
  • Feature Name: Transaction support
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E151-01
  • Feature Name: COMMIT statement
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E151-02
  • Feature Name: ROLLBACK statement
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E152
  • Feature Name: Basic SET TRANSACTION statement
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments:  
  • Feature ID: E152-01
  • Feature Name: SET TRANSACTION statement:
    ISOLATION LEVEL SERIALIZABLE clause
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: E152-02
  • Feature Name: SET TRANSACTION statement:
    READ ONLY and READ WRITE clauses
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E153
  • Feature Name: Updatable queries with subqueries
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E161
  • Feature Name: SQL comments using leading double minus
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E171
  • Feature Name: SQLSTATE support
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: E182
  • Feature Name: Module language
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F031
  • Feature Name: Basic schema manipulation
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments:  
  • Feature ID: F031-01
  • Feature Name: CREATE TABLE statement to create persistent base tables
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F031-02
  • Feature Name: CREATE VIEW statement
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F031-03
  • Feature Name: GRANT statement
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F031-04
  • Feature Name: ALTER TABLE statement:
    ADD COLUMN clause
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F031-13
  • Feature Name: DROP TABLE statement:
    RESTRICT clause
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: RESTRICT keyword is not supported, but the default behaviour conforms
  • Feature ID: F031-19
  • Feature Name: REVOKE statement:
    RESTRICT clause
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: (same as above)
  • Feature ID: F041
  • Feature Name: Basic joined table
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F041-01
  • Feature Name: Inner join (but not necessarily the INNER keyword)
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F041-02
  • Feature Name: INNER keyword
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F041-03
  • Feature Name: LEFT OUTER JOIN
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F041-04
  • Feature Name: RIGHT OUTER JOIN
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F041-05
  • Feature Name: Outer joins can be nested
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F041-07
  • Feature Name: The inner table in a left or right outer join can also be used in an inner join
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F041-08
  • Feature Name: All comparison operators are supported (rather than just =)
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F051
  • Feature Name: Basic date and time
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments:  
  • Feature ID: F051-01
  • Feature Name: DATE data type (including support of DATE literal)
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F051-02
  • Feature Name: TIME data type (including support of TIME literal) with fractional seconds precision of at least 0
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F051-03
  • Feature Name: TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F051-04
  • Feature Name: Comparison predicate on DATE, TIME, and TIMESTAMP data types
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F051-05
  • Feature Name: Explicit CAST between datetime types and character string types
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F051-06
  • Feature Name: CURRENT_DATE
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F051-07
  • Feature Name: LOCALTIME
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Supported as CURRENT_TIME instead
  • Feature ID: F051-08
  • Feature Name: LOCALTIMESTAMP
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Supported as CURRENT_TIMESTAMP instead
  • Feature ID: F081
  • Feature Name: UNION and EXCEPT in views
  • v1.5: −
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: EXCEPT is not supported
  • Feature ID: F131
  • Feature Name: Grouped operations
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F131-01
  • Feature Name: WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F131-02
  • Feature Name: Multiple tables supported in queries with grouped views
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F131-03
  • Feature Name: Set functions supported in queries with grouped views
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F131-04
  • Feature Name: Subqueries with GROUP BY and HAVING clauses and grouped views
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F131-05
  • Feature Name: Single row SELECT with GROUP BY and HAVING clauses and grouped views
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F181
  • Feature Name: Multiple module support
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F201
  • Feature Name: CAST function
  • v1.5: +
  • v2.0: +
  • v2.1:  
  • v2.5:  
  • v3.0:  
  • Comments:  
  • Feature ID: F221
  • Feature Name: Explicit defaults
  • v1.5: −
  • v2.0: −
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Supported only as DEFAULT VALUES in INSERT statements
  • Feature ID: F261
  • Feature Name: CASE expression
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F261-01
  • Feature Name: Simple CASE
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F261-02
  • Feature Name: Searched CASE
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F261-03
  • Feature Name: NULLIF
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F261-04
  • Feature Name: COALESCE
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F311
  • Feature Name: Schema definition statement
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F311-01
  • Feature Name: CREATE SCHEMA
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F311-02
  • Feature Name: CREATE TABLE for persistent base tables
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F311-03
  • Feature Name: CREATE VIEW
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F311-04
  • Feature Name: CREATE VIEW: WITH CHECK OPTION
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F311-05
  • Feature Name: GRANT statement
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F471
  • Feature Name: Scalar subquery values
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F481
  • Feature Name: Expanded NULL predicate
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F812
  • Feature Name: Basic flagging
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments: −
  • Feature ID: −
  • Feature Name:
  • v1.5:
  • v2.0:
  • v2.1:
  • v2.5:
  • v3.0:
  • Comments:
  • Feature ID: −
  • Feature Name:
  • v1.5:
  • v2.0:
  • v2.1:
  • v2.5:
  • v3.0:
  • Comments:
  • Feature ID: −
  • Feature Name:
  • v1.5:
  • v2.0:
  • v2.1:
  • v2.5:
  • v3.0:
  • Comments:
  • Feature ID: S011
  • Feature Name: Distinct data types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T321
  • Feature Name: Basic SQL-invoked routines
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments:  
  • Feature ID: T321-01
  • Feature Name: User-defined functions with no overloading
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: +
  • Comments: Priot to Firebird 3.0, only external (non-SQL) functions were supported
  • Feature ID: T321-02
  • Feature Name: User-defined stored procedures with no overloading
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: +
  • Comments: Priot to Firebird 3.0, only SQL procedures were supported
  • Feature ID: T321-03
  • Feature Name: Function invocation
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T321-04
  • Feature Name: CALL statement
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Available as EXECUTE PROCEDURE instead
  • Feature ID: T321-05
  • Feature Name: RETURN statement
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: +
  • Comments: Available as EXIT in SQL procedures
  • Feature ID: T631
  • Feature Name: IN predicate with one list element
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  

Optional features
 
  • Feature ID: B011
  • Feature Name: Embedded Ada
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: B012
  • Feature Name: Embedded C
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: B013
  • Feature Name: Embedded COBOL
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: B014
  • Feature Name: Embedded Fortran
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: B015
  • Feature Name: Embedded MUMPS
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: B016
  • Feature Name: Embedded Pascal
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: B017
  • Feature Name: Embedded PL/I
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: B021
  • Feature Name: Direct SQL
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: B031
  • Feature Name: Basic dynamic SQL
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Not all standard features are supported
  • Feature ID: B032
  • Feature Name: Extended dynamic SQL
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: B032-01
  • Feature Name:
  • v1.5: −
  • v2.0: −
  • v2.1:  
  • v2.5:  
  • v3.0:  
  • Comments:  
  • Feature ID: B033
  • Feature Name: Untyped SQL-invoked function arguments
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: B034
  • Feature Name: Dynamic specification of cursor attributes
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: B041
  • Feature Name: Extensions to embedded SQL exception declarations
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: B051
  • Feature Name: Enhanced execution rights
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: B111
  • Feature Name: Module language Ada
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: B112
  • Feature Name: Module language C
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: B113
  • Feature Name: Module language COBOL
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: B114
  • Feature Name: Module language Fortran
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: B115
  • Feature Name: Module language MUMPS
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: B116
  • Feature Name: Module language Pascal
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: B117
  • Feature Name: Module language PL/I
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: B121
  • Feature Name: Routine language Ada
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: B122
  • Feature Name: Routine language C
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: B123
  • Feature Name: Routine language COBOL
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: B124
  • Feature Name: Routine language Fortran
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: B125
  • Feature Name: Routine language MUMPS
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: B126
  • Feature Name: Routine language Pascal
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: B127
  • Feature Name: Routine language PL/I
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: B128
  • Feature Name: Routine language SQL
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F032
  • Feature Name: CASCADE drop behavior
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F033
  • Feature Name: ALTER TABLE statement:
    DROP COLUMN clause
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F034
  • Feature Name: Extended REVOKE statement
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: REVOKE CASCADE is not supported
  • Feature ID: F034-01
  • Feature Name: REVOKE statement performed by other than the owner of a schema object
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F034-02
  • Feature Name: REVOKE statement:
    GRANT OPTION FOR clause
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F034-03
  • Feature Name: REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION
  • v1.5: ?
  • v2.0: ?
  • v2.1: ?
  • v2.5: ?
  • v3.0: ?
  • Comments:  
  • Feature ID: F052
  • Feature Name: Intervals and datetime arithmetic
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Intervals are not supported
  • Feature ID: F053
  • Feature Name: OVERLAPS predicate
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F111
  • Feature Name: Isolation levels other than SERIALIZABLE
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments:  
  • Feature ID: F111-01
  • Feature Name: READ UNCOMMITTED isolation level
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F111-02
  • Feature Name: READ COMMITTED isolation level
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F111-03
  • Feature Name: REPEATABLE READ isolation level
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments: Available as SNAPSHOT
  • Feature ID: F121
  • Feature Name: Basic diagnostics management
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F121-01
  • Feature Name: GET DIAGNOSTICS statement
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F121-02
  • Feature Name: SET TRANSACTION statement: DIAGNOSTICS SIZE clause
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F171
  • Feature Name: Multiple schemas per user
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F191
  • Feature Name: Referential delete actions
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F222
  • Feature Name: INSERT statement:
    DEFAULT VALUES clause
  • v1.5: −
  • v2.0: −
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F231
  • Feature Name: Privilege tables
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F231-01
  • Feature Name: TABLE_PRIVILEGES view
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F231-02
  • Feature Name: COLUMN_PRIVILEGES view
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F231-03
  • Feature Name: USAGE_PRIVILEGES view
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F251
  • Feature Name: Domain support
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F262
  • Feature Name: Extended CASE expression
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F263
  • Feature Name: Comma-separated predicates in simple CASE expression
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F271
  • Feature Name: Compound character literals
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F281
  • Feature Name: LIKE enhancements
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F291
  • Feature Name: UNIQUE predicate
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments: −
  • Feature ID: −
  • Feature Name:
  • v1.5:
  • v2.0:
  • v2.1:
  • v2.5:
  • v3.0:
  • Comments:
  • Feature ID: F301
  • Feature Name: CORRESPONDING in query expressions
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F302
  • Feature Name: INTERSECT table operator
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F302-01
  • Feature Name: INTERSECT DISTINCT table operator
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F302-02
  • Feature Name: INTERSECT ALL table operator
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F304
  • Feature Name: EXCEPT ALL table operator
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F312
  • Feature Name: MERGE statement
  • v1.5: −
  • v2.0: −
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F321
  • Feature Name: User authorization
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Only CURRENT_USER is supported
  • Feature ID: F341
  • Feature Name: Usage tables
  • v1.5: ?
  • v2.0: ?
  • v2.1: ?
  • v2.5: ?
  • v3.0: ?
  • Comments:  
  • Feature ID: F361
  • Feature Name: Subprogram support
  • v1.5: ?
  • v2.0: ?
  • v2.1: ?
  • v2.5: ?
  • v3.0: ?
  • Comments:  
  • Feature ID: F381
  • Feature Name: Extended schema manipulation
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F381-01
  • Feature Name: ALTER TABLE statement:
    ALTER COLUMN clause
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F381-02
  • Feature Name: ALTER TABLE statement:
    ADD CONSTRAINT clause
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F381-03
  • Feature Name: ALTER TABLE statement:
    DROP CONSTRAINT clause
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F391
  • Feature Name: Long identifiers
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Maximum identifier length is equal to 31
  • Feature ID: F392
  • Feature Name: Unicode escapes in identifiers
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F393
  • Feature Name: Unicode escapes in literals
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F401
  • Feature Name: Extended joined table
  • v1.5: *
  • v2.0: *
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F401-01
  • Feature Name: NATURAL JOIN
  • v1.5: −
  • v2.0: −
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F401-02
  • Feature Name: FULL OUTER JOIN
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F401-04
  • Feature Name: CROSS JOIN
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F402
  • Feature Name: Named column joins for LOBs, arrays, and multisets
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F411
  • Feature Name: Time zone specification
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F421
  • Feature Name: National character
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Neither national string literals nor NCHAR VARYING datatype are supported
  • Feature ID: F431
  • Feature Name: Read-only scrollable cursors
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: F431-01
  • Feature Name: FETCH with explicit NEXT
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: F431-02
  • Feature Name: FETCH FIRST
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: F431-03
  • Feature Name: FETCH LAST
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: F431-04
  • Feature Name: FETCH PRIOR
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: F431-05
  • Feature Name: FETCH ABSOLUTE
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: F431-06
  • Feature Name: FETCH RELATIVE
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: F441
  • Feature Name: Extended set function support
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F442
  • Feature Name: Mixed column references in set functions
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F451
  • Feature Name: Character set definition
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F461
  • Feature Name: Named character sets
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F491
  • Feature Name: Constraint management
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F502
  • Feature Name: Enhanced documentation tables
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F502-01
  • Feature Name: SQL_SIZING_PROFILES view
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F502-02
  • Feature Name: SQL_IMPLEMENTATION_INFO view
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F502-03
  • Feature Name: SQL_PACKAGES view
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F521
  • Feature Name: Assertions
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F531
  • Feature Name: Temporary tables
  • v1.5: −
  • v2.0: −
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Only global temporary tables are supported
  • Feature ID: F555
  • Feature Name: Enhanced seconds precision
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Maximum supported precision is equal to 3, precision in datatype declarations are not supported
  • Feature ID: F561
  • Feature Name: Full value expressions
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F571
  • Feature Name: Truth value tests
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: F591
  • Feature Name: Derived tables
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F611
  • Feature Name: Indicator data types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F641
  • Feature Name: Row and table constructors
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F651
  • Feature Name: Catalog name qualifiers
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F661
  • Feature Name: Simple tables
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F671
  • Feature Name: Subqueries in CHECK
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F672
  • Feature Name: Retrospective check constraints
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F691
  • Feature Name: Collation and translation
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: +
  • v3.0: +
  • Comments: Prior to Firebird 2.5, CREATE/DROP COLLATION was not supported
  • Feature ID: F692
  • Feature Name: Enhanced collation support
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F693
  • Feature Name: SQL-session and client module collations
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F695
  • Feature Name: Translation support
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F696
  • Feature Name: Additional translation documentation
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F701
  • Feature Name: Referential update actions
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F711
  • Feature Name: ALTER domain
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F721
  • Feature Name: Deferrable constraints
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:
  • Feature ID: F731
  • Feature Name: INSERT column privileges
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F741
  • Feature Name: Referential MATCH types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F751
  • Feature Name: View CHECK enhancements
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F761
  • Feature Name: Session management
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F771
  • Feature Name: Connection management
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F781
  • Feature Name: Self-referencing operations
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: F791
  • Feature Name: Insensitive cursors
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F801
  • Feature Name: Full set function
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F813
  • Feature Name: Extended flagging
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F821
  • Feature Name: Local table references
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F831
  • Feature Name: Full cursor update
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F831-01
  • Feature Name: Updateable scrollable cursors
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: F831-02
  • Feature Name: Updateable ordered cursors
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S023
  • Feature Name: Basic structured types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S024
  • Feature Name: Enhanced structured types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S025
  • Feature Name: Final structured types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S026
  • Feature Name: Self-referencing structured types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S027
  • Feature Name: Create method by specific method name
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S028
  • Feature Name: Permutable UDT options list
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S041
  • Feature Name: Basic reference types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S043
  • Feature Name: Enhanced reference types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S051
  • Feature Name: Create table of type
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S071
  • Feature Name: SQL paths in function and type name resolution
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S081
  • Feature Name: Subtables
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S091
  • Feature Name: Basic array support
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments:  
  • Feature ID: S091-01
  • Feature Name: Arrays of built-in data types
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Implementation is non-standard and limited to DSQL only
  • Feature ID: S091-02
  • Feature Name: Arrays of distinct types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S091-03
  • Feature Name: Array expressions
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S092
  • Feature Name: Arrays of user-defined types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S094
  • Feature Name: Arrays of reference types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S095
  • Feature Name: Array constructors by query
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S096
  • Feature Name: Optional array bounds
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S097
  • Feature Name: Array element assignment
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S111
  • Feature Name: ONLY in query expressions
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S151
  • Feature Name: Type predicate
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S161
  • Feature Name: Subtype treatment
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S162
  • Feature Name: Subtype treatment for references
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S201
  • Feature Name: SQL-invoked routines on arrays
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S201-01
  • Feature Name: Array parameters
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S201-02
  • Feature Name: Array as result type of functions
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S202
  • Feature Name: SQL-invoked routines on multisets
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S211
  • Feature Name: User-defined cast functions
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S231
  • Feature Name: Structured type locators
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S232
  • Feature Name: Array locators
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S233
  • Feature Name: Multiset locators
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S241
  • Feature Name: Transform functions
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S242
  • Feature Name: Alter transform statement
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S251
  • Feature Name: User-defined orderings
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S261
  • Feature Name: Specific type method
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S271
  • Feature Name: Basic multiset support
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S272
  • Feature Name: Multisets of user-defined types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S274
  • Feature Name: Multisets of reference types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S275
  • Feature Name: Advanced multiset support
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S281
  • Feature Name: Nested collection types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: S291
  • Feature Name: Unique constraint on entire row
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T011
  • Feature Name: Timestamp in Information Schema
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T031
  • Feature Name: BOOLEAN data type
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: T041
  • Feature Name: Basic LOB data type support
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments:  
  • Feature ID: T041-01
  • Feature Name: BLOB data type
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T041-02
  • Feature Name: CLOB data type
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Available as BLOB SUB_TYPE TEXT
  • Feature ID: T041-03
  • Feature Name: POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types
  • v1.5: *
  • v2.0: *
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments: Partially supported
  • Feature ID: T041-04
  • Feature Name: Concatenation of LOB data types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:
  • Feature ID: T041-05
  • Feature Name: LOB locator: non-holdable
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T042
  • Feature Name: Extended LOB data type support
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T051
  • Feature Name: Row types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T052
  • Feature Name: MAX and MIN for row types
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T053
  • Feature Name: Explicit aliases for all-fields reference
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T061
  • Feature Name: UCS support
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T071
  • Feature Name: BIGINT data type
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T111
  • Feature Name: Updatable joins, unions, and columns
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T121
  • Feature Name: WITH (excluding RECURSIVE) in query expression
  • v1.5: −
  • v2.0: −
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T122
  • Feature Name: WITH (excluding RECURSIVE) in subquery
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:
  • Feature ID: T131
  • Feature Name: Recursive query
  • v1.5: −
  • v2.0: −
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T132
  • Feature Name: Recursive query in subquery
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T141
  • Feature Name: SIMILAR predicate
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T151
  • Feature Name: DISTINCT predicate
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T152
  • Feature Name: DISTINCT predicate with negation
  • v1.5: −
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T171
  • Feature Name: LIKE clause in table definition
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T172
  • Feature Name: AS subquery clause in table definition
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T173
  • Feature Name: Extended LIKE clause in table definition
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T174
  • Feature Name: Identity columns
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: T175
  • Feature Name: Generated columns
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: +
  • Comments: Supported as computed columns
  • Feature ID: T176
  • Feature Name: Sequence generator support
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T191
  • Feature Name: Referential action RESTRICT
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T201
  • Feature Name: Comparable data types for referential constraints
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Numerics, timestamps and strings are not considered comparable
  • Feature ID: T211
  • Feature Name: Basic trigger capability
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments:  
  • Feature ID: T211-01
  • Feature Name: Triggers activated on UPDATE, INSERT, or DELETE of one base table
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T211-02
  • Feature Name: BEFORE triggers
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T211-03
  • Feature Name: AFTER triggers
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T211-04
  • Feature Name: FOR EACH ROW triggers
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T211-05
  • Feature Name: Ability to specify a search condition that shall be True before the trigger is invoked
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T211-06
  • Feature Name: Support for run-time rules for the interaction of triggers and constraints
  • v1.5: ?
  • v2.0: ?
  • v2.1: ?
  • v2.5: ?
  • v3.0: ?
  • Comments:  
  • Feature ID: T211-07
  • Feature Name: TRIGGER privilege
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T211-08
  • Feature Name: Multiple triggers for the same event are executed in the order in which they were
    created in the catalog
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: Execution order is specified by the developer
  • Feature ID: T212
  • Feature Name: Enhanced trigger capability
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T231
  • Feature Name: Sensitive cursors
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T241
  • Feature Name: START TRANSACTION statement
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments: Available as SET TRANSACTION
  • Feature ID: T251
  • Feature Name: SET TRANSACTION statement: LOCAL option
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T261
  • Feature Name: Chained transactions
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T271
  • Feature Name: Savepoints
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T272
  • Feature Name: Enhanced savepoint management
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T281
  • Feature Name: SELECT privilege with column granularity
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T301
  • Feature Name: Functional dependencies
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T312
  • Feature Name: OVERLAY function
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T322
  • Feature Name: Overloading of SQL-invoked functions and procedures
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T323
  • Feature Name: Explicit security for external routines
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T324
  • Feature Name: Explicit security for SQL routines
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T325
  • Feature Name: Qualified SQL parameter references
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T326
  • Feature Name: Table functions
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T331
  • Feature Name: Basic roles
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: +
  • Comments: Prior to Firebird 3.0, SET ROLE was not supported
  • Feature ID: T332
  • Feature Name: Extended roles
  • v1.5: *
  • v2.0: *
  • v2.1: *
  • v2.5: *
  • v3.0: *
  • Comments: GRANTED BY CURRENT_ROLE is not supported
  • Feature ID: T351
  • Feature Name: Bracketed SQL comments (/*...*/ comments)
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T431
  • Feature Name: Extended grouping capabilities
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T432
  • Feature Name: Nested and concatenated GROUPING SETS
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T433
  • Feature Name: Multi-argument GROUPING function
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T434
  • Feature Name: GROUP BY DISTINCT
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T441
  • Feature Name: ABS and MOD functions
  • v1.5: −
  • v2.0: −
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T461
  • Feature Name: Symmetric BETWEEN predicate
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T471
  • Feature Name: Result sets return value
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T491
  • Feature Name: LATERAL derived table
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T501
  • Feature Name: Enhanced EXISTS predicate
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T511
  • Feature Name: Transaction counts
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T551
  • Feature Name: Optional keywords for default syntax
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T561
  • Feature Name: Holdable locators
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T571
  • Feature Name: Array-returning external SQL-invoked functions
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T572
  • Feature Name: Multiset-returning external SQL-invoked functions
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T581
  • Feature Name: Regular expression substring function
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: T591
  • Feature Name: UNIQUE constraints of possibly null columns
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T601
  • Feature Name: Local cursor references
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T611
  • Feature Name: Elementary OLAP operations
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T612
  • Feature Name: Advanced OLAP operations
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T613
  • Feature Name: Sampling
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T621
  • Feature Name: Enhanced numeric functions
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T641
  • Feature Name: Multiple column assignment
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T651
  • Feature Name: SQL-schema statements in SQL routines
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T652
  • Feature Name: SQL-dynamic statements in SQL routines
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
  • Feature ID: T653
  • Feature Name: SQL-schema statements in external routines
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: −
  • Comments:  
  • Feature ID: T654
  • Feature Name: SQL-dynamic statements in external routines
  • v1.5: −
  • v2.0: −
  • v2.1: −
  • v2.5: −
  • v3.0: +
  • Comments:  
  • Feature ID: T655
  • Feature Name:  Cyclically dependent routines
  • v1.5: +
  • v2.0: +
  • v2.1: +
  • v2.5: +
  • v3.0: +
  • Comments:  
This site and the pages contained within are Copyright © 2000-2020, Firebird Project. Firebird® is a registered trademark of Firebird Foundation Incorporated.
Developed by DQ Team.