Releases: FirebirdSQL/firebird
Releases · FirebirdSQL/firebird
Firebird 3.0.4
What's new
- Add context variables with compression and encryption status of current connection
- Enhance dynamic libraries loading related error messages
- Provide name of UDF function for "arithmetic exception, numeric overflow, or string truncation"
- Support auth_plugin_list DPB/SPB item from application to client
- Forward-compatible expressions LOCALTIME and LOCALTIMESTAMP
- Remove the restriction on create/delete, enable/disable the user-defined indexes in system tables
- 66 bugs fixed
Firebird 3.0.3
What's new
- Make faster engine response on cancel\shutdown signals when scanning long list of pointer pages
- Access to the name of DB encryption key
- Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible
- When database validation fixes "orphan page" errors it now adjusts "lowest free page" marker (pip_min) on corresponding PIP, if necessary
- Consider equivalence classes for index navigation
- Allow unused Common Table Expressions
- Make flush of big number of dirty pages faster
- Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
- GSTAT output now includes datetime of analysis
- Improve physical backup merge stage performance, especially with huge page cache
- Provide info about database (or alias) which was in use during "Error during sweep: connection shutdown"
- Improve ALTER DOMAIN performance with many dependencies
- Restore of pre ODS 11.1 database can leave RDB$RELATION_TYPE null
- Database backup using Nbackup is now faster when directed to NAS over SMB protocol
- Estimate the actual record compression ratio in the optimizer
- Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call
- 68 bugs fixed
Firebird 2.5.8
What's new
- Populate RDB$RELATION_TYPE while restoring pre ODS 11.1 databases
- GSTAT output now includes datetime of analysis
- Improve concurrency of new connections being established
- Allow unused Common Table Expressions
- 19 bugs fixed
Firebird 4.0 Alpha 1
New features
- SQL SECURITY feature (CORE-5568)
- High-precision floating point datatype DECFLOAT (CORE-5525)
- Timeouts for running SQL statements and idle connections (CORE-5488)
- DEFAULT context value in INSERT, UPDATE, MERGE and UPDATE OR INSERT statements (CORE-5463)
- GENERATED ALWAYS identity columns and OVERRIDE clause (CORE-5449)
- Named windows (CORE-5346)
- Particular DBA privileges can be transferred to regular users (CORE-5343)
- Frames for window functions (CORE-3647)
- New built-in function to check whether some role is implicitly active (CORE-2762)
- Ability to grant role to another role (CORE-1815)
- More ANSI SQL:2003 window functions: PERCENK_RANK, CUME_DIST, NTILE (CORE-1688)
- Implicitly active roles (CORE-751)
Firebird 3.0.2
What's new
- Provide ability to filter out info and warnings from trace log
- Enhance control upon ability to share database crypt key between attachments in SS
- Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
- Read-only transactions in SuperServer could avoid immediate write of Header and TIP pages after change
- Make database name available to crypt plugin
- Enable nested keys in plugin configuration
- Build the Linux code with --enable-binreloc and create an option in the installer to install in different locations than /opt/firebird
- Trace: provide filter to INCLUDE / EXCLUDE errors by their mnemonical names
- Support BETWEEN predicate for select expressions
- Add support for Windows 8/2012 fast/low-latency "TCP Loopback Fast Path" functionality
- Port for Linux/m68k
- Android port (arm32)
- libfbclient.so for Android (x86/x86-64/arm64)
- 42 bugs fixed
Firebird 2.5.7
What's new
- Provide ability to filter out info and warnings from trace log
- Add support for Windows 8/2012 fast/low-latency "TCP Loopback Fast Path" functionality
- 15 bugs fixed
Firebird 3.0.1
What's new
- Allowed implicit conversion between boolean and string
- Return nonzero result code when restore fails on activating and creating deferred user index
- Added a switch to build linux binaries with built-in libtommath
- Provided location context (line/column numbers) for runtime errors raised inside EXECUTE BLOCK
- Allowed to enforce IPv4 or IPv6 in URL-like connection strings
- Enabled nested keys in plugin configuration
- Allowed statement 'CREATE OR ALTER user sysdba password ...' to initialize empty security3.fdb as 'CREATE USER ...'
- 58 bugs fixed
Firebird 2.5.6
What's new
- Return nonzero result code when restore fails on activating and creating deferred user index
- Provide location context (line/column numbers) for runtime errors raised inside EXECUTE BLOCK
- 32 bugs fixed
Firebird 3.0.0
Key features
- Revised architecture, including new authentication and configuration subsystems
- Scalable multi-threaded engine with the shared page cache
- New ODS (version 12) with new system and monitoring tables
- External (Java, C++, etc) stored procedures/triggers/functions
- Security enhancements
- Various SQL extensions