Red Database 3.0 - v3.0.8.0
Aug. 12, 2021, 10:17 a.m.
Changelog
Fixed:
- Fixed incorrect "ALTER TABLE ... SET DEFAULT ..." behavior
- Fixed server crash if config contains anonymous section
- Fixed database restoring if the backup has external procedures with dependencies but the external engine is missing
- Fixed O_DIRECT support. Now when O_DIRECT mode used reads made by 4K into buffer aligned to 4K
- Fixed server crash on some combinations of authentication plugins
- CREATE OR ALTER now creates metadata in security database
- LDAP password could be unintentionally deleted after user activation
- Fixed incorrect behavior while replication segments archiving
- Fixed wrong value in LDAP attribute rdbAccessTime after failed multifactor authentication
- Fixed server crash caused by "SIMILAR TO" clause
- Fixed repldiff utility help
Changed:
- ODS increased to 12.3 as an index has been created on the RDB$PAGES system table
- While restoring from 2.6 missing feature warning "mandatory access" is printed only once
Improved:
- Optimized monitoring tables access
- Decreased SuperServer memory consumption
- Increased cache performance on SuperServer including systems with NUMA architecture
- Speedup temporary index operation
- Name and PID of remote client passed through services and reflected in MON$ATTACHMENT
Added:
- Optimization strategies OPTIMIZE FOR { FIRST | ALL } ROWS ported from 2.6
- Stable cursors support
- Multithreaded backup/restore
- Multithreaded sweep
- Trace now prints memory consumption by sorting
- New LDAP user management functions
- Added ability to get LDAP users with SEC$USERS table
fbjava updated to 1.1.14:
- Fixed possible server crash on shutdown when unloading fbjava plugin
fbjava-lucene updated to 2.0.14:
- Lucene updated to 7.7.3 to address IndexWriter initialization (https://issues.apache.org/jira/browse/LUCENE-8310)
- Now FTS initialization script creates procedures and functions with "SQL SECURITY DEFINER"
Ported from Firebird:
- Fix #6854 - Crash occurs when use SIMILAR TO and compare string with pattern that contains non-ascii character with suppressed exception handling (or "Invalid SIMILAR TO pattern" raises otherwise).
- Fix #5534 - String truncation exception on UPPER/LOWER functions, UTF8 database and some multibyte characters.
- Fix for #6817: -fetch_password passwordfile does not work with gfix
- Fix for #6836 - fb_shutdown() does not wait for self completion in other thread
- Fixed bug GH-6866 : Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
- Avoid calls to JRD_get_thread_data.
- Remove pool reference and children lists in each node: Children lists will be created and destroyed on demand.
- Better handling for the scratch pool and fixed CORE-5646: CORE-5646 - Parse error when compiling a statement causes memory leak until attachment is disconnected.
- Revert to statically alloc the parser instance: Added a scope block to delete it before the scratch pool is destroyed in DsqlDmlRequest::dsqlPass.
- Process nodes using the scratch pool as default pool: To make it work, change MAKE_parameter to allocate parameters in the message pool (statement pool).
- Delete the scratch pool in the end of DML compilation
- Remove kind field.
- Remove dsqlCompatDialectVerb field and organize some members in AggNode for better alignment.
- Backported PR168 and PR294
- Backport fixes for memory leaks found by Jiří, see "Memory leak with external engine plugin" in fb-devel
- Make sure Engine instance is not destroyed before SharedXXX objects, that uses pointer on Engine in own dtor's.
- Backport one more fix against memory leak in UDR
- Fixed #6889: no permision while ALTER USER SET TAGS
- Fixed failure of test bugs.core_0927
- One more postfix for #6220
- Backported fix #6896: Client forcing server to encryption
- Postfix for #6220 - thanks to Adriano
- Aplly fix for #6220 - slow performance when executing SQL scripts as non-SYSDBA user (used for >2 years in IBP)
- Fixed bug #6918 : Service detach is always traced