Added

• Add generated files for OO API for C language to distribution. FB-8197.
• New compression plugin ZSTD. RS-67113.
• Storing applied replication segments on replica side. RS-168898.
• Ability to sync "on-the-fly" sync primary and async replica. RS-173670.

Improved

• Add different ways to get master database GUID to replmgr with status option. RS-193858.
• Update tzdata to version 2024b. FB-8260.
• Win_sspi plugin uses NTLM. FB-8256.
• Save isql history by statement rather than by line. RS-186026.
• Implement cost-based choice between ORDER and SORT plans. RS-192909.
• Add a hostname to a trace. RS-149731.
• RemoteAuxPort is per-database not per-connection.
• Increase limits for opened files and created processes in systemd unit file RS-188825.
• Use absolute paths in systemd service, because some distros can miss proper PATH RS-187450.
• Added shutdown handler for server. FB-8165.

Fixed

• Improvements to cancel_on_error option after testing. RS-182080.
• Bad performance on simple three-way join over the same set of fields. FB-8250.
• Make server to correctly handle case when accept() returns both success and data for client.
• Avoid "hangs" in clock_gettime() in tomcrypt PRNG. FB-8236.
• Fixed unauthorized access to ts with directories.conf. RS-89473.
• Fix inability to create TS after BEGIN BACKUP. RS-194501.
• Second step to a proper SORT vs ORDER cost calculation.
• Wrong json variable type for second path. RS-183412.
• Catch possible stack overflow when preparing and compiling user statements. So far, on Windows only.
• Always use single quotes around OS object names (user or group) in SHOW MAPPING output. FB-8253.
• Incorrect handling of non-ASCII object names in CREATE MAPPING statement. FB-8253.
• Fixed incorrect dependency checking on alter column comand. RS-105991.
• Semi-joined streams may be intermixed with inner-joined ones. FB-8223.
• Incorrect subquery unnesting with complex dependencies. FB-8252.
• Fix regular expression value substitition in fbtrace.conf after macro substitition.
• Fix a bug where the shutdown handler could be called again.
• Shutdown a job scheduler thread before providers and print a log message if it was not completed within timeout. RS-190176.
• Fix aggtrace hash to take the database name into account. RS-194163.
• Add saving applied segments on the replica. RS-168898.
• Change integer config values bounds to FB_UINT64 data type. RS-192945.
• Fix executable file names in Windows. RS-88298.
• Avoid unnccecery copying in JSON. RS-75306.
• Cardinality estimation should use primary record versions only. FB-8161.
• Gbak may lose NULLs in restore. FB-8241.
• Rare sporadic segfaults in test for core-6142 on windows. FB-8215.
• Allow the DB owner to connect to a shutdown database using the gbak utility (for parallel restore). RS-195409.
• Fix read of replication sequence from delta when database in backup lock. RS-192374.
• Fix read guid from master database. RS-193858.
• Gbak on classic with ParallelWorkers > 1 doesn't restore indices, giving a cryptic error message. FB-8263.
• Nested IN/EXISTS subqueries should not be converted into semi-joins if the outer context is a sub-query which wasn't unnested. FB-8265.
• Fix write "Last log message repeated" when write new message.
• Fix SQLSTATE file blob read error. RS-195051.
• Reinitialization of async replica. RS-192180.
• Wrong behavior of blob key in gstat utility. RS-194222.