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:The document is subject to periodic updates, so please feed back if you disagree with any marks of 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)

Mandatory features

Feature ID: E011

E011 Feature Name: Numeric data types

Numeric data types v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Feature ID: E011-01

E011-01 Feature Name: INTEGER and SMALLINT data types (including all spellings)

INTEGER and SMALLINT data types (including all spellings) v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E011-02

E011-02 Feature Name: REAL, DOUBLE PRECISON, and FLOAT data types

REAL, DOUBLE PRECISON, and FLOAT data types v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E011-03

E011-03 Feature Name: DECIMAL and NUMERIC data types

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

E011-04 Feature Name: Arithmetic operators

Arithmetic operators v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E011-05

E011-05 Feature Name: Numeric comparison

Numeric comparison v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E011-06

E011-06 Feature Name: Implicit casting among the numeric data types

Implicit casting among the numeric data types v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E021

E021 Feature Name: Character string types

Character string types v1.5: *

* v2.0: *

* v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E021-01

E021-01 Feature Name: CHARACTER data type (including all its spellings)

CHARACTER data type (including all its spellings) v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E021-02

E021-02 Feature Name: CHARACTER VARYING data type (including all its spellings)

CHARACTER VARYING data type (including all its spellings) v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E021-03

E021-03 Feature Name: Character literals

Character literals v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E021-04

E021-04 Feature Name: CHARACTER_LENGTH function

CHARACTER_LENGTH function v1.5: −

− v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E021-05

E021-05 Feature Name: OCTET_LENGTH function

OCTET_LENGTH function v1.5: −

− v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E021-06

E021-06 Feature Name: SUBSTRING function

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

E021-07 Feature Name: Character concatenation

Character concatenation v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E021-08

E021-08 Feature Name: UPPER and LOWER functions

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

E021-09 Feature Name: TRIM function

TRIM function v1.5: −

− v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E021-10

E021-10 Feature Name: Implicit casting among the fixed-length and variable-length character string types

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

E021-11 Feature Name: POSITION function

POSITION function v1.5: −

− v2.0: −

− v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E021-12

E021-12 Feature Name: Character comparison

Character comparison v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E031

E031 Feature Name: Identifiers

Identifiers v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E031-01

E031-01 Feature Name: Delimited identifiers

Delimited identifiers v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E031-02

E031-02 Feature Name: Lower case identifiers

Lower case identifiers v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E031-03

E031-03 Feature Name: Trailing underscore

Trailing underscore v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E051

E051 Feature Name: Basic query specification

Basic query specification v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Feature ID: E051-01

E051-01 Feature Name: SELECT DISTINCT

SELECT DISTINCT v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E051-02

E051-02 Feature Name: GROUP BY clause

GROUP BY clause v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E051-04

E051-04 Feature Name: GROUP BY can contain columns not in

GROUP BY can contain columns not in v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E051-05

E051-05 Feature Name: Select list items can be renamed

Select list items can be renamed v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E051-06

E051-06 Feature Name: HAVING clause

HAVING clause v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E051-07

E051-07 Feature Name: Qualified * in select list

Qualified * in select list v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E051-08

E051-08 Feature Name: Correlation names in the FROM clause

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

E051-09 Feature Name: Rename columns in the FROM clause

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

E061 Feature Name: Basic predicates and search conditions

Basic predicates and search conditions v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E061-01

E061-01 Feature Name: Comparison predicate

Comparison predicate v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E061-02

E061-02 Feature Name: BETWEEN predicate

BETWEEN predicate v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E061-03

E061-03 Feature Name: IN predicate with list of values

IN predicate with list of values v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E061-04

E061-04 Feature Name: LIKE predicate

LIKE predicate v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E061-05

E061-05 Feature Name: LIKE predicate: ESCAPE clause

LIKE predicate: ESCAPE clause v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E061-06

E061-06 Feature Name: NULL predicate

NULL predicate v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E061-07

E061-07 Feature Name: Quantified comparison predicate

Quantified comparison predicate v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E061-08

E061-08 Feature Name: EXISTS predicate

EXISTS predicate v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E061-09

E061-09 Feature Name: Subqueries in comparison predicate

Subqueries in comparison predicate v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E061-11

E061-11 Feature Name: Subqueries in IN predicate

Subqueries in IN predicate v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E061-12

E061-12 Feature Name: Subqueries in quantified comparison predicate

Subqueries in quantified comparison predicate v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E061-13

E061-13 Feature Name: Correlated subqueries

Correlated subqueries v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E061-14

E061-14 Feature Name: Search condition

Search condition v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E071

E071 Feature Name: Basic query expressions

Basic query expressions v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Feature ID: E071-01

E071-01 Feature Name: UNION DISTINCT table operator

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

E071-02 Feature Name: UNION ALL table operator

UNION ALL table operator v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E071-03

E071-03 Feature Name: EXCEPT DISTINCT table operator

EXCEPT DISTINCT table operator v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: E071-05

E071-05 Feature Name: Columns combined via table operators need not have exactly the same data type

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

E071-06 Feature Name: Table operators in subqueries

Table operators in subqueries v1.5: −

− v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E081

E081 Feature Name: Basic Privileges

Basic Privileges v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: +

+ Comments: Feature ID: E081-01

E081-01 Feature Name: SELECT privilege at the table level

SELECT privilege at the table level v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E081-02

E081-02 Feature Name: DELETE privilege

DELETE privilege v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E081-03

E081-03 Feature Name: INSERT privilege at the table level

INSERT privilege at the table level v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E081-04

E081-04 Feature Name: UPDATE privilege at the table level

UPDATE privilege at the table level v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E081-05

E081-05 Feature Name: UPDATE privilege at the column level

UPDATE privilege at the column level v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E081-06

E081-06 Feature Name: REFERENCES privilege at the table level

REFERENCES privilege at the table level v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E081-07

E081-07 Feature Name: REFERENCES privilege at the column level

REFERENCES privilege at the column level v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E081-08

E081-08 Feature Name: WITH GRANT OPTION

WITH GRANT OPTION v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E081-09

E081-09 Feature Name: USAGE privilege

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

E081-10 Feature Name: EXECUTE privilege

EXECUTE privilege v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E091

E091 Feature Name: Set functions

Set functions v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E091-01

E091-01 Feature Name: AVG

AVG v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E091-02

E091-02 Feature Name: COUNT

COUNT v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E091-03

E091-03 Feature Name: MAX

MAX v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E091-04

E091-04 Feature Name: MIN

MIN v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E091-05

E091-05 Feature Name: SUM

SUM v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E091-06

E091-06 Feature Name: ALL quantifier

ALL quantifier v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E091-07

E091-07 Feature Name: DISTINCT quantifier

DISTINCT quantifier v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E101

E101 Feature Name: Basic data manipulation

Basic data manipulation v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E101-01

E101-01 Feature Name: INSERT statement

INSERT statement v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E101-03

E101-03 Feature Name: Searched UPDATE statement

Searched UPDATE statement v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E101-04

E101-04 Feature Name: Searched DELETE statement

Searched DELETE statement v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E111

E111 Feature Name: Single row SELECT statement

Single row SELECT statement v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E121

E121 Feature Name: Basic cursor support

Basic cursor support v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Feature ID: E121-01

E121-01 Feature Name: DECLARE CURSOR

DECLARE CURSOR v1.5: −

− v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E121-02

E121-02 Feature Name: ORDER BY columns need not be in select list

ORDER BY columns need not be in select list v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E121-03

E121-03 Feature Name: Value expressions in ORDER BY clause

Value expressions in ORDER BY clause v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E121-04

E121-04 Feature Name: OPEN statement

OPEN statement v1.5: −

− v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E121-06

E121-06 Feature Name: Positioned UPDATE statement

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

E121-07 Feature Name: Positioned DELETE statement

Positioned DELETE statement v1.5: *

* v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: (same as above) Feature ID: E121-08

E121-08 Feature Name: CLOSE statement

CLOSE statement v1.5: −

− v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E121-10

E121-10 Feature Name: FETCH statement: implicit NEXT

FETCH statement: implicit NEXT v1.5: −

− v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E121-17

E121-17 Feature Name: WITH HOLD cursors

WITH HOLD cursors v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: E131

E131 Feature Name: Null value support (nulls in lieu of values)

Null value support (nulls in lieu of values) v1.5: −

− v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E141

E141 Feature Name: Basic integrity constraints

Basic integrity constraints v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Feature ID: E141-01

E141-01 Feature Name: NOT NULL constraints

NOT NULL constraints v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E141-02

E141-02 Feature Name: UNIQUE constraints of NOT NULL columns

UNIQUE constraints of NOT NULL columns v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E141-03

E141-03 Feature Name: PRIMARY KEY constraints

PRIMARY KEY constraints v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E141-04

E141-04 Feature Name: Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action

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

E141-06 Feature Name: CHECK constraints

CHECK constraints v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E141-07

E141-07 Feature Name: Column defaults

Column defaults v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E141-08

E141-08 Feature Name: NOT NULL inferred on PRIMARY KEY

NOT NULL inferred on PRIMARY KEY v1.5: −

− v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E141-10

E141-10 Feature Name: Names in a foreign key can be specified in any order

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

E151 Feature Name: Transaction support

Transaction support v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E151-01

E151-01 Feature Name: COMMIT statement

COMMIT statement v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E151-02

E151-02 Feature Name: ROLLBACK statement

ROLLBACK statement v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E152

E152 Feature Name: Basic SET TRANSACTION statement

Basic SET TRANSACTION statement v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Feature ID: E152-01

E152-01 Feature Name: SET TRANSACTION statement:

ISOLATION LEVEL SERIALIZABLE clause

SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: E152-02

E152-02 Feature Name: SET TRANSACTION statement:

READ ONLY and READ WRITE clauses

SET TRANSACTION statement: READ ONLY and READ WRITE clauses v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E153

E153 Feature Name: Updatable queries with subqueries

Updatable queries with subqueries v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E161

E161 Feature Name: SQL comments using leading double minus

SQL comments using leading double minus v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: E171

E171 Feature Name: SQLSTATE support

SQLSTATE support v1.5: −

− v2.0: −

− v2.1: −

− v2.5: +

+ v3.0: +

+ Comments: Feature ID: E182

E182 Feature Name: Module language

Module language v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F031

F031 Feature Name: Basic schema manipulation

Basic schema manipulation v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Feature ID: F031-01

F031-01 Feature Name: CREATE TABLE statement to create persistent base tables

CREATE TABLE statement to create persistent base tables v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F031-02

F031-02 Feature Name: CREATE VIEW statement

CREATE VIEW statement v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F031-03

F031-03 Feature Name: GRANT statement

GRANT statement v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F031-04

F031-04 Feature Name: ALTER TABLE statement:

ADD COLUMN clause

ALTER TABLE statement: ADD COLUMN clause v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F031-13

F031-13 Feature Name: DROP TABLE statement:

RESTRICT clause

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

F031-19 Feature Name: REVOKE statement:

RESTRICT clause

REVOKE statement: RESTRICT clause v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: (same as above) Feature ID: F041

F041 Feature Name: Basic joined table

Basic joined table v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F041-01

F041-01 Feature Name: Inner join (but not necessarily the INNER keyword)

Inner join (but not necessarily the INNER keyword) v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F041-02

F041-02 Feature Name: INNER keyword

INNER keyword v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F041-03

F041-03 Feature Name: LEFT OUTER JOIN

LEFT OUTER JOIN v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F041-04

F041-04 Feature Name: RIGHT OUTER JOIN

RIGHT OUTER JOIN v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F041-05

F041-05 Feature Name: Outer joins can be nested

Outer joins can be nested v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F041-07

F041-07 Feature Name: The inner table in a left or right outer join can also be used in an inner join

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

F041-08 Feature Name: All comparison operators are supported (rather than just =)

All comparison operators are supported (rather than just =) v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F051

F051 Feature Name: Basic date and time

Basic date and time v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Feature ID: F051-01

F051-01 Feature Name: DATE data type (including support of DATE literal)

DATE data type (including support of DATE literal) v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F051-02

F051-02 Feature Name: TIME data type (including support of TIME literal) with fractional seconds precision of at least 0

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

F051-03 Feature Name: TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6

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

F051-04 Feature Name: Comparison predicate on DATE, TIME, and TIMESTAMP data types

Comparison predicate on DATE, TIME, and TIMESTAMP data types v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F051-05

F051-05 Feature Name: Explicit CAST between datetime types and character string types

Explicit CAST between datetime types and character string types v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F051-06

F051-06 Feature Name: CURRENT_DATE

CURRENT_DATE v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F051-07

F051-07 Feature Name: LOCALTIME

LOCALTIME v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Supported as CURRENT_TIME instead Feature ID: F051-08

F051-08 Feature Name: LOCALTIMESTAMP

LOCALTIMESTAMP v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Supported as CURRENT_TIMESTAMP instead Feature ID: F081

F081 Feature Name: UNION and EXCEPT in views

UNION and EXCEPT in views v1.5: −

− v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: EXCEPT is not supported Feature ID: F131

F131 Feature Name: Grouped operations

Grouped operations v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F131-01

F131-01 Feature Name: WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views

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

F131-02 Feature Name: Multiple tables supported in queries with grouped views

Multiple tables supported in queries with grouped views v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F131-03

F131-03 Feature Name: Set functions supported in queries with grouped views

Set functions supported in queries with grouped views v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F131-04

F131-04 Feature Name: Subqueries with GROUP BY and HAVING clauses and grouped views

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

F131-05 Feature Name: Single row SELECT with GROUP BY and HAVING clauses and grouped views

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

F181 Feature Name: Multiple module support

Multiple module support v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F201

F201 Feature Name: CAST function

CAST function v1.5: +

+ v2.0: +

+ v2.1:

v2.5:

v3.0:

Comments: Feature ID: F221

F221 Feature Name: Explicit defaults

Explicit defaults v1.5: −

− v2.0: −

− v2.1: *

* v2.5: *

* v3.0: *

* Comments: Supported only as DEFAULT VALUES in INSERT statements Feature ID: F261

F261 Feature Name: CASE expression

CASE expression v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F261-01

F261-01 Feature Name: Simple CASE

Simple CASE v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F261-02

F261-02 Feature Name: Searched CASE

Searched CASE v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F261-03

F261-03 Feature Name: NULLIF

NULLIF v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F261-04

F261-04 Feature Name: COALESCE

COALESCE v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F311

F311 Feature Name: Schema definition statement

Schema definition statement v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F311-01

F311-01 Feature Name: CREATE SCHEMA

CREATE SCHEMA v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F311-02

F311-02 Feature Name: CREATE TABLE for persistent base tables

CREATE TABLE for persistent base tables v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F311-03

F311-03 Feature Name: CREATE VIEW

CREATE VIEW v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F311-04

F311-04 Feature Name: CREATE VIEW: WITH CHECK OPTION

CREATE VIEW: WITH CHECK OPTION v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F311-05

F311-05 Feature Name: GRANT statement

GRANT statement v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F471

F471 Feature Name: Scalar subquery values

Scalar subquery values v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F481

F481 Feature Name: Expanded NULL predicate

Expanded NULL predicate v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F812

F812 Feature Name: Basic flagging

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

S011 Feature Name: Distinct data types

Distinct data types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T321

T321 Feature Name: Basic SQL-invoked routines

Basic SQL-invoked routines v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Feature ID: T321-01

T321-01 Feature Name: User-defined functions with no overloading

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

T321-02 Feature Name: User-defined stored procedures with no overloading

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

T321-03 Feature Name: Function invocation

Function invocation v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T321-04

T321-04 Feature Name: CALL statement

CALL statement v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Available as EXECUTE PROCEDURE instead Feature ID: T321-05

T321-05 Feature Name: RETURN statement

RETURN statement v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: +

+ Comments: Available as EXIT in SQL procedures Feature ID: T631

T631 Feature Name: IN predicate with one list element

IN predicate with one list element v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments:

Optional features

Feature ID: B011

B011 Feature Name: Embedded Ada

Embedded Ada v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: B012

B012 Feature Name: Embedded C

Embedded C v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: B013

B013 Feature Name: Embedded COBOL

Embedded COBOL v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: B014

B014 Feature Name: Embedded Fortran

Embedded Fortran v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: B015

B015 Feature Name: Embedded MUMPS

Embedded MUMPS v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: B016

B016 Feature Name: Embedded Pascal

Embedded Pascal v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: B017

B017 Feature Name: Embedded PL/I

Embedded PL/I v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: B021

B021 Feature Name: Direct SQL

Direct SQL v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: B031

B031 Feature Name: Basic dynamic SQL

Basic dynamic SQL v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Not all standard features are supported Feature ID: B032

B032 Feature Name: Extended dynamic SQL

Extended dynamic SQL v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: B032-01

B032-01 Feature Name:

v1.5: −

− v2.0: −

− v2.1:

v2.5:

v3.0:

Comments: Feature ID: B033

B033 Feature Name: Untyped SQL-invoked function arguments

Untyped SQL-invoked function arguments v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: B034

B034 Feature Name: Dynamic specification of cursor attributes

Dynamic specification of cursor attributes v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: B041

B041 Feature Name: Extensions to embedded SQL exception declarations

Extensions to embedded SQL exception declarations v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: B051

B051 Feature Name: Enhanced execution rights

Enhanced execution rights v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: B111

B111 Feature Name: Module language Ada

Module language Ada v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: B112

B112 Feature Name: Module language C

Module language C v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: B113

B113 Feature Name: Module language COBOL

Module language COBOL v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: B114

B114 Feature Name: Module language Fortran

Module language Fortran v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: B115

B115 Feature Name: Module language MUMPS

Module language MUMPS v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: B116

B116 Feature Name: Module language Pascal

Module language Pascal v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: B117

B117 Feature Name: Module language PL/I

Module language PL/I v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: B121

B121 Feature Name: Routine language Ada

Routine language Ada v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: B122

B122 Feature Name: Routine language C

Routine language C v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: B123

B123 Feature Name: Routine language COBOL

Routine language COBOL v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: B124

B124 Feature Name: Routine language Fortran

Routine language Fortran v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: B125

B125 Feature Name: Routine language MUMPS

Routine language MUMPS v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: B126

B126 Feature Name: Routine language Pascal

Routine language Pascal v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: B127

B127 Feature Name: Routine language PL/I

Routine language PL/I v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: B128

B128 Feature Name: Routine language SQL

Routine language SQL v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F032

F032 Feature Name: CASCADE drop behavior

CASCADE drop behavior v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F033

F033 Feature Name: ALTER TABLE statement:

DROP COLUMN clause

ALTER TABLE statement: DROP COLUMN clause v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F034

F034 Feature Name: Extended REVOKE statement

Extended REVOKE statement v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: REVOKE CASCADE is not supported Feature ID: F034-01

F034-01 Feature Name: REVOKE statement performed by other than the owner of a schema object

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

F034-02 Feature Name: REVOKE statement:

GRANT OPTION FOR clause

REVOKE statement: GRANT OPTION FOR clause v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F034-03

F034-03 Feature Name: REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION

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

F052 Feature Name: Intervals and datetime arithmetic

Intervals and datetime arithmetic v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Intervals are not supported Feature ID: F053

F053 Feature Name: OVERLAPS predicate

OVERLAPS predicate v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F111

F111 Feature Name: Isolation levels other than SERIALIZABLE

Isolation levels other than SERIALIZABLE v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Feature ID: F111-01

F111-01 Feature Name: READ UNCOMMITTED isolation level

READ UNCOMMITTED isolation level v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F111-02

F111-02 Feature Name: READ COMMITTED isolation level

READ COMMITTED isolation level v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F111-03

F111-03 Feature Name: REPEATABLE READ isolation level

REPEATABLE READ isolation level v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Available as SNAPSHOT Feature ID: F121

F121 Feature Name: Basic diagnostics management

Basic diagnostics management v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F121-01

F121-01 Feature Name: GET DIAGNOSTICS statement

GET DIAGNOSTICS statement v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F121-02

F121-02 Feature Name: SET TRANSACTION statement: DIAGNOSTICS SIZE clause

SET TRANSACTION statement: DIAGNOSTICS SIZE clause v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F171

F171 Feature Name: Multiple schemas per user

Multiple schemas per user v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F191

F191 Feature Name: Referential delete actions

Referential delete actions v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F222

F222 Feature Name: INSERT statement:

DEFAULT VALUES clause

INSERT statement: DEFAULT VALUES clause v1.5: −

− v2.0: −

− v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F231

F231 Feature Name: Privilege tables

Privilege tables v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F231-01

F231-01 Feature Name: TABLE_PRIVILEGES view

TABLE_PRIVILEGES view v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F231-02

F231-02 Feature Name: COLUMN_PRIVILEGES view

COLUMN_PRIVILEGES view v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F231-03

F231-03 Feature Name: USAGE_PRIVILEGES view

USAGE_PRIVILEGES view v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F251

F251 Feature Name: Domain support

Domain support v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F262

F262 Feature Name: Extended CASE expression

Extended CASE expression v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F263

F263 Feature Name: Comma-separated predicates in simple CASE expression

Comma-separated predicates in simple CASE expression v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F271

F271 Feature Name: Compound character literals

Compound character literals v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F281

F281 Feature Name: LIKE enhancements

LIKE enhancements v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F291

F291 Feature Name: UNIQUE predicate

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

F301 Feature Name: CORRESPONDING in query expressions

CORRESPONDING in query expressions v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F302

F302 Feature Name: INTERSECT table operator

INTERSECT table operator v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F302-01

F302-01 Feature Name: INTERSECT DISTINCT table operator

INTERSECT DISTINCT table operator v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F302-02

F302-02 Feature Name: INTERSECT ALL table operator

INTERSECT ALL table operator v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F304

F304 Feature Name: EXCEPT ALL table operator

EXCEPT ALL table operator v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F312

F312 Feature Name: MERGE statement

MERGE statement v1.5: −

− v2.0: −

− v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F321

F321 Feature Name: User authorization

User authorization v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Only CURRENT_USER is supported Feature ID: F341

F341 Feature Name: Usage tables

Usage tables v1.5: ?

? v2.0: ?

? v2.1: ?

? v2.5: ?

? v3.0: ?

? Comments: Feature ID: F361

F361 Feature Name: Subprogram support

Subprogram support v1.5: ?

? v2.0: ?

? v2.1: ?

? v2.5: ?

? v3.0: ?

? Comments: Feature ID: F381

F381 Feature Name: Extended schema manipulation

Extended schema manipulation v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F381-01

F381-01 Feature Name: ALTER TABLE statement:

ALTER COLUMN clause

ALTER TABLE statement: ALTER COLUMN clause v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F381-02

F381-02 Feature Name: ALTER TABLE statement:

ADD CONSTRAINT clause

ALTER TABLE statement: ADD CONSTRAINT clause v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F381-03

F381-03 Feature Name: ALTER TABLE statement:

DROP CONSTRAINT clause

ALTER TABLE statement: DROP CONSTRAINT clause v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F391

F391 Feature Name: Long identifiers

Long identifiers v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Maximum identifier length is equal to 31 Feature ID: F392

F392 Feature Name: Unicode escapes in identifiers

Unicode escapes in identifiers v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F393

F393 Feature Name: Unicode escapes in literals

Unicode escapes in literals v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F401

F401 Feature Name: Extended joined table

Extended joined table v1.5: *

* v2.0: *

* v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F401-01

F401-01 Feature Name: NATURAL JOIN

NATURAL JOIN v1.5: −

− v2.0: −

− v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F401-02

F401-02 Feature Name: FULL OUTER JOIN

FULL OUTER JOIN v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F401-04

F401-04 Feature Name: CROSS JOIN

CROSS JOIN v1.5: −

− v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F402

F402 Feature Name: Named column joins for LOBs, arrays, and multisets

Named column joins for LOBs, arrays, and multisets v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F411

F411 Feature Name: Time zone specification

Time zone specification v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F421

F421 Feature Name: National character

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

F431 Feature Name: Read-only scrollable cursors

Read-only scrollable cursors v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: F431-01

F431-01 Feature Name: FETCH with explicit NEXT

FETCH with explicit NEXT v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: F431-02

F431-02 Feature Name: FETCH FIRST

FETCH FIRST v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: F431-03

F431-03 Feature Name: FETCH LAST

FETCH LAST v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: F431-04

F431-04 Feature Name: FETCH PRIOR

FETCH PRIOR v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: F431-05

F431-05 Feature Name: FETCH ABSOLUTE

FETCH ABSOLUTE v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: F431-06

F431-06 Feature Name: FETCH RELATIVE

FETCH RELATIVE v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: F441

F441 Feature Name: Extended set function support

Extended set function support v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F442

F442 Feature Name: Mixed column references in set functions

Mixed column references in set functions v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F451

F451 Feature Name: Character set definition

Character set definition v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F461

F461 Feature Name: Named character sets

Named character sets v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F491

F491 Feature Name: Constraint management

Constraint management v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F502

F502 Feature Name: Enhanced documentation tables

Enhanced documentation tables v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F502-01

F502-01 Feature Name: SQL_SIZING_PROFILES view

SQL_SIZING_PROFILES view v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F502-02

F502-02 Feature Name: SQL_IMPLEMENTATION_INFO view

SQL_IMPLEMENTATION_INFO view v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F502-03

F502-03 Feature Name: SQL_PACKAGES view

SQL_PACKAGES view v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F521

F521 Feature Name: Assertions

Assertions v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F531

F531 Feature Name: Temporary tables

Temporary tables v1.5: −

− v2.0: −

− v2.1: *

* v2.5: *

* v3.0: *

* Comments: Only global temporary tables are supported Feature ID: F555

F555 Feature Name: Enhanced seconds precision

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

F561 Feature Name: Full value expressions

Full value expressions v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F571

F571 Feature Name: Truth value tests

Truth value tests v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: F591

F591 Feature Name: Derived tables

Derived tables v1.5: −

− v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F611

F611 Feature Name: Indicator data types

Indicator data types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F641

F641 Feature Name: Row and table constructors

Row and table constructors v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F651

F651 Feature Name: Catalog name qualifiers

Catalog name qualifiers v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F661

F661 Feature Name: Simple tables

Simple tables v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F671

F671 Feature Name: Subqueries in CHECK

Subqueries in CHECK v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F672

F672 Feature Name: Retrospective check constraints

Retrospective check constraints v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F691

F691 Feature Name: Collation and translation

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

F692 Feature Name: Enhanced collation support

Enhanced collation support v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F693

F693 Feature Name: SQL-session and client module collations

SQL-session and client module collations v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F695

F695 Feature Name: Translation support

Translation support v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F696

F696 Feature Name: Additional translation documentation

Additional translation documentation v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F701

F701 Feature Name: Referential update actions

Referential update actions v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F711

F711 Feature Name: ALTER domain

ALTER domain v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F721

F721 Feature Name: Deferrable constraints

Deferrable constraints v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F731

F731 Feature Name: INSERT column privileges

INSERT column privileges v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F741

F741 Feature Name: Referential MATCH types

Referential MATCH types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F751

F751 Feature Name: View CHECK enhancements

View CHECK enhancements v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F761

F761 Feature Name: Session management

Session management v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F771

F771 Feature Name: Connection management

Connection management v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F781

F781 Feature Name: Self-referencing operations

Self-referencing operations v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: F791

F791 Feature Name: Insensitive cursors

Insensitive cursors v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F801

F801 Feature Name: Full set function

Full set function v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F813

F813 Feature Name: Extended flagging

Extended flagging v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F821

F821 Feature Name: Local table references

Local table references v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F831

F831 Feature Name: Full cursor update

Full cursor update v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F831-01

F831-01 Feature Name: Updateable scrollable cursors

Updateable scrollable cursors v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: F831-02

F831-02 Feature Name: Updateable ordered cursors

Updateable ordered cursors v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S023

S023 Feature Name: Basic structured types

Basic structured types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S024

S024 Feature Name: Enhanced structured types

Enhanced structured types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S025

S025 Feature Name: Final structured types

Final structured types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S026

S026 Feature Name: Self-referencing structured types

Self-referencing structured types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S027

S027 Feature Name: Create method by specific method name

Create method by specific method name v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S028

S028 Feature Name: Permutable UDT options list

Permutable UDT options list v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S041

S041 Feature Name: Basic reference types

Basic reference types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S043

S043 Feature Name: Enhanced reference types

Enhanced reference types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S051

S051 Feature Name: Create table of type

Create table of type v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S071

S071 Feature Name: SQL paths in function and type name resolution

SQL paths in function and type name resolution v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S081

S081 Feature Name: Subtables

Subtables v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S091

S091 Feature Name: Basic array support

Basic array support v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Feature ID: S091-01

S091-01 Feature Name: Arrays of built-in data types

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

S091-02 Feature Name: Arrays of distinct types

Arrays of distinct types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S091-03

S091-03 Feature Name: Array expressions

Array expressions v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S092

S092 Feature Name: Arrays of user-defined types

Arrays of user-defined types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S094

S094 Feature Name: Arrays of reference types

Arrays of reference types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S095

S095 Feature Name: Array constructors by query

Array constructors by query v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S096

S096 Feature Name: Optional array bounds

Optional array bounds v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S097

S097 Feature Name: Array element assignment

Array element assignment v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S111

S111 Feature Name: ONLY in query expressions

ONLY in query expressions v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S151

S151 Feature Name: Type predicate

Type predicate v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S161

S161 Feature Name: Subtype treatment

Subtype treatment v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S162

S162 Feature Name: Subtype treatment for references

Subtype treatment for references v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S201

S201 Feature Name: SQL-invoked routines on arrays

SQL-invoked routines on arrays v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S201-01

S201-01 Feature Name: Array parameters

Array parameters v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S201-02

S201-02 Feature Name: Array as result type of functions

Array as result type of functions v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S202

S202 Feature Name: SQL-invoked routines on multisets

SQL-invoked routines on multisets v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S211

S211 Feature Name: User-defined cast functions

User-defined cast functions v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S231

S231 Feature Name: Structured type locators

Structured type locators v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S232

S232 Feature Name: Array locators

Array locators v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S233

S233 Feature Name: Multiset locators

Multiset locators v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S241

S241 Feature Name: Transform functions

Transform functions v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S242

S242 Feature Name: Alter transform statement

Alter transform statement v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S251

S251 Feature Name: User-defined orderings

User-defined orderings v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S261

S261 Feature Name: Specific type method

Specific type method v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S271

S271 Feature Name: Basic multiset support

Basic multiset support v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S272

S272 Feature Name: Multisets of user-defined types

Multisets of user-defined types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S274

S274 Feature Name: Multisets of reference types

Multisets of reference types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S275

S275 Feature Name: Advanced multiset support

Advanced multiset support v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S281

S281 Feature Name: Nested collection types

Nested collection types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: S291

S291 Feature Name: Unique constraint on entire row

Unique constraint on entire row v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T011

T011 Feature Name: Timestamp in Information Schema

Timestamp in Information Schema v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T031

T031 Feature Name: BOOLEAN data type

BOOLEAN data type v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: T041

T041 Feature Name: Basic LOB data type support

Basic LOB data type support v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Feature ID: T041-01

T041-01 Feature Name: BLOB data type

BLOB data type v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T041-02

T041-02 Feature Name: CLOB data type

CLOB data type v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Available as BLOB SUB_TYPE TEXT Feature ID: T041-03

T041-03 Feature Name: POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types

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

T041-04 Feature Name: Concatenation of LOB data types

Concatenation of LOB data types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T041-05

T041-05 Feature Name: LOB locator: non-holdable

LOB locator: non-holdable v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T042

T042 Feature Name: Extended LOB data type support

Extended LOB data type support v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T051

T051 Feature Name: Row types

Row types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T052

T052 Feature Name: MAX and MIN for row types

MAX and MIN for row types v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T053

T053 Feature Name: Explicit aliases for all-fields reference

Explicit aliases for all-fields reference v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T061

T061 Feature Name: UCS support

UCS support v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T071

T071 Feature Name: BIGINT data type

BIGINT data type v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T111

T111 Feature Name: Updatable joins, unions, and columns

Updatable joins, unions, and columns v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T121

T121 Feature Name: WITH (excluding RECURSIVE) in query expression

WITH (excluding RECURSIVE) in query expression v1.5: −

− v2.0: −

− v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T122

T122 Feature Name: WITH (excluding RECURSIVE) in subquery

WITH (excluding RECURSIVE) in subquery v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T131

T131 Feature Name: Recursive query

Recursive query v1.5: −

− v2.0: −

− v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T132

T132 Feature Name: Recursive query in subquery

Recursive query in subquery v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T141

T141 Feature Name: SIMILAR predicate

SIMILAR predicate v1.5: −

− v2.0: −

− v2.1: −

− v2.5: +

+ v3.0: +

+ Comments: Feature ID: T151

T151 Feature Name: DISTINCT predicate

DISTINCT predicate v1.5: −

− v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T152

T152 Feature Name: DISTINCT predicate with negation

DISTINCT predicate with negation v1.5: −

− v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T171

T171 Feature Name: LIKE clause in table definition

LIKE clause in table definition v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T172

T172 Feature Name: AS subquery clause in table definition

AS subquery clause in table definition v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T173

T173 Feature Name: Extended LIKE clause in table definition

Extended LIKE clause in table definition v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T174

T174 Feature Name: Identity columns

Identity columns v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: T175

T175 Feature Name: Generated columns

Generated columns v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: +

+ Comments: Supported as computed columns Feature ID: T176

T176 Feature Name: Sequence generator support

Sequence generator support v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T191

T191 Feature Name: Referential action RESTRICT

Referential action RESTRICT v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T201

T201 Feature Name: Comparable data types for referential constraints

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

T211 Feature Name: Basic trigger capability

Basic trigger capability v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: Feature ID: T211-01

T211-01 Feature Name: Triggers activated on UPDATE, INSERT, or DELETE of one base table

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

T211-02 Feature Name: BEFORE triggers

BEFORE triggers v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T211-03

T211-03 Feature Name: AFTER triggers

AFTER triggers v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T211-04

T211-04 Feature Name: FOR EACH ROW triggers

FOR EACH ROW triggers v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T211-05

T211-05 Feature Name: Ability to specify a search condition that shall be True before the trigger is invoked

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

T211-06 Feature Name: Support for run-time rules for the interaction of triggers and constraints

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

T211-07 Feature Name: TRIGGER privilege

TRIGGER privilege v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T211-08

T211-08 Feature Name: Multiple triggers for the same event are executed in the order in which they were

created in the catalog

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

T212 Feature Name: Enhanced trigger capability

Enhanced trigger capability v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T231

T231 Feature Name: Sensitive cursors

Sensitive cursors v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T241

T241 Feature Name: START TRANSACTION statement

START TRANSACTION statement v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Available as SET TRANSACTION Feature ID: T251

T251 Feature Name: SET TRANSACTION statement: LOCAL option

SET TRANSACTION statement: LOCAL option v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T261

T261 Feature Name: Chained transactions

Chained transactions v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T271

T271 Feature Name: Savepoints

Savepoints v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T272

T272 Feature Name: Enhanced savepoint management

Enhanced savepoint management v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T281

T281 Feature Name: SELECT privilege with column granularity

SELECT privilege with column granularity v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T301

T301 Feature Name: Functional dependencies

Functional dependencies v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T312

T312 Feature Name: OVERLAY function

OVERLAY function v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T322

T322 Feature Name: Overloading of SQL-invoked functions and procedures

Overloading of SQL-invoked functions and procedures v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T323

T323 Feature Name: Explicit security for external routines

Explicit security for external routines v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T324

T324 Feature Name: Explicit security for SQL routines

Explicit security for SQL routines v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T325

T325 Feature Name: Qualified SQL parameter references

Qualified SQL parameter references v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T326

T326 Feature Name: Table functions

Table functions v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T331

T331 Feature Name: Basic roles

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

T332 Feature Name: Extended roles

Extended roles v1.5: *

* v2.0: *

* v2.1: *

* v2.5: *

* v3.0: *

* Comments: GRANTED BY CURRENT_ROLE is not supported Feature ID: T351

T351 Feature Name: Bracketed SQL comments (/*...*/ comments)

Bracketed SQL comments (/*...*/ comments) v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T431

T431 Feature Name: Extended grouping capabilities

Extended grouping capabilities v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T432

T432 Feature Name: Nested and concatenated GROUPING SETS

Nested and concatenated GROUPING SETS v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T433

T433 Feature Name: Multi-argument GROUPING function

Multi-argument GROUPING function v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T434

T434 Feature Name: GROUP BY DISTINCT

GROUP BY DISTINCT v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T441

T441 Feature Name: ABS and MOD functions

ABS and MOD functions v1.5: −

− v2.0: −

− v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T461

T461 Feature Name: Symmetric BETWEEN predicate

Symmetric BETWEEN predicate v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T471

T471 Feature Name: Result sets return value

Result sets return value v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T491

T491 Feature Name: LATERAL derived table

LATERAL derived table v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T501

T501 Feature Name: Enhanced EXISTS predicate

Enhanced EXISTS predicate v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T511

T511 Feature Name: Transaction counts

Transaction counts v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T551

T551 Feature Name: Optional keywords for default syntax

Optional keywords for default syntax v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T561

T561 Feature Name: Holdable locators

Holdable locators v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T571

T571 Feature Name: Array-returning external SQL-invoked functions

Array-returning external SQL-invoked functions v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T572

T572 Feature Name: Multiset-returning external SQL-invoked functions

Multiset-returning external SQL-invoked functions v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T581

T581 Feature Name: Regular expression substring function

Regular expression substring function v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: T591

T591 Feature Name: UNIQUE constraints of possibly null columns

UNIQUE constraints of possibly null columns v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T601

T601 Feature Name: Local cursor references

Local cursor references v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T611

T611 Feature Name: Elementary OLAP operations

Elementary OLAP operations v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T612

T612 Feature Name: Advanced OLAP operations

Advanced OLAP operations v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T613

T613 Feature Name: Sampling

Sampling v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T621

T621 Feature Name: Enhanced numeric functions

Enhanced numeric functions v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T641

T641 Feature Name: Multiple column assignment

Multiple column assignment v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T651

T651 Feature Name: SQL-schema statements in SQL routines

SQL-schema statements in SQL routines v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T652

T652 Feature Name: SQL-dynamic statements in SQL routines

SQL-dynamic statements in SQL routines v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments: Feature ID: T653

T653 Feature Name: SQL-schema statements in external routines

SQL-schema statements in external routines v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: −

− Comments: Feature ID: T654

T654 Feature Name: SQL-dynamic statements in external routines

SQL-dynamic statements in external routines v1.5: −

− v2.0: −

− v2.1: −

− v2.5: −

− v3.0: +

+ Comments: Feature ID: T655

T655 Feature Name: Cyclically dependent routines

Cyclically dependent routines v1.5: +

+ v2.0: +

+ v2.1: +

+ v2.5: +

+ v3.0: +

+ Comments:

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