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

…​

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)

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

Computed columns can be indexed with expression indexes

Fixed wrong section levels for subsections of [fblangref50-management-setdecfloat]

Replaced firebird-docs references with firebird-devel

Updated [fblangref50-appx02-tbl-errcodes01] with error information from 5.0.0.1068

Add caution about relying on ordered derived tables for [fblangref50-aggfuncs-list]

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

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]

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