Release Notes - Firebird Core - Version 2.5.3 - HTML format

Bug

• [CORE-1295] - Bad optimization of queries with DB_KEY
• [CORE-1604] - Error at database creation by user with non-ascii name
• [CORE-3243] - CURRENT_USER and MON$USER raise an error for trusted authentication and non-ASCII OS user name
• [CORE-3360] - update ... returning ... raises -551 (no perm to update) for a column present only in the returning clause
• [CORE-3817] - Forced database shutdown does not work if non-zero delay was specified
• [CORE-3895] - High memory usage when PSQL code SELECT's from stored procedure which modified some data
• [CORE-3902] - Derived fields may not be optimized via an index
• [CORE-3908] - Engine leaks memory and crashes when lot of autonomous transactions have been started and finished
• [CORE-3916] - gfix & "Index x is corrupt (missing entries) in table ..." all indexes on large tables
• [CORE-3924] - Bugcheck 291 (cannot find record back version) if GTT is modified concurrently using at least one read-committed read-only transaction
• [CORE-3932] - can create but cant delete user with username containing double quotes with gsec
• [CORE-3935] - Could not connect to production via TCP after delete from mon$attachments issued on *different* database on the same machine
• [CORE-3940] - I/O error during "GetFileSize" operation for file XXXX
• [CORE-3944] - LI-V2.5.2.26448 (SuperClassic) crashes when running script that delete attachments and move database to offline
• [CORE-3946] - UNICODE collations does not work with ICU 49
• [CORE-3969] - Memory leak when doing a lot of iterations FBSVCMGR with action_trace_start, _list and _stop
• [CORE-3970] - Trace uses imprecise timer in POSIX
• [CORE-3977] - DELETE FROM MON$STATEMENTS does not interrupt a longish fetch
• [CORE-3978] - Invalid transaction counters may be reported in firebird.log during the sweep
• [CORE-3979] - Server crashes while unwinding changes in an autonomous transaction
• [CORE-3981] - Sub-optimal predicate checking while selecting from a view
• [CORE-3988] - Engine crashed when trace or audit is active
• [CORE-3989] - Bad performance / slow response when many concurrent sorts are executed
• [CORE-3993] - Server terminates or crashes while shutting down a database with in-progress attachments
• [CORE-3996] - Firebird crashes when trying to create database in restricted path
• [CORE-3998] - Parametrized execute statement fails
• [CORE-4002] - Error message "index unexpectedly deleted" in database trigger on commit transaction
• [CORE-4004] - Sometimes long-running operations cannot be interrupted by asynchronous shutdown / cancellation requests
• [CORE-4010] - Fetch cannot be subsequently interrupted via DELETE FROM MON$STATEMENTS
• [CORE-4011] - start stop status undetected for superclassic and superserver under RH and Mageia
• [CORE-4031] - make install wrong under Debian Ubuntu 64
• [CORE-4036] - Bugcheck or database corruption when attempting to store long incompressible data into a table
• [CORE-4038] - Broken optimization for the stored dbkeys
• [CORE-4045] - Server crashes during database shutdown
• [CORE-4051] - Memory leak when sorting records larger than 32 KB
• [CORE-4054] - role not passed on external execute stmt
• [CORE-4055] - Dialect is not set in internal connections to security database
• [CORE-4058] - Remote Stack Buffer Overflow in Firebird SQL Server
• [CORE-4083] - Full outer join in derived table with coalesce (iif)
• [CORE-4093] - Server crashes while converting an overscaled numeric to a string
• [CORE-4094] - Wrong parameters order in trace output
• [CORE-4100] - Automatic sweep could be run when there is no need for it

Improvement

• [CORE-3994] - Improve the limbo transactions scan at the end of the sweep
• [CORE-3995] - Slight problem with GBAK parameter checking

New Feature

• [CORE-4047] - Increase number of input parameters for External Functions (UDFs) to 15

Sub-task

• [CORE-3990] - Fix broken EDIT in isql

The text area below allows the project release notes to be edited and copied to another document.