Added

• Ability to set filter for root variables. RS-183412.
• Support for semi/anti and outer joins to hash join algorithm.
• New API function to disable api-side CTRL handler. RS-68721.
• Config for FTS plugin. RS-174596.
• Ability to comment on jobs and tablespaces. RS-98334.
• Aggtrace configuration via file. RS-181824.
• Configuration parameter "LoginLockoutTime". It sets the user lockout time when the maximum number of failed authentication attempts exceeds the value specified by the policy. RS-171429.

Improved

• Store output and temp JSONs in blob/tempspace. RS-173970.
• Add reopen control file and save next sequence to it after replicate. RS-175598.
• Use the cursor when searching for a user in security.db to avoid failed search statements in the trace logs. RS-190364.
• Display of the null metrics in gstat. RS-139426.
• Allow escape single quote in JSON Path. RS-186529.
• Ability to trace self security databases. RS-149657.
• Infer real selectivity of the first segment of compound index from the available single-segment indices for the same field. RS-190754.

Fixed

• Return blob for JSON generation functions. RS-150524.
• Privilege check when user queries aggtarce action service. RS-172451.
• Correct trace event results in syslog. RS-175569.
• Fix a case of deleted memory modification. RS-184107, RS-183777.
• Fix format specifies type after CodeChecker review. RS-186206.
• Skip control file from scan segments. RS-186206.
• The error of revoking user privileges. RS-86638.
• Crash when MAKE_DBKEY() is called with 0 or 1 arguments. FB-8221.
• Database creation in 3.0.12, 4.0.5 and 5.0.1 slower than in previous releases. FB-8220, FB-8219.
• The system error logging function was incorrectly marked as "noreturn", which could cause a crash. RS-183104.
• WHEN NOT MATCHED BY SOURCE - does not work with a direct table as source. FB-8213.
• DATEADD truncates milliseconds for month and year deltas. FB-8211.
• Manual delete for tra_dbcreators_list. FB-8207.
• Make subquery optimization enabled by default.
• Mark result of json pullaggregate functions as JSON. RS-183360.
• Make sure trace time will not be overflowed. RS-188140.
• Write plugin name when error occurs. RS-181824.
• Missing initialize and delete for policies list in transaction. RS-53155.
• Function MAKE_DBKEY may produce random errors if used with relation name Also, corrected handling of non-ASCII tables names. FB-8203.
• Don't introduce method that might not be used after schemas implementation.
• SIGSEGV in Firebird 5.0.0.1306 embedded during update on cursor - disallow caching for positioned updates/deletes. FB-8185.
• Make sure trace session slots will not break use counter. FB-8180, FB-8192.
• Crash on adding NULL parameter in statement parameters monitoring. RS-188545.
• Parsing of the big (32k+) chunk in tracemgr. RS-188448.
• Validate input of JSON_ARRAY with query and execute query via EVL_expr.
• Error without set term when declaring a procedure inside a procedure. RS-183887.
• Disable api-side ctrl handler in tracemgr. RS-155426.
• Fixed a bug where show comments did not see comments for tablespace. RS-98334.
• Slow connection times with a lot of simultaneous connections and active trace session present. FB-8189.
• Use correct way to initialize shared events. Fixed few race conditions and hangs. Unlink file used for shared memory when it is gets unused. FB-8186.
• Reread trace config for services. RS-186890.
• Fix read PositionedBlock in replmgr utility when use -L option. RS-186206.
• Put trace error in log writer if possible. RS-181824.
• Make sure JSON functions return blob with text subtype. RS-150524.
• Ensure the CS listener uses the SO_REUSEADDR socket option. FB-8181.
• Fix sync mode in repldiff utility. RS-175601.
• Fix boolean conversion to string inside DataTypeUtil::makeFromList(). FB-8178.
• Do not delete system trace session with missing parent process. FB-8179.
• Firebird 5 hang after starting remote profiling session. FB-8176.
• Trace plugin unloaded if called method is not implemented. FB-8171.
• The file include/firebird/impl/iberror_c.h is missing in the Linux x64 tar archive. FB-8172.
• Avoid not necessary allocations from pool when performing FK check. It fixes most significant source of contention in SuperServer when FK index is created by many parallel workers. FB-8071.
• Firebird 5 hang after starting remote profiling session. FB-8176.
• Combine multiple JUnit XML files into single XML file. RS-182216.
• Set authentication block as incomplete after attachment to db, to double prove that authentication routine is proceeded on reconnect (even if we ignore authentication normal sequence). RS-182581.
• MAKE_DBKEY bug after backup/restore. FB-8168.
• If relation not found at parse time. don't prevent further loading of PSQL object and throw error later - at execution time.
• JSON Refactoring: Rename JsonState to JsonAction. RS-179736, RS-183291.
• Allow spaces in service name when (un)installing via (un)install_service.bat. FB-7911.
• Do not drop port with packet queue after failed reconnect, there could be unprocessed packets. RS-182581.
• Inner join raises error 'no current record for fetch operation' if a stored procedure depends on some table via input parameter and also has an indexed relationship with another table. FB-7937.
• Print a warning and do not bring a database online at the end of restore if -N or -I option is used. RS-157476.
• Can not specify concrete IPv6 address in ES/EDS connection string. FB-8156.
• Refactoring of CAST FORMAT. FB-7881, FB-8134.
• Deadlock happens when run 'List Trace Sessions' service and there are many active trace sessions. FB-8151.
• Process could attach to the deleted instance of shared memory. FB-8150.
• The hung or crash could happen when connection fires TRACE_EVENT_DETACH event and new trace session created concurrently. FB-8149.
• Bugcheck when replicator state is changed concurrently. FB-8138.
• Fix an issue where the precedence relationship with a PIP was not set for all data pages of a new extent except the first one. RS-159008.
• Prevent buffer overflow during data page compression. RS-160299.
• SubQueryConversion = true -- multiple rows in singleton select. FB-8233.
• Add missing synchronization to cached vectors of known pages. FB-8069.
• Add hint to JSON passing error message. RS-162032.
• Fix returning invalid blob id in case of big input JSON. RS-191886.
• SubQueryConversion = true -- error 'no current record for fetch operation' with complex joins. FB-8223.
• SubQueryConversion = true -- wrong resultset with FIRST/SKIP clauses inside the outer query. FB-8224.
• Add missing table counter column to text trace output. RS-191447.
• Fix rdbrepldiff incorrect blob comparison and calculation of table count difference. RS-92307.
• Add -VA to repldiff service as dif_values key. RS-92307.
• Add information about field name that has different data in repldiff -VA output. RS-92307.