Bekende databases om grote hoeveelheden gegevens in op te slaan zijn natuurlijk Oracle met zijn 11g-database, IBM met de DB2-database en Microsoft met SQL Server. Een ander database management system is Firebird, dat als oorsprong de Interbase-database van Inprise heeft, tegenwoordig bekend als Borland Software, waarvan de geschiedenis op deze pagina na te lezen is. Deze relationele database kan op verschillende besturingssystemen geïnstalleerd worden, waaronder het Linux- en het Windows-platform, waardoor het breed kan worden ingezet. De ontwikkelaars hebben de eerste release candidate van versie 2.5.0 uitgebracht, voorzien van de volgende beknopte aankondiging en lijst met veranderingen ten opzicht van versie 2.5.0 bèta 2:
Firebird 2.5.0 Release Candidate 1 Ready to Test
The project team announces that kits of Firebird 2.5.0 release candidate 1 are now available for all the supported main-line platforms (Win32, Win 64, Linux i86 and x86-64 and MacOS-X/Darwin i86 and x86-64). Please test it with your loads and report back to firebird-devel. Note, this is the first of two RC releases.
What's new:
- Bugfix CORE-2742: Server may stop responding to a particular client attachment under some conditions
- Bugfix CORE-2739: ASSERT at parse.cpp line 22885
- Bugfix CORE-2731: Recursive EXECUTE STATEMENT works wrong
- Bugfix CORE-2730: Bus error when working with DB_KEY on RISC machines
- Bugfix CORE-2729: Current connection may be used by EXECUTE STATEMENT instead of creation of a new attachment
- Bugfix CORE-2722: Storage of a malformed blob is allowed when copying from a blob with NONE/OCTETS charset
- Bugfix CORE-2721: Issue with SIMILAR TO and UTF-8
- Bugfix CORE-2711: Embedded server cannot load ib_util.dll
- Bugfix CORE-2685: System triggers on view with check option are not removed
- Bugfix CORE-2660: COUNT(*) incorrectly returns 0 when a condition of an outer join doesn't match
- Bugfix CORE-2659: Sub-optimal (not indexed) query plan for outer joins involving complex views
- Bugfix CORE-2657: Ability to get any permissions (including SYSDBA) working with services
- Bugfix CORE-2656: "Error reading data from the connection" in firebird.log (on disconnect)
- Bugfix CORE-2651: Incorrect "string right truncation" error with NONE column and multi-byte connection charset
- Bugfix CORE-2648: NBackup's delta file ignores the "Forced Writes" database setting
- Bugfix CORE-2647: Race condition during detach database can lead to AV
- Bugfix CORE-2646: The engine process writes every page change to disk after changing the physical backup state
- Bugfix CORE-2642: ICU initialization for properly work in MT environment
- Bugfix CORE-2640: A regular deadlock may not be detected by the lock manager under some conditions,: thus resulting in a hang
- Bugfix CORE-2635: Unique index with a lot of NULL keys can be corrupted at level 1
- Bugfix CORE-2634: Performance regression when restoring database with big metadata
- Bugfix CORE-2633: SELECT WITH LOCK with no fields accessed clears the data
- Bugfix CORE-2632: "Invalid BLOB ID" error when working with the monitoring tables
- Bugfix CORE-2616: Error "page is of wrong type (expected 7, found 5)"
- Bugfix CORE-2615: Silent truncation when using UTF-8 parameters and UTF-8 client character set encoding
- Bugfix CORE-2612: Connection lost immediatelly after compiling procedure with RPAD system function
- Bugfix CORE-2608: Recent Windows versions stop responding when Firebird is working with large databases
- Bugfix CORE-2607: Introducer (_charset) problems with monitoring and persistent modules
- Bugfix CORE-2602: Attachments using NONE charset may fail reading from the monitoring tables
- Bugfix CORE-2601: Fine tuning of the installation directories switches do not work in configure
- Bugfix CORE-2600: Server deadlocks while running a few remote EXECUTE STATEMENTs concurrently
- Bugfix CORE-2599: Segmentation fault in the Y-valve when closing an attachment actively used by other threads
- Bugfix CORE-2598: fb_lock_print -c[onsistency] switch doesn't work on Windows
- Bugfix CORE-2591: High mutex wait ratio and degraded performance after some time of performing normally
- Bugfix CORE-2590: Segmentation fault in the page cache AST routine under high load
- Bugfix CORE-2586: Make all kernel object names belonging to the same namespace
- Bugfix CORE-2584: Wrong results for CASE used together with GROUP BY
- Bugfix CORE-2582: Infinity from UDF should be trapped by the engine
- Bugfix CORE-2581: Infinity should not escape from the engine
- Bugfix CORE-2579: Parameters and variables cannot be used as expressions: in EXECUTE PROCEDURE parameters without a colon prefix
- Bugfix CORE-2578: Select rdb$db_key from a view with more than one table joined results in the conversion error
- Bugfix CORE-2576: Server may crash parsing wrong or truncated BLR
- Bugfix CORE-2573: The server crashes when selecting from the MON$ tables in the ON DISCONNECT trigger
- Bugfix CORE-2572: Locks of type LCK_page_space are processed incorrectly (on big-endian machines)
- Bugfix CORE-2558: Engine crashes when some statement under an autonomous transaction: drops the transaction level savepoint
- Bugfix CORE-2514: An error about CreateFile is reported when there's not enough space on the temp drive
- Bugfix CORE-2478: MON$MEMORY_USAGE: incorrect database memory reported on Classic and SuperClassic
- Bugfix CORE-2477: MON$MEMORY_USAGE: sorting memory should be reported as owned by the statement
- Bugfix CORE-2422: Server doesn't switch between multiple entries configured in TempDirectories: when some of them is out of free space
- Bugfix CORE-2321: Query fails with message 'operating system directive write failed. Invalid argument.'
- Bugfix CORE-2315: Firebird float support does not conform to the original Interbase specification
- Bugfix CORE-2252: EXECUTE STATEMENT on EXTERNAL SOURCE does not check the status of the transaction
- Bugfix CORE-1991: UDF BLOB as parameter error
- Bugfix CORE-1787: Consistency check when subquery is ordered by an aggregate function from another context
- Bugfix CORE-915: ISQL extracts procedures body with double line break
- Bugfix CORE-97: GFIX -shut -force leaves lock on a database file thus preventing a subsequent restore
- Improvement CORE-2672: Reduce precedence writes for updates
- Improvement CORE-2644: Make lock table expandable on HPUX
- Improvement CORE-2638: Make words, non-reserved according to the SQL specification, non-reserved in our grammar
- Improvement CORE-2626: Startup scripts in /etc/init.d should take care about presence of: /var/run/firebird and /tmp/firebird directories
- Improvement CORE-2619: Make memory and other statistics to work with 64-bit values
- Improvement CORE-2609: Support for Windows NT4/98/ME
- Improvement CORE-2588: Allow to run engine instances in different Windows sessions: without conflics on the trace shared memory
- Improvement CORE-2587: User friendly diagnostics when the engine can't create shared memory: already created by the another engine process in another Windows session
- Improvement CORE-2580: Allow usage of subselects as PSQL expressions
- Improvement CORE-2439: Add FIX_FSS_DATA and FIX_FSS_METADATA restore options to the Services API
- Improvement CORE-1687: Allow bigger cache sizes than 2 GB (16K * 128 K) for 64-bit builds
- Improvement CORE-1643: Use DatabaseAccess configuration parameter for default database location
- Improvement CORE-1038: Remote shadows on NT-based systems
- New feature CORE-2655: Add support for Linux/sh4 (Renesas SH) platform
- New feature CORE-2636: Add support for the GB 18030 character set (Chinese national standard)
- New feature CORE-2625: Add support for Linux/s390 (32-bit) platform
- New feature CORE-2559: Add support for Linux/s390x (64-bit) platform