Appendix IDocument History

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

Revision History

1.22

02 Oct 2024

MR

  • Improved documentation of PSQL blocks to make clear WHEN …​ DO can only occur at the end of a block (#208)

  • Trigger order for the same position was documented as alphabetical by name; the actual order is undefined (#213)

1.21

20 Apr 2024

MR

Corrected description of RDB$CHECK_CONSTRAINTS (#206)

1.20

2 Apr 2024

MR

Protocol names are lowercase (#205)

1.19

17 Jan 2024

MR

  • Corrected result type description of SUM

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

1.18

15 Dec 2023

MR

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

1.17

09 Nov 2023

MR

  • Fixed incorrect "equivalent" for REGR_COUNT

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

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

  • Added TCPv6 to NETWORK_PROTOCOL for SYSTEM namespace (#170)

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

1.16

20 Jun 2023

MR

  • Computed columns can be indexed with expression indexes

  • Replaced firebird-docs references with firebird-devel

  • Add caution about relying on ordered derived tables for Section 9.1.3, “LIST()

1.15

26 May 2023

MR

1.14

10 May 2023

MR

Removed incorrect <common-table-expression> production in SELECT syntax

1.13

30 Jan 2023

MR

Fixed typo in collation name UCS_BASIC

1.12

27 Oct 2022

MR

1.11

31 Jul 2022

MR

Move RDB$TRIGGER_TYPE description to separate section to prevent truncation of table cell in PDF

1.10

18 Jul 2022

MR

Fix documentation for RDB$INDICES.RDB$INDEX_TYPE (#174)

1.9

13 Jul 2022

MR

DATEDIFF unit MILLISECOND returns NUMERIC(18,1) since Firebird 3.0.8 (#173)

1.8

03 Jan 2022

MR

Values for RDB$RELATION_FIELDS.RDB$IDENTITY_TYPE were swapped (#168)

1.7

16 Oct 2021

MR

EXECUTE STATEMENT named parameters are regular identifiers (#164)

1.6

29 Sep 2021

MR

Explicitly document transaction isolation level of ON CONNECT/ON DISCONNECT triggers (#163)

1.5

31 Jul 2021

MR

Fix behaviour documented for SNAPSHOT TABLE STABILITY (#158)

1.4

23 Jul 2021

MR

Remove extra SELECT in select syntax

1.3

13 Jun 2021

MR

  • Fixed wrong table title NUMERICDECIMAL

  • Fixed wrong link title DATEADDDATEDIFF

1.2

27 Apr 2021

MR

  • Added missing } in regular expression special characters (see issue 124)

  • Fixed rendering issue hiding the _ in regular expression special characters

  • Improve wording of CURRENT_CONNECTION and CURRENT_TRANSACTION (see issue 96)

1.1

05 Apr 2021

MR

Corrected syntax mistake in SUBSTRING(…​ SIMILAR …​) documentation.

1.0

20 Feb 2021

MR

Using the Firebird 2.5 Language Reference as a starting point, incorporated all changes in Firebird 3.0, using the Firebird 3 Release Notes and the Russian Firebird 3.0 Language Reference.

Some restructuring was done for maintainability and readability.