Downloads

Ред База Данных 5 - 5.0.2

02/24/2025

Changelog:

Improved

• Add cardinality-based heuristics for hash vs loop semi-join choice. RS-215532.
• Report unique usernames for isc_info_user_names. FB-8353.
• Some more file descriptions for Windows binaries. RS-88298.
• Improve performance of the precedence queue. This should speed up synchronization of superserver page cache. RS-210151.
• Add sub-section to configure username and password for sync_replica with the ability to read its from a file or from an environment variable. RS-72229.

Fixed

• Worse plan in RDB5 for joins with ORDER BY. RS-214485.
• Crash when creating index on table that uses UDR and ParallelWorkers > 1. FB-8386.
• SIGSEGV with WHERE CURRENT OF statement with statement cache turned on. FB-8185.
• Fix race in shutdown thread start. FB-8380.
• More correct plan output for subqueries generated during NOT IN transformation.
• Rework fix "Available indices are not used in some cases if ORDER BY expression is a filtered one" and also attempt to fix the special case for OR conditions partially matched to an index. FB-5751.
• Revert "Better (methinks) inversion choice when the OR condition includes a node which is also matched directly"
• Disable the precedence during the database restore. RS-204336.
• Incorrect cardinality estimation for retrievals with multiple compound indices having common set of fields. FB-8379.
• Fix statement ID output format in the trace.
• Move isc_repl_mispos to the RDB number space, sync error codes with FB.
• Revert "Make replication.conf readable and writable only for reddatabase user/group". RS-201548
• Missed records in replicated database. FB-8350.
• Do not initialize replicator if no replication plugin is found. RS-207890.
• Cleanup batches inside the engine if they were not released explicitly before disconnection. This avoids a resource leak (it's mostly about TempSpace). FB-8341.
• Fix segfault when using JSON_TABLE with PROCEDURE in VIEW. RS-208209.
• Disable permissions check when grant/revoke rights for the replicator process. RS-208502.
• Remove redundant plugin reload on super server, update it only on classic after stateLock ast. FB-8393.
• Deadlock might happens when database is shutting down with internal worker attachments exists. FB-8390.