Firebird 5.0.3

Improvements

• AV when ON CONNECT triggers use EXECUTE STATEMENT ON EXTERNAL (#8649)
• Don't fire referential integrity triggers if primary or unique keys haven't changed (#8598)
• Avoid internal exception in fbclient during first isc_attach_database (#8523)
• Avoid internal exception in fbclient during isc_detach_database (#8522)
• Makes MON$COMPILED_STATEMENTS and MON$STATEMENTS share blobs with text and plan content of the same statement (#8513)
• Avoid index scan for lower/upper bounds containing NULL keys (#8447)
• Improve code of class BePlusTree (#8433)
• Add pointers tree to TempSpace class (#8421)
• Send small blobs inline (#8318)
• Avoid index lookup for a NULL key if the condition is known to always be FALSE in this case (#8278)
• Data pages of newly gbak restored databases should marked as "swept" (#6413)

More details can be found in the CHANGELOG.

Release Notes | Language Reference | Binary Packages

Firebird 4.0.6

Improvements

• Don't fire referential integrity triggers if primary or unique keys haven't changed (#8598)
• Improve code of class BePlusTree (#8433)
• Report unique usernames for isc_info_user_names (#8353)
• Win_sspi plugin uses NTLM (#8256)
• Cardinality estimation should use primary record versions only (#8161)

More details can be found in the CHANGELOG.

Release Notes | Language Reference | Binary Packages

Firebird 3.0.13

What's new

• 15 bugs fixed

Release Notes | Quick Start Guide | Binary Packages

Firebird 5.0.2

Improvements

• Add AUTO RELEASE TEMP BLOBID transaction option (#8323)
• Make trace use HEX representation for parameter values ​​of types [VAR]CHAR CHARACTER SET OCTETS and [VAR]BINARY(#8356)
• Report unique usernames for isc_info_user_names (#8353)
• Collect network statistics and make it available for the user applications (#8310)
• Wire protocol improvement: prefetch blob info and some data when open blob (#8307)
• NULLs should be skipped during index navigation when there's no lower bound and matched conditions are known to ignore NULLs (#8291)
• Reorganize public headers (#8273)
• Win_SSPI plug-in uses NTLM (#8256)
• Add generated files for OO API for C language to distribution (#8197)
• Cardinality estimation should use primary record versions only (#8161)
• Database restore must make every effort on activating deferred indexes (#7269)

More details can be found in the CHANGELOG.

Release Notes | Language Reference | Binary Packages

Firebird 4.0.5

Improvements

• Ensure the standalone CS listener on Linux uses the SO_REUSEADDR socket option (#8181)
• Added shutdown handler for Classic Server (#8165)
• More efficient evaluation of expressions like RDB$DB_KEY <= ? after mass delete (#8104)
• Make protocol schemes case-insensitive (#8066)
• Improve conflict resolution on replica when table have both primary and unique keys (#8042)
• Better cardinality estimation when empty data pages exist (#8030)
• Remove gfix -cache option (#8010)
• Update Windows distributions with zlib version 1.3.1 (#7978)
• Make TempCacheLimit setting to be per-database (not per-attachment) for SuperClassic (#7928)
• Improve performance with time zones (#7854)

More details can be found in the CHANGELOG.

Release Notes | Language Reference | Binary Packages

Firebird 3.0.12

What's new

• Ensure the standalone CS listener on Linux uses the SO_REUSEADDR socket option (#8181)
• Better cardinality estimation when empty data pages exist (#8030)
• Update Windows distributions with zlib version 1.3.1 (#7978)
• 27 bugs fixed

Release Notes | Quick Start Guide | Binary Packages

Firebird 5.0.1

Improvements

• Ensure the standalone CS listener on Linux uses the SO_REUSEADDR socket option (#8181)
• Added shutdown handler for Classic Server (#8165)
• More efficient evaluation of expressions like RDB$DB_KEY <= ? after mass delete (#8104)
• Make protocol schemes case-insensitive (#8066)
• Unnest IN/ANY/EXISTS subqueries and optimize them using semi-join algorithm (#8061)
• Improve conflict resolution on replica when table have both primary and unique keys (#8042)
• Better cardinality estimation when empty data pages exist (#8030)
• Remove gfix -cache option (#8010)
• Update Windows distributions with zlib version 1.3.1 (#7978)
• Make TempCacheLimit setting to be per-database (not per-attachment) for SuperClassic (#7928)

More details can be found in the CHANGELOG.

Release Notes | Language Reference | Binary Packages

Firebird 5.0.0

Firebird 5.0 introduces many improvements without any changes in architecture or operation, the
most important are:

• Parallel (multi-threaded) operation for backup/restore, sweep and index creation
• Partial indices
• SKIP LOCKED clause for SELECT WITH LOCK, UPDATE and DELETE statements
• Inline minor ODS upgrade
• Compiled statement cache
• PSQL and SQL profiler
• Support for WHEN NOT MATCHED BY SOURCE for MERGE statement
• Support multiple rows for DML RETURNING
• New built-in functions and packages
• Denser record-level compression
• Network support for scrollable cursors

The final release does not include any user-visible changes compared to the Release Candidate 2.

All the changes across the Beta and RC stages can be found in the CHANGELOG.

Release Notes | Binary Packages

Firebird 5.0.0 RC2

New features and improvements

• Allow to configure Firebird in POSIX using relative directories with options --with-fb* (#7918)
• Add backward compatibility option that disables joins transformation (#7910)
• Performance issue with time zones (#7854)
• Difficulty returning the product version with the legacy connection (#7819)
• Extend RDB$GET_CONTEXT('SYSTEM', '***') with other info from MON$ATTACHMENTS (#7818)
• Don't update database-level statistics on every page cache operation (#7814)
• Improve SKIP LOCKED implementation (#7810)
• Update Windows distribution with new zlib version 1.3 (released 2023-08-18) (#7755)

More details can be found in the CHANGELOG.

Release Notes | Binary Packages

Firebird 4.0.4

Improvements

• RDB$GET/SET_CONTEXT(): quoting the missing namespace/variable makes output more readable (#7539)
• Update Windows distribution with new zlib version 1.3 (released 2023-08-18) (#7755 )

More details can be found in the CHANGELOG.

Release Notes | Language Reference | Binary Packages