Appendix IDocument History

The exact file history is recorded in our git repository; see https://github.com/FirebirdSQL/firebird-documentation

Revision History

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

  • Removed ALTER PACKAGE BODY documentation, as this feature doesn’t exist (#200)

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

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

  • Corrected datatype of timestamp columns in system and monitoring tables (are TIMESTAMP WITH TIME ZONE since Firebird 4.0) (#172)

  • Nitpick: user name to username in System Tables appendix

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

  • Added LATERAL join example contributed by Karol Bieniaszewski (#167)

  • Changed a LATERAL join example from implicit cross join to explicit CROSS JOIN

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 NUMERICDECIMAL

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.