FirebirdSQL logo
 License notice

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

Revision History

0.7

TBD

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

  • …​

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 [fblangref50-scalarfuncs-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 [fblangref50-scalarfuncs-tbl-encrypt-req] about AES variants

  • Replaced incorrect ROLE keyword with DEFAULT in example in [fblangref50-security-rdbadmin01]

  • Miscellaneous copy-editing

0.2

10 May 2023

MR

  • Documented “standard” plugin tables in new appendix [fblangref50-appx07-plgtables]

  • Removed Upgraders: PLEASE READ! sidebar from [fblangref50-functions], the Possible name conflict sections from function descriptions and the Name Clash note on LOWER()

  • Integrated (most) changes from the Firebird 5.0 beta 1 release notes

  • Added new chapter [fblangref50-sys-pckg], and moved RDB$TIME_ZONE_UTIL documentation to it, and added RDB$BLOB_UTIL and RDB$PROFILER documentation

  • Documented that subroutines can access variables of their parent

  • Simplified CONTINUE and LEAVE examples, by removing unnecessary ELSE

  • Documented PLAN, ORDER BY and ROWS for UPDATE OR INSERT and PLAN and ORDER BY for MERGE

  • Added [fblangref50-dml-select-full-syntax] as a first step to address current incomplete/simplified syntax used in [fblangref50-dml-select]

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

  • Revised syntax used in [fblangref50-dml-select] and [fblangref50-windowfuncs] for completeness and correctness

  • Document <parenthesized-joined-table> in [fblangref50-dml-select]

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