v5.0.4

New features

• Add new setting AllowUpdateOverwrite that defines how UPDATE operation should handle the case when a record was updated by trigger (#8957)
• Add API method Util::convert (#8761)

Improvements

• Add limit for max value of -PARALLEL switch value when restoring a database (#8928)
• Update Windows distributions with zlib version 1.3.2 (#8922)
• Context variables clear/re-initialization support (#8912)
• 'invalid request BLR' puts actual error (and procedure where it happened) at the end where it is truncated by ISC API (#8895)
• Ensure sequences are replicated even if changed in de-facto read-only transactions (#8858)
• Early diagnostics for the improperly re-initialized replica (#8767)
• Allow isc_tpb_read_consistency to imply read committed (#8746)
• Increase Android page size to 16KB (#8695)
• Get the modification time of a config file with a higher precision to fix cases when it's not reloaded after modification/replacement (#8553)

More details can be found in the CHANGELOG.

Release Notes | Language Reference | Binary Packages

Firebird 4.0.7

Improvements

• Add API method Util::convert (#8761)
• Update Windows distributions with zlib version 1.3.2 (#8922)
• Don't fire referential integrity triggers if primary or unique keys haven't changed (#8598)
• Get the modification time of a config file with a higher precision to fix cases when it's not reloaded after modification/replacement (#8553)

More details can be found in the CHANGELOG.

Release Notes | Language Reference | Binary Packages

Firebird 3.0.14

What's new

• Update Windows distributions with zlib version 1.3.2 (#8922)
• Get the modification time of a config file with a higher precision to fix cases when it's not reloaded after modification/replacement (#8553)
• 17 bugs fixed

Release Notes | Quick Start Guide | Binary Packages

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