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

Firebird 5.0.0 RC1

New features and improvements

• Use ParallelWorkers setting from firebird.conf as default for all parallelised operations (#7682)
• Make Android port (client / embedded) work inside apps (#7469)
• Add support for QUARTER to EXTRACT, FIRST_DAY and LAST_DAY (#5959)
• Better processing and optimization if IN <list> predicates (#7707)
• Make trace config parser resolve symlinks in database file path in trace configuration (#7692)
• Getting the current DECFLOAT ROUND/TRAPS settings (#7642)
• Allow nested parenthesized joined table (#7576)
• Optimize creation of expression and partial indices (#7559)
• Add ability to query current value of parallel workers for an attachment (#7536)
• Add COMPILE trace events for procedures/functions/triggers (#7466)
• Add REPLICA MODE to the output of the isql SHOW DATABASE command (#7425)
• Surface internal optimization modes (all rows vs first rows) at the SQL and configuration levels (#7405)
• Make ability to add comment to mapping (COMMENT ON MAPPING ... IS ...) (#7046)

More details can be found in the CHANGELOG.

Release Notes | Binary Packages

Firebird 4.0.3

Improvements

• RDB$GET/SET_CONTEXT(): quoting the missing namespace/variable makes output more readable (#7539)
• Avoid non necessary index reads (#7494)
• Add switch to control in guardian timeout before killing Firebird server process (#7468)
• Update zlib to version 1.2.13 (released 2022-10-13) (#7437)
• Add REPLICA MODE to the output of the isql SHOW DATABASE command (#7425)
• Improve reliability of plugin manager (#7418)
• Allow FB-known macros in replication.conf (#7294)
• Remove TcpLoopbackFastPath and use of SIO_LOOPBACK_FAST_PATH (#7259)
• Nbackup RDB$BACKUP_HISTORY cleanup (#7186)

More details can be found in the CHANGELOG.

Release Notes | Language Reference | Binary Packages

Firebird 3.0.11

What's new

• RDB$GET/SET_CONTEXT(): quoting the missing namespace/variable makes output more readable (#7539)
• Avoid non necessary index reads (#7494)
• Add switch to control in guardian timeout before killing Firebird server process (#7468)
• Update zlib to version 1.2.13 (released 2022-10-13) (#7437)
• Improve reliability of plugin manager (#7418)
• Remove TcpLoopbackFastPath and use of SIO_LOOPBACK_FAST_PATH (#7259)
• 41 bugs fixed

Release Notes | Quick Start Guide | Binary Packages