Appendix I. Document History

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

Revision History

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.