Appendix I. Document History

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

Revision History

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 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.