1.23

03 Apr 2025

MR

• Added links to CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, LOCALTIME, and LOCALTIMESTAMP from chapter Built-in Scalar Functions

• Added cross-reference between the datetime context variables

• Fixed wrong nesting of sections in operators

• RDB$TRANSACTION_STATE values were off by one (#217)

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

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

• CURRENT_CONNECTION returns BIGINT

• 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 incorrect ROLE keyword from example in Section 13.1.2.2, “Granting the RDB$ADMIN Role in a Regular Database”

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

• Fixed incorrect whitespace in table names

• Added missing table name in FROM in Section 5.9.1.3, “Deterministic functions” (#177)

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 NUMERIC → DECIMAL

• Fixed wrong link title DATEADD → DATEDIFF

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.