Appendix JDocument History

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

Revision History

1.0

02 Oct 2024

MR

  • Transformed a lot of NOTE-admonitions to be simple paragraphs or lists, or removed them entirely

  • 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)

0.9

20 Apr 2024

MR

Corrected description of RDB$CHECK_CONSTRAINTS (#206)

0.8

2 Apr 2024

MR

Protocol names are lowercase (#205)

0.7

17 Jan 2024

MR

  • Changed note regarding SKIP LOCKED to (once again) match release notes

  • Added columns RDB$CONDITION_BLR and RDB$CONDITION_SOURCE to RDB$INDICES (#198)

  • Misc. copy editing of BLR column descriptions for consistent language

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

0.6

15 Dec 2023

MR

  • Fixed incorrect syntax documentation of forward declaration of subroutines (#188)

  • Wrong link from ALTER TRIGGER to CREATE TRIGGER (#189)

  • Fixed description of RDB$INDICES.RDB$FOREIGN_KEY (#191)

  • Updated keywords with state as of snapshot 5.0.0.1271

  • Added types 4 and 5 to RDB$FUNCTION_ARGUMENTS.RDB$MECHANISM (#192)

  • Fixed formatting of RDB$FUNCTION_ARGUMENTS.RDB$FIELD_TYPE (https://github.com/FirebirdSQL/firebird-documentation/issues/194)

0.5

29 Sep 2023

MR

  • Removed unnecessary references to older Firebird versions

  • Misc. copy-editing

  • CHAR_LENGTH, OCTET_LENGTH and BIT_LENGTH use BIGINT for BLOB

  • Fixed incorrect "equivalent" for REGR_COUNT

  • Fixed incorrect references to idle timeout in SET STATEMENT TIMEOUT

  • Documented that OVERRIDING USER VALUE also works for GENERATED ALWAYS identity columns

  • Document QUARTER for EXTRACT, FIRST_DAY, and LAST_DAY

  • Document DECFLOAT_ROUND and DECFLOAT_TRAPS for RDB$GET_CONTEXT

  • Document LEVEL in PLG$PROF_RECORD_SOURCES and PLG$PROF_RECORD_SOURCE_STATS_VIEW, order of columns for profiler tables

  • Document new limit for IN-list

  • Document OPTIMIZE FOR {FIRST | ALL} ROWS on SELECT and SET OPTIMIZE

  • Added negative subtype to RDB$FIELDS.RDB$FIELD_SUB_TYPE, and fixed formatting

0.4

20 Jun 2023

MR

0.3

26 May 2023

MR

  • Added missing context variable names for Section 8.1.1, “RDB$GET_CONTEXT()

  • Documented hex-literal support for INT128

  • CURRENT_CONNECTION returns BIGINT

  • PLG$PROF_RECORD_SOURCES.ACCESS_PATH changed to VARCHAR(255)

  • Example for RDB$ROLE_IN_USE() should use RDB$ROLES (#184)

  • Changed explanation of maximum blob size (#160)

  • Notes on RETURNING and updatable views (#95)

  • Replaced occurrence of collation sequence with collation

  • Removed section Joins with stored procedures as it no longer applies

  • Replaced mention that implicit join is deprecated and might get removed; its use is merely discouraged.

  • Removed Available in sections if they listed both DSQL and PSQL

  • Replaced Used for paragraphs with a plain paragraph (so, without explicit Used for title)

  • Rewrote function descriptions to include a short description at the top of each function section

  • Added note in Table 8.85, “Encryption Algorithm Requirements” about AES variants

  • Replaced incorrect ROLE keyword with DEFAULT in example in Section 14.1.2.2, “Granting the RDB$ADMIN Role in a Regular Database”

  • Miscellaneous copy-editing

0.2

10 May 2023

MR

0.1

05 May 2023

MR

Copied the Firebird 4.0 Language Reference as a starting point:

  • renamed files and reference using fblangref40 to fblangref50

  • where applicable, replaced reference to Firebird 4.0 with Firebird 5.0, or rephrased sentences referencing Firebird 4.0