Firebird 4.0.4.3010-0 + x64

Improvements:
RDB$GET/SET_CONTEXT(): quoting the missing namespace/variable makes output more readable (#7539)
Update Windows distribution with new zlib version 1.3 (released 2023-08-18) (#7755 )

Improvements:
RDB$GET/SET_CONTEXT(): quoting the missing namespace/variable makes output more readable (#7539)
Avoid non necessary index reads (#7494)
Add switch to control in guardian timeout before killing Firebird server process (#7468)
Update zlib to version 1.2.13 (released 2022-10-13) (#7437)
Add REPLICA MODE to the output of the isql SHOW DATABASE command (#7425)
Improve reliability of plugin manager (#7418)
Allow FB-known macros in replication.conf (#7294)
Remove TcpLoopbackFastPath and use of SIO_LOOPBACK_FAST_PATH (#7259)
Nbackup RDB$BACKUP_HISTORY cleanup (#7186)

Improvements:
6910 — Add way to retrieve statement BLR with Statement::getInfo() and ISQL’s SET EXEC_PATH_DISPLAY BLR.
6959 — Add getInfo() method to the Batch interface in the API.
6954 — Add fb_info_protocol_version information request to Attachment::getInfo().
6929 — Add support of PKCS v.1.5 padding to RSA functions, needed for backward compatibility with old systems.
6915 — Allow attribute DISABLE-COMPRESSIONS in UNICODE collations.
6903 — Make it possible to create ICU-based collations with locales keywords.
6872 — Faster indexed STARTING WITH execution with UNICODE collations.
6810 — Use precise limit of salt length when signing messages and verifying the sign.
6809 — Integer hex-literal support for INT128.
Bug Fixes:
Core Engine:
7070 — Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record.
7064 — Linear regression functions aren’t implemented correctly.
7062 — Creation of expression index does not release its statement correctly.
7057 — Client-side positioned updates work wrongly with scrollable cursors.
7056 — Fetching from a scrollable cursor may overwrite user-specified buffer and corrupt memory.
7052 — Races between transactions on the primary side may cause update conflicts while applying journals to the replica.
7048 — Incorrect releasing of user savepoint (older savepoints become inaccessible).
7043 — Wrong message when user has no access to /tmp/firebird.
7033 — Replicator is missing sanity checks for user-supplied blocks.
6998 — Problems with access to RDB$CONFIG table for non-privileged user when he has grant on execution of stored procedure which has necessary access rights (created by SYSDBA with SQL DEFINER clause).
6995 — "String truncation error" is raised while restoring the database from a v2.5 backup.
6989 — Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no "replica" flag set.
6976 — Lack of proper clean up after failure to initialize shared memory.
6963 — The REFERENCES permission does not work.
6955 — fb_info_creation_timestamp_tz returns a corrupted buffer.
6935 — SQL SECURITY DEFINER has inconsistent behaviour if the object owner is non-privileged.
6935 — SQL SECURITY DEFINER does not affect the ownership of created DDL objects.
6907 — Failed DDL commands can be replicated.
6900 — IBatch::add() method fails silently when a memory limit is exceeded.
6893 — Problem with replication of BLOB segments longer than 32KB.
6887 — Invalid SIMILAR TO patterns may lead memory read beyond string limits.
6886 — Differerent interfaces behaviour depending upon source of interface.
6887 — Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from a variable.
6874 — Literal 65536 (interpreted as int) cannot be multiplied by itself without cast if result is more than 2^63-1.
6860 — Create user statement fails with SQLSTATE = HY000 when using DataTypeCompatibility setting.
6856 — Permission error after replication of DDL commands.
6853 — Asynchronous replication leaks file handles.
6850 — Database-level and DDL triggers are executed at the replica side.
6849 — Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear (and PK/UK violation to happen).
6848 — Generator values may not replicate after commit.
6845 — Result type of AVG over BIGINT column results in type INT128.
6838 — Deleting multiple rows from a view with triggers may cause triggers to fire just once.
6801 — Error recompiling a package with some combination of nested functions.
Server Crashes/Hang-ups
7067 — Deadlock when using not initialized security database.
7060 — Deadlock when execute test for CORE-4337.
7034 — Server crashes while fetching from a scrollable cursor in PSQL.
7018 — Crashes or incorrect results for some windows frames.
7015 — Replication applier code may crash if the specified block contains no savepoint operations.
6985 — Application could hang when using new Batch API with blobs over XNET.
6975 — Crash or hang while shutting down the replica database if segments are being applied.
6945 — Segfault in the batch interface when gbak restores a database with many blobs over the wire.
6930 — Segfault when calling cryptographic functions.
6913 — Buffer overflows in getInfo() APIs.
6909 — Some updates may crash Firebird server on the replica side.
6832 — Segfault when using COMMIT RETAINING with Global Temporary Tables.
API/Remote Interface:
7068 — Errors in the ChaCha plugin are displayed incorrectly.
7066 — Server may send incorrect specific data to client when establishing encrypted connection.
7065 — Connection hangs after delivery of 256GB of data.
Windows Only:
6968 — On Windows, engine may hang when works with corrupted database and read after the end of file.
Builds:
7037 — Build problem when using both --with-builtin-tommath and --with-builtin-tomcrypt.
6978 — Firebird 4 fails to build on big-endian platforms.
Installation Issues:
6979 — Windows x64 server installer installs an incomplete x86 client.
6943 — Windows client install is missing some DLLs.
6917 — Firebird 4 installer asks for SYSDBA password when doing client installation.