2.14 | 02 Oct 2024 | MR | Documented where to find time zone region names Improved documentation of PSQL blocks to make clear WHEN … DO can only occur at the end of a block (#208) Revised SEQUENCE DDL documentation regarding START/RESTART (#211) Trigger order for the same position was documented as alphabetical by name;
the actual order is undefined (#213)
|
2.13 | 20 Apr 2024 | MR | Corrected description of RDB$CHECK_CONSTRAINTS (#206) |
2.12 | 2 Apr 2024 | MR | Protocol names are lowercase (#205) |
2.11 | 17 Jan 2024 | MR | |
2.10 | 15 Dec 2023 | MR | |
2.9 | 09 Nov 2023 | MR | Fixed typo in PSQL module syntax Wrong link from ALTER TRIGGER to CREATE TRIGGER (#189) Added TCPv6 to NETWORK_PROTOCOL for SYSTEM namespace (#170) CURRENT_DATE is in the session time zone
Fixed description of RDB$INDICES.RDB$FOREIGN_KEY (#191)
|
2.8 | 05 Oct 2023 | MR | Added negative subtype to RDB$FIELDS.RDB$FIELD_SUB_TYPE, and fixed formatting Fixed incorrect syntax documentation of forward declaration of subroutines (#188)
|
2.7 | 08 Aug 2023 | MR | Fixed incorrect "equivalent" for REGR_COUNT Fixed incorrect references to idle timeout in SET STATEMENT TIMEOUT Documented that since Firebird 4.0.3, OVERRIDING USER VALUE also works for GENERATED ALWAYS identity columns
|
2.6 | 20 Jun 2023 | MR | |
2.5 | 26 May 2023 | MR | |
2.4 | 10 May 2023 | MR | Corrected column name MON$IDLE_TIMER to MON$STATEMENT_TIMER in Section E.8, “MON$STATEMENTS” Removed incorrect <common-table-expression> production in SELECT syntax
|
2.3 | 30 Jan 2023 | MR | Fixed typo in collation name UCS_BASIC |
2.2 | 24 Jan 2023 | MR | Added missing [{WITHOUT | WITH} TIME ZONE] to TIME and TIMESTAMP in Section 3.12.1, “Scalar Data Types Syntax” and Section 3.12.3, “Array Data Types Syntax” |
2.1 | 27 Oct 2022 | MR | Revise BLOB_APPEND documentation with known issues, and reduce mentions of result type being BLOB SUB_TYPE TEXT in favour of just BLOB Description of behaviour of SET BIND mentioned precision greater than 19 while precision 19 or higher should have been used Removed sequence limitation with dialect 1 documented with datatype BIGINT, and updated/added result type of GEN_ID and NEXT VALUE FOR Updated reference to details of literals in chapter SQL Language Structure Fixed incorrect whitespace in table names Added missing table name in FROM in Section 5.9.1.3, “Deterministic functions” (#177)
|
2.0 | 11 Aug 2022 | MR | Add documentation for BLOB_APPEND function introduced in Firebird 4.0.2 |
1.9 | 31 Jul 2022 | MR | Move RDB$TRIGGER_TYPE description to separate section to prevent truncation of table cell in PDF |
1.8 | 29 Jul 2022 | MR | |
1.7 | 18 Jul 2022 | MR | Fix documentation for RDB$INDICES.RDB$INDEX_TYPE (#174) |
1.6 | 13 Jul 2022 | MR | DATEDIFF unit MILLISECOND returns NUMERIC(18,1) since Firebird 4.0.1 (#173)
|
1.5 | 12 Jul 2022 | MR | |
1.4 | 03 Jan 2022 | MR | Values for RDB$RELATION_FIELDS.RDB$IDENTITY_TYPE were swapped (#168) |
1.3 | 24 Dec 2021 | MR | Documented PKCS_1_5 option of RSA_DECRYPT, RSA_ENCRYPT, RSA_SIGN_HASH, RSA_VERIFY_HASH added in Firebird 4.0.1 Documented collation attribute DISABLE-COMPRESSIONS since Firebird 4.0.1 is also supported for Unicode collations Documented collation attribute LOCALE since Firebird 4.0.1 also supports ICU locale keywords and attributes Documented result type determination of AVG as of Firebird 4.0.1 Documented SET DEBUG OPTION added in Firebird 4.0.1 Added DEBUG and PKCS_1_5 to keywords list
|
1.2 | 04 Dec 2021 | MR | |
1.1 | 16 Oct 2021 | MR | EXECUTE STATEMENT named parameters are regular identifiers (#164)
|
1.0 | 29 Sep 2021 | MR | Explicitly document transaction isolation level of ON CONNECT/ON DISCONNECT triggers (#163) |
0.15 | 31 Jul 2021 | MR | Fix behaviour documented for SNAPSHOT TABLE STABILITY (#158) |
0.14 | 23 Jul 2021 | MR | Remove extra SELECT in select syntax |
0.13 | 18 Jul 2021 | MR | Add missing isolation level code for read committed read consistency (4) to MON$TRANSACTIONS (#156) |
0.12 | 13 Jun 2021 | MR | Fixed wrong table title NUMERIC → DECIMAL |
0.11 | 05 Jun 2021 | MR | Fixed rendering issues in CRYPT_HASH section Fixed section level issue with examples of HEX_ENCODE/HEX_DECODE Removed notice about BASE64_ENCODE/BASE64_DECODE and HEX_ENCODE/HEX_DECODE bugs fixed in Firebird 4.0.0 Documented determination of result type of SUM Documented — potential — bug with result type of AVG Various copy-editing and corrections
|
0.10 | 03 Jun 2021 | MR | Fixed issue with some parts still referring to 18 as the max precision of NUMERIC/DECIMAL Updated mapping of number literals to types with information for DECFLOAT and INT128 Added mention of increment of sequence to NEXT VALUE FOR Various copy-editing and corrections
|
0.9 | 23 May 2021 | MR | Changes:
Documented USING PLUGIN clause of COMMENT ON USER Documented changes in start/restart behaviour of sequences Removed some notes about Firebird 3.0 specific behaviour or bugs Applied consistent version naming (e.g. Firebird 4.0, not Firebird 4) Add missing links Correct or clarify some issues previously annotated with TODO Document key and block size of ENCRYPT algorithms Fix section levels, and some reorganization of triggers
|
0.8 | 22 May 2021 | MR | Copied the Firebird 3.0 Language Reference as a starting point, and updated using the Firebird 4.0 Release Notes Release Candidate 1 and further updates to the release notes as a guide. |