Red Database

Red Database 3.0 v3.0.8.0 (Open Edition)

Aug. 12, 2021, 10:17 a.m.

Fixed:

  1. Fixed incorrect "ALTER TABLE ... SET DEFAULT ..." behavior
  2. Fixed server crash if config contains anonymous section
  3. Fixed database restoring if the backup has external procedures with dependencies but the external engine is missing
  4. Fixed O_DIRECT support. Now when O_DIRECT mode used reads made by 4K into buffer aligned to 4K
  5. Fixed server crash on some combinations of authentication plugins
  6. CREATE OR ALTER now creates metadata in security database
  7. LDAP password could be unintentionally deleted after user activation
  8. Fixed incorrect behavior while replication segments archiving
  9. Fixed wrong value in LDAP attribute rdbAccessTime after failed multifactor authentication
  10. Fixed server crash caused by "SIMILAR TO" clause
  11. Fixed repldiff utility help

Changed:

  1. ODS increased to 12.3 as an index has been created on the RDB$PAGES system table
  2. While restoring from 2.6 missing feature warning "mandatory access" is printed only once

Improved:

  1. Optimized monitoring tables access
  2. Decreased SuperServer memory consumption
  3. Increased cache performance on SuperServer including systems with NUMA architecture
  4. Speedup temporary index operation
  5. Name and PID of remote client passed through services and reflected in MON$ATTACHMENT

Added:

  1. Optimization strategies OPTIMIZE FOR { FIRST | ALL } ROWS ported from 2.6
  2. Stable cursors support
  3. Multithreaded backup/restore
  4. Multithreaded sweep
  5. Trace now prints memory consumption by sorting
  6. New LDAP user management functions
  7. Added ability to get LDAP users with SEC$USERS table

fbjava updated to 1.1.14:

  1. Fixed possible server crash on shutdown when unloading fbjava plugin

fbjava-lucene updated to 2.0.14:

  1. Lucene updated to 7.7.3 to address IndexWriter initialization (https://issues.apache.org/jira/browse/LUCENE-8310)
  2. Now FTS initialization script creates procedures and functions with "SQL SECURITY DEFINER"

Ported from Firebird:

  1. 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).
  2. Fix #5534 - String truncation exception on UPPER/LOWER functions, UTF8 database and some multibyte characters.
  3. Fix for #6817: -fetch_password passwordfile does not work with gfix
  4. Fix for #6836 - fb_shutdown() does not wait for self completion in other thread
  5. Fixed bug GH-6866 : Some orphan records left at RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE\FUNCTION
  6. Avoid calls to JRD_get_thread_data.
  7. Remove pool reference and children lists in each node: Children lists will be created and destroyed on demand.
  8. 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.
  9. Revert to statically alloc the parser instance: Added a scope block to delete it before the scratch pool is destroyed in DsqlDmlRequest::dsqlPass.
  10. 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).
  11. Delete the scratch pool in the end of DML compilation
  12. Remove kind field.
  13. Remove dsqlCompatDialectVerb field and organize some members in AggNode for better alignment.
  14. Backported PR168 and PR294
  15. Backport fixes for memory leaks found by Jiří, see "Memory leak with external engine plugin" in fb-devel
  16. Make sure Engine instance is not destroyed before SharedXXX objects, that uses pointer on Engine in own dtor's.
  17. Backport one more fix against memory leak in UDR
  18. Fixed #6889: no permision while ALTER USER SET TAGS
  19. Fixed failure of test bugs.core_0927
  20. One more postfix for #6220
  21. Backported fix #6896: Client forcing server to encryption
  22. Postfix for #6220 - thanks to Adriano
  23. Aplly fix for #6220 - slow performance when executing SQL scripts as non-SYSDBA user (used for >2 years in IBP)
  24. Fixed bug #6918 : Service detach is always traced

Files

bin/linux/x86_64/RedDatabase-OE-3.0.8.0-linux-x86_64.bin
File: RedDatabase-OE-3.0.8.0-linux-x86_64.bin
  • Size: 19.0 MiB
  • MD5: 3ccedab30c251dd93c7b5409fdf37dae
  • SHA1: f64305dd8b4ae7f820405494044568b608fb0bbd
Download
bin/linux/x86_64/RedDatabase-OE-3.0.8.0-linux-x86_64.tar.gz
File: RedDatabase-OE-3.0.8.0-linux-x86_64.tar.gz
  • Size: 12.5 MiB
  • MD5: fdc2ad50fa28fd13e8ff96923533294e
  • SHA1: 4a4f5d7bbba60790087f0dcb17f2aa06b23ae6a9
Download
bin/windows/x86_64/RedDatabase-OE-3.0.8.0-windows-x86_64.exe
File: RedDatabase-OE-3.0.8.0-windows-x86_64.exe
  • Size: 31.5 MiB
  • MD5: 43977b5dcfd8b00773e8abd554eadd26
  • SHA1: 33e5195bc379237aa542457234b481ce398163a1
Download
bin/windows/x86_64/RedDatabase-OE-3.0.8.0-windows-x86_64.zip
File: RedDatabase-OE-3.0.8.0-windows-x86_64.zip
  • Size: 25.3 MiB
  • MD5: ec8e9438ff92a13b32ae047a976a91d3
  • SHA1: 4bb2abf15198d69a0622f18f8cac2bc68ea3b37a
Download
bin/windows/x86/RedDatabase-OE-3.0.8.0-windows-x86.exe
File: RedDatabase-OE-3.0.8.0-windows-x86.exe
  • Size: 23.3 MiB
  • MD5: 14a98f56044dd7311dd3610c1fc9ec3c
  • SHA1: f8da9a8d5c9fd02f86b12f7df9b942a425beb43a
Download
bin/windows/x86/RedDatabase-OE-3.0.8.0-windows-x86.zip
File: RedDatabase-OE-3.0.8.0-windows-x86.zip
  • Size: 16.8 MiB
  • MD5: af4b5b7aac0c6bd65b649be1db10cac8
  • SHA1: bf9ae1cf32fc511d03950b8093d06c8a13bfd00c
Download
dbg/linux/x86_64/RedDatabase-3.0.8.0-dbg-linux-x86_64.tar.gz
File: RedDatabase-3.0.8.0-dbg-linux-x86_64.tar.gz
  • Size: 120.0 MiB
  • MD5: 47eac0a1d5bbe3de5fc7606eacbf2033
  • SHA1: 0f02b33ce64bb353fae105be71f9599902ecd1d2
Download
dbg/RedDatabase-3.0.8.0-src-gen.tar.gz
File: RedDatabase-3.0.8.0-src-gen.tar.gz
  • Size: 881.0 KiB
  • MD5: 463e787b7b8025792e0b004997ea0176
  • SHA1: 0e253c131e1d1df63a678e683090301192d9f028
Download
dbg/windows/x86_64/RedDatabase-3.0.8.0-dbg-windows-x86_64.zip
File: RedDatabase-3.0.8.0-dbg-windows-x86_64.zip
  • Size: 46.0 MiB
  • MD5: 3fc494374bdb3cc6c82cd0df23063250
  • SHA1: 985bac69cbc9ff9a89aed19c809ae366edbf2812
Download
dbg/windows/x86/RedDatabase-3.0.8.0-dbg-windows-x86.zip
File: RedDatabase-3.0.8.0-dbg-windows-x86.zip
  • Size: 43.0 MiB
  • MD5: 7793ce9ce6b3942e409a848b0046e46b
  • SHA1: 8ea030678a1c320b1fe94bfad40fac985751e5e3
Download
src/RedDatabase-3.0.8.0-src.tar.gz
File: RedDatabase-3.0.8.0-src.tar.gz
  • Size: 50.5 MiB
  • MD5: 3fde65cb6ed77d6aa7fce20fea620448
  • SHA1: 9ffbf12990f9427b6de7196fc83847c2042b2a94
Download
src/RedDatabase-3.0.8.0-src.zip
File: RedDatabase-3.0.8.0-src.zip
  • Size: 55.2 MiB
  • MD5: f732d6d8450e954d63fde9d7a22c78dd
  • SHA1: dc599ebcdfe4fba08d98dd19b0e13443b210131b
Download