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 | Documented standard plugin tables in new appendix Appendix G, Plugin tables Removed Upgraders: PLEASE READ! sidebar from Chapter 8, Built-in Scalar 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 Chapter 11, System Packages, 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 Section 6.1.18, “Full SELECT Syntax” as a first step to address current incomplete/simplified syntax used in Section 6.1, “SELECT” Removed incorrect <common-table-expression> production in SELECT syntax Revised syntax used in Section 6.1, “SELECT” and Chapter 10, Window (Analytical) Functions for completeness and correctness Document <parenthesized-joined-table> in Section 6.1, “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
|