Releases: FirebirdSQL/firebird
Releases · FirebirdSQL/firebird
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