Release Notes - Firebird Core - Version 2.1.5 - HTML format

Bug

  • [CORE-1782] - ISQL crashes when fetching data for a column having alias longer than 30 characters
  • [CORE-1992] - bad BLR -- invalid stream for union select
  • [CORE-2286] - Selecting from MON$CALL_STACK within a Trigger or SP sometimes return 0 rows.
  • [CORE-2358] - BAD INSTALLATION Whith Firebird-2.1.2.18116_0_Win32_RC1.exe
  • [CORE-2422] - Server doesn't switch between multiple entries configured in TempDirectories when some of them is out of free space
  • [CORE-3092] - ROW_COUNT is not cleared before the singleton INSERT statement
  • [CORE-3138] - Internal error or crash occurs when accessing any MON$ table after altering its structure
  • [CORE-3231] - OVERLAY() fails when used with text BLOBs containing multi-byte chars
  • [CORE-3233] - LIKE, STARTING and CONTAINING fail if second operand >= 32K
  • [CORE-3245] - SUBSTRING on long blobs truncates result to 32767 if third argument not present
  • [CORE-3296] - Error "context already in use" for the simple case function with a sub-select operand
  • [CORE-3320] - Some MERGE syntax can crash the server
  • [CORE-3335] - Wrong results (internal wrapping occured) for the multi-byte blob SUBSTRING function and its boundary arguments
  • [CORE-3351] - Windows client could put 10054 error messages into firebird.log at connection time
  • [CORE-3353] - Predicate (blob_field LIKE ?) describes the parameter as VARCHAR(30) rather than as BLOB
  • [CORE-3355] - Wrong comparsion of DATE and TIMESTAMP if index is used
  • [CORE-3374] - Server may crash or corrupt data if SELECT WITH LOCK is issued against records not in the latest format
  • [CORE-3388] - Does not build on fedore core
  • [CORE-3394] - Failed attempt to violate unique constraint could leave unneeded "lock conflict" error in status-vector
  • [CORE-3397] - Unresolved symbols in intl and trace libraries
  • [CORE-3409] - Segmentation Fault after upgrade 2.1.3 -> 2.1.4
  • [CORE-3418] - Database trigger created as INACTIVE is really active
  • [CORE-3440] - AV in engine if isc_que_events queued 0 events
  • [CORE-3447] - Collation is not installed with icu > 4.2
  • [CORE-3461] - DDL operations fail after backup/restore
  • [CORE-3464] - Dirty page could be written without releasing (or downgrading) page lock. It results in "lock denied" or "lock conversion denied" bugcheck
  • [CORE-3468] - Attempt to read after the end of file when nbackup state is stalled
  • [CORE-3479] - ASCII_VAL raises error instead of return 0 for empty strings
  • [CORE-3510] - gds_drop utility prints an error when trying to shutdown missing lock manager process
  • [CORE-3515] - Index corruption. Validation put "missing entries" message into firebird.log
  • [CORE-3517] - Server crash with built in function LPAD with string as second parameter
  • [CORE-3521] - Delta file contents is not flushed to disk
  • [CORE-3524] - Server crashes while compiling a stored procedure being in use
  • [CORE-3549] - Database corruption after end of session : page xxx is of wrong type expected 4 found 7
  • [CORE-3553] - Nested loop plan is chosen instead of the sort merge for joining independent streams using keys of different types
  • [CORE-3554] - Server crashes during prepare or throws incorrect parsing error if the remotely passed SQL query is empty
  • [CORE-3557] - AV in engine when preparing query against dropping table
  • [CORE-3569] - CHAR(32767) present in XSQLVAR with length 32765
  • [CORE-3579] - Can't drop table when computed field depends on later created another field
  • [CORE-3625] - MON$IO_STATS doesn't report page writes performed asynchronously (at the AST level)
  • [CORE-3658] - FBSVCMGR connects to server as OS user name rather than value of ISC_USER environment variable
  • [CORE-3677] - Stop utilities to export entrypoints
  • [CORE-3690] - Wrong warning message for ambiguous query
  • [CORE-3691] - Missing constraint name in foreign key error message in FB 2.1.4
  • [CORE-3697] - String truncation error when selecting from a VIEW with UNION inside
  • [CORE-3721] - Multiuser server startup (/etc/init.d) script picks up the ISC_ variables if set.
  • [CORE-3722] - IS NOT DISTINCT FROM NULL doesn't use index
  • [CORE-3724] - Server hangs when working with events
  • [CORE-3730] - isc_dsql_exec_immed2() loses input parameter value with RETURNING clause
  • [CORE-3733] - GBAK fails to fix system generators while restoring
  • [CORE-3736] - WITH LOCK clause is allowed for users with read-only rights on some table, thus blocking others from updating this table
  • [CORE-3761] - Conversion error when using a blob as an argument for the EXCEPTION statement
  • [CORE-3791] - Performance degrades when actively working with databases bigger than the available RAM amount
  • [CORE-3807] - Error "Invalid expression in the select list" can be unexpectedly raised if a string literal is used inside a GROUP BY clause in a multi-byte connection
  • [CORE-3834] - Usage of a NATURAL JOIN with a derived table crashes the server
  • [CORE-3841] - Corrupted database after inserting rows
  • [CORE-3844] - Validation not detects one specific case of index corruption

Improvement

  • [CORE-3433] - Improve GBAK restore performance (records insertion)
  • [CORE-3457] - Optimize the temporary space manager regarding small chunk allocations

Sub-task

  • [CORE-3631] - Duplicate records with NULLs checked incorrectly
  • [CORE-3758] - Backport into v2.1.5

Edit/Copy Release Notes

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