Downloads

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

10/01/2025

Changelog:

Update JavaEngine to 2.0.1

• Update Jaybird 5 to 5.0.23 release to fix parameter type setting for prepared statement in OO API implementation. RS-234284.
• Close the statement to get commit number immediately after execution to avoid locking on closing. RS-227045.
• Update the index by deleting a record and adding the actual fields data to it. RS-224779.
• Get roles list directly, not from user privileges table. RS-221789.
• Implement replication logs for full-text indexes. RS-216462.
• Use "VARBINARY" type for FTS$KEY field. RS-105673.
• Fix threads deadlocking when the indexing stop daemon is called. RS-214213.
• Add description of Java Engine and FTS libraries. Fix resource file encoding. RS-88298.
• Update OO API interfaces implementation. RS-192252.

Update Kafka CDC connector to 2.0.0-rc.9

• Load connector configuration from "reddatabase.connector.yaml" file in the server root directory, if the option with configuration path is not specified in "jvm.args". RS-69574.
• Add description to the library file. Fix resource file encoding. RS-88298.
• Update Jaybird to 5.0.20 to work with rdbclient library. RS-190784.

Fixed

• Do not ignore system config when creating TraceManager. RS-248436.
• Add support of the IN predicate to the equality distribution logic. FB-8732.
• Error when creating one user in different plugins in one transaction. RS-218501.
• On Windows 7 isql exits silently right after the start. FB-8690.
• Show offset from data begin instead offset from file begin. RS-245339.
• Replica reporting offset of data without segment header, so we should add segment header length to interesting offset when reading segment. RS-244815.
• Prevent race condition when GlobalObject destruction routine unlocks global mutex FB-8687.
• Restore NATIVE_ORDER flag for config parser. RS-239271.
• Division by zero when trying to send inline file blob. RS-244455.
• Fixing the error of adding an identification column. RS-222079.
• fbclient incompatible to older ODS. FB-8675.
• Fix crash/hang during shutdown after the attachment was unsuccessfully ping'ed. FB-8674.
• Fix getting issuer from certificate when the locale does not match the system locale. RS-231829.
• Error unable to allocate memory from operating system. FB-8673.
• Do not skip mon$replication records for different classic instances. RS-242512.
• Fixed crash after calling incorrectly parametrized request. FB-8666.
• Connection error via Loopback provider if it's the first in the Providers parameter. FB-8644.
• SHOW DEPENDENCIES command terminates unexpectedly if there are packages in the dependencies. FB-8665.
• TRANSACTION_ROLLBACK missing in the trace log when appropriate DB-level trigger fires. FB-8653.
• AV when ON CONNECT triggers uses EXECUTE STATEMENT ON EXTERNAL. FB-8649.
• Crash in TipCache::findStates. FB-8550. FB-8296.
• Incorrect join order for JOIN LATERAL with UNION referencing the outer stream(s) via its select list. FB-8628.
• Allow attachment by CryptoManager during restore.
• Skip execution of AFTER UPDATE system ref constraints triggers if update have not changed key fields.
• Error doing nbackup when Database file name has extended ASCII chars. FB-8588.
• Fix incorrect to-from WideString conversions. RS-225322.
• Correct handling of TLS v1.2 in LDAP.
• Prevent server hangs after BUGCHECK. RS-225684.
• Fix possible hang on error when granting policy.
• Fix a rare case of missing committed records after a server crash. RS-220168.
• Avoid races in logging and make the verbose output somewhat less verbose. RS-240890.
• Missing error message in stderr. RS-240659.
• Return current replication position without creating a new segment.
• rdbreplmgr -create does not work properly. RS-239091.
• Fix check sign with certificate in mint utility. RS-234295.
• Handle IN with single parenthesized query as table-query. FB-8182.
• Presence of 'ROWS ' causes garbage in error message when string conversion problem raises. FB-8592.
• PERCENT_RANK may return NaN instead of 0. FB-8589.
• Replication journal could be incorrectly ignored during adaptive repliction. RS-230401.
• Prohibit simultaneous exclusive locking of bdb_syncPage and bdb_syncIO in different contexts of the same thread. RS-221778.
• GBAK: GDS error batch_big_seg2 when restoring a table with many BLOBs, thanks to Vlad. FB-8574. FB-8444.
• Stop blob reading when restore task receives stop signal. FB-8529.
• ISQL will truncate lines longer than 255 when pasting. FB-8524.
• Add extract filename of db from param of logmgr or replmgr utilities for correct use with host specified. RS-230668.
• Raise the correct error about system privilege revocation. RS-218444.
• Prevent printf injection in replication.conf.
• Internal consistency check (page in use during flush) with small number of DefaultDbCachePages. FB-8194.
• Do actual cancel after we finished control file update. RS-230282.
• If transaction number in journal less than OAT assume it was committed. RS-200540.
• Use RWLock when printing memory pools to avoid deadlock.
• Fixed server hang when entering ascii_char(0) separator in UNLIST function.
• Error in iTransaction.getInfo() on embedded connection. FB-8520.
• Init (or remap) the shared memory file of size 2GB to 4GB in the right way.
• "Error creating private namespace" message in firebird.log. FB-8509.
• Fix deadlock between replication thread and monitoring AST. Slightly refactor replication sequence storage/management. Recover the sequence after a crash.
• Fix incorrect user data in the backup log. RS-98211.
• Conversion Error with old.field in UPDATE OR INSERT. FB-8508.
• Restored the ability of fbclient to work with multiple blobs with the same blob_id at the same time.
• Fix use any host address for the replica database in repldiff utility. RS-226456.
• MIN/MAX aggregates may badly affect the join order in queries with mixed INNER/LEFT joins. FB-8488.
• Prohibit the use of tablespaces for external tables. RS-225266.
• Nullify tdbb_temp_traid when an exception occurs in check_partner_index. RS-86799.
• Replace BUGCHECK with throwing an exception in the index-related code in places where it's safe to do so. RS-86799.
• Fixed crash in engine as shown by failed QA test gh_8221_test.
• Support time zone displacement in TZR pattern for string-to-date conversion. FB-8481.
• Throw exception for non-existing date. FB-8469.
• Fix incorrect behavior of FF1 - FF4 patterns in CAST FORMAT for string to datetime conversion. FB-8454. FB-8459.
• Processing of gluing "0" with "ORDER". RS-222463.
• Segfault on incorrect databases.conf starting with subconfig. FB-8485.
• Revert "RS-8598: session suspend feature".
• Reworked interaction with incoming parameters of blob type, separator has not been touched yet. RS-206824.
• Inheritance of WINDOW does not work. FB-8477.
• Fix gstat output for tables over 4GB in size.
• Don't revoke the admin role from the user to be deleted if it exists in other plugins. RS-218500.
• Gbak does not report warning about index not being usable. RS-148495.
• Allow a user with the "GRANT_REVOKE_ON_ANY_OBJECT" privilege to revoke permissions that were granted by someone other. FB-8462.
• Unauthorized access to server files by read_file function. RS-187503.
• Close port_async when forcebly closing main port. FB-8432.
• When checking transaction states in journals, threat journal sequence with zero offset as journal with previous sequence.
• Try to match transactions in replication journal with transactions in TIP. Ignore journal length but check if transactions in TIP advanced beyound journal's.
• If logmgr unable to archive segment raise error. RS-227678.
• Match running guardian in process debian Sys V init script by name, user and pidfile. Do not kill it manually, let start-stop-daemon do it, its oknodo parameter let as return with zero return code if service already stopped. RS-220597.
• Races when server is closed during forced database shutdown. FB-8449.
• Avoid index scan for lower/upper bounds containing NULL keys. FB-8447.
• Do not allow run concurrent sweep instances. RS-229729. FB-8320.
• Segmentation fault when running query with partition by and subquery. FB-8437.
• Do not recreate shared memory on cache clear sync. RS-219043.
• "Create or alter generator ... start with ..." should change the initial value. RS-215913.
• Remove write permission check for GSS lib and GSS key parameters (read is enough). RS-209956.
• Segfault when already destroyed callback interface is used. FB-8429.
• Plan/Performance regression when using special construct for IN. FB-8425. FB-8109.
• Don't throw an exception during mapping if the regular expression in the USER part can't be processed. RS-211221.
• Remove config parameters values printing in security measures. RS-210560.
• Fix potential deadlock when starting the encryption thread. FB-8403.
• Do not disconnect port if we are going to reuse it as a reconnect port in WIN_SSPI plugin.
• Return 0 retcode with -I or -N options if there is no other errors. RS-200975.
• Add missing mergeStats in garbage collector and cache writer threads. FB-8392.
• Fix incorrect initialization of availability of the sync/async replication feature. RS-213871.
• Put auth block for migartion connection. RS-211093.
• Fix a crash appeared after the bugfix for FB-8185 (SIGSEGV with WHERE CURRENT OF statement with statement cache turned on).
• Revert "Better (methinks) inversion choice when the OR condition includes a node which is also matched directly".
• Fix use ":@" characters and add sub-section to configure username and password for sync_replica. FB-8327.
• Added the necessary setting for JavaEngine to work. FB-205782.
• Don't allow to change FW mode while database has connections. RS-86760.
• Fixed cardinality mistake for invariant booleans.
• Reworked fix for FB-5654: Could not execute query (select from view with nested view). FB-5654.
• Incorrect result of index list scan for a composite index, the second segment of which is a text field with COLLATE UNICODE_CI. FB-8214.
• Fix missing synchronization of the shared monitoring data.

Improved

• Change default hash method in configuration to 32801 (GOST R 34.11-2012 256).
• Port ExtAuth work with SQL SECURITY DEFINER to RDB 5.1. RS-151673.
• Adjust reconnecting logic for sync-async replica. RS-234332.
• Additional information in the system error message. RS-230998.
• Improve JSON Parsing performance. RS-228485.
• Add alias recognition to directories.conf. RS-231737.
• Additional information in BUGCHECK message. RS-231000.
• Refactor rdblogmgr utility. RS-227526.
• Update tzdata to version 2025b. FB-8515.
• Add the ability for users to create themselves in other user managers. RS-218996.
• Makes MON$COMPILED_STATEMENTS and MON$STATEMENTS share blobs with text and plan content of the same statement. FB-8513.
• Optimize tracking of used tablespaces in queries and transactions. RS-203223.
• Recover replica up to the specified position and perform journal-based recovery on demand.
• Make TimeoutTimer::expired() tolerate rounding in TimeoutTimer::currTime() up to 1 ms.
• Make Trace use HEX representation for parameter values ​​of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY. FB-8356.
• Print detailed blob statistics and table size. FB-8394.
• Ability to specify "FROM" user name in mapping using regular expression. RS-211379.
• Add escape quote char to parse config. RS-211090.
• Give up on engine throttling when auto-resync if user configured timeout. RS-228774.
• Better check possible dependencices inside generated RSB and use loop join vs hash join plan accordingly.
• Add pointers tree to TempSpace class for faster search of a free segment of the required size in memory manager. RS-185051. FB-8421.

Added

• Introduce a zlib-based plugin for (de)compressing backups and compatibility with FB backups. RS-203204.
• Send small blobs inline. FB-8318.
• Implementation of checksums. RS-194667.
• Add cardinality-based heuristics for hash vs loop semi-join choice.
• Add auto_resync param to replication config. RS-213871.
• Print OAT and NT before transaction recovery. RS-200540.
• Ability to recover transactions on master host using replication journals. RS-200540. RS-240374. RS-244815. RS-246203.