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-2165] - Unnecessary 1 index read may occur when using strict inequality condition
  • [CORE-2648] - Nbackup's delta file ignored Forced Writes database setting
  • [CORE-2912] - Exception when upper casing string with lowercase y trema (code 0xFF in ISO8859_1 )
  • [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-3874] - Computed column appears in non-existant rows of left join
  • [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-3921] - "record disappeared (186), file: vio.cpp line: 408" + CPU 100% (when bugcheckabort=1 and sweep starts at gap ~21000)
  • [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-3942] - Restore from gbak backup using service doesn't report an error
  • [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-4005] - wrong error message with recursive CTE
  • [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
  • [CORE-4101] - Invalid "I/O error during "write" operation" entries in firebird.log but no database error exists
  • [CORE-4102] - Bad optimization of OR predicates applied to unions
  • [CORE-4113] - EXECUTE BLOCK prepare fails
  • [CORE-4117] - COMPUTED BY field is evaluated as NULL if used as an exception parameter directly
  • [CORE-4118] - Expression index may be not used for derived fields or view fields
  • [CORE-4121] - Segfault when engine is shutting down inside blob get/put function invoked from UDF
  • [CORE-4123] - Firebird crash when executing an stored procedure called by a trigger that converts string to upper
  • [CORE-4125] - Using COLLATE UNICODE_CI_AI in WHERE clause (not indexed) is extremely slow
  • [CORE-4127] - Server crashes instead of reporting the error "key size exceeds implementation restriction"
  • [CORE-4134] - Race condition when auto-sweep is started
  • [CORE-4135] - In SS sweep blocks establishment of concurrent attachments
  • [CORE-4136] - Sharp-S character treated incorrectly in UNICODE_CI_AI collation
  • [CORE-4137] - Wrong metadata output script generate by isql / CHARACTER SETISO8859_1 sintaxe error.
  • [CORE-4139] - Error "invalid stream" can be raised in some cases while matching a computed index
  • [CORE-4143] - Leak memory in fbembed.dll
  • [CORE-4144] - Error "context already in use (BLR error)" when preparing a query with UNION
  • [CORE-4145] - Memory leak when preparing Execute Block which uses domains
  • [CORE-4198] - Incorrect "token unknown" error when the SQL string ends with a hex number literal
  • [CORE-4204] - Error when compiling the procedure containing the statement if (x = (select ...))
  • [CORE-4210] - Preserve comments for output parameters after altering procedures
  • [CORE-4211] - Embedded engine hangs for 5 seconds when closing, errors about timeout in shutdown process and invalid mutex placed in firebird.log.
  • [CORE-4212] - Dropping FK on GTT crashes server
  • [CORE-4214] - GTT should not reference permanent relation
  • [CORE-4216] - Memory leak with TRIGGER ON TRANSACTION COMMIT
  • [CORE-4224] - Database replace through services API fails
  • [CORE-4225] - Server crashes when attempting to trace activity on database having a db-level trigger
  • [CORE-4233] - In PSQL modules with declared cursors engine could assign value to the wrong variable
  • [CORE-4244] - Problem with creation procedure which contain adding text in DOS864 charset
  • [CORE-4247] - Delete "where current of" cursor fails for tables with newly added fields
  • [CORE-4250] - AV in guardian at process shutdown
  • [CORE-4251] - Guardian service could write garbage after the end of message in the Event Log
  • [CORE-4267] - Server crashes while sweeping the database
  • [CORE-4283] - Resource temporarily unavailable errors while simultaneously registering events
  • [CORE-4297] - Gfix crashed when description of limbo transaction have size large than 1KB
  • [CORE-4298] - fbsvcmgr doesn't recognise sts_record_versions and other sts switches
  • [CORE-4299] - "Inappropriate self-reference of column" when using "with check option" with extract(...)
  • [CORE-4300] - Server terminates abnormally when iscDatabaseInfo() is called with buffer size = 0
  • [CORE-4302] - Lookup (or scan) in descending index could be very inefficient for some keys
  • [CORE-4319] - Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
  • [CORE-4327] - Error in QLI when copying NULL blobs between databases
  • [CORE-4353] - Sorting records are larger than really necessary

Improvement

  • [CORE-3704] - Add new context variables to the SYSTEM namespace
  • [CORE-3881] - Extend the error reported for index/constraint violations to include the problematic key value
  • [CORE-3994] - Improve the limbo transactions scan at the end of the sweep
  • [CORE-3995] - Slight problem with GBAK parameter checking
  • [CORE-4215] - Execution of SET STATISTICS INDEX statement could block or slow execution of concurrent attachments
  • [CORE-4252] - Add table name to text of validation contraint error message, to help identify error context
  • [CORE-4386] - Report more details for "object in use" errors

New Feature

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

Sub-task


Edit/Copy Release Notes

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