Release Notes - Firebird Core - Version 2.1.4 - HTML format

Bug

• [CORE-195] - Bugcheck 291
• [CORE-1089] - Wrong ordering with views, distinct, left join and order by
• [CORE-1346] - lpad and rpad with two columns not working
• [CORE-2084] - Services API security problem
• [CORE-2122] - Translation of large text BLOB between UNICODE_FSS (UTF8) and other charsets
• [CORE-2215] - GROUP BY concatenation with empty string
• [CORE-2289] - Wrong (primary) constraint name is reported for the foreign key violation during FK creation
• [CORE-2301] - Use Select list(xxx, ';') from table into :xxx cause a memory leak
• [CORE-2507] - Intermittent CreateFile failure
• [CORE-2519] - GSTAT output is incorrect for tables with more than 2 billion records
• [CORE-2539] - delta file (backup mode)
• [CORE-2572] - Locks of type LCK_page_space processed incorrectly
• [CORE-2578] - select rdb$db_key from a view with a more than 1 table joined, results in conversion error
• [CORE-2591] - High mutex wait ratio and degraded performance after some time of performing normally
• [CORE-2616] - page 1530262 is of wrong type (expected 7, found 5)
• [CORE-2632] - Invalid BLOB ID when working with monitoring tables
• [CORE-2634] - Performance regression when restoring database with big metadata
• [CORE-2635] - Unique index with a lot of NULL keys can be corrupted at level 1
• [CORE-2640] - A regular deadlock may not be detected by the lock manager under some conditions, thus resulting in a hang
• [CORE-2648] - Nbackup's delta file ignored Forced Writes database setting
• [CORE-2675] - Small memory leak per every blob transliteration
• [CORE-2679] - Do not correct exit applications with embedded server
• [CORE-2684] - Error page NNN is of wrong type (expected 7, found N)
• [CORE-2698] - Infinite wait in LocksCache::get
• [CORE-2720] - Wrong evaluation result with divide and unary plus\minus operations
• [CORE-2741] - Naive metadata extraction code in isql is defeated by "check" keyword typed in mixed case
• [CORE-2783] - AV using recursive query as subquery in SELECT list and ORDER'ing by them
• [CORE-2785] - BLOB transliteration problem in a specific case
• [CORE-2793] - Binary representation of the backup file is inconsistent among subsequent backup/restore cycles
• [CORE-2814] - Bus error while sorting/merging on SPARC
• [CORE-2815] - PIP page could be marked after it was really changed
• [CORE-2820] - Small memory leak in query with PLAN ORDER
• [CORE-2822] - Error "no current row for fetch operation" when subquery includes a non-trivial derived table
• [CORE-2826] - Join condition fails for UTF-8 databases.
• [CORE-2831] - isql shouldn't display db and user name when extracting a script
• [CORE-2833] - Changing data that affects an expression index that contains references to null date fields fails
• [CORE-2845] - Solaris 10 no longer requires SFIO
• [CORE-2846] - Cannot connect to the database if GFIX -shut <mode> -attach <timeout> fails after the specified timeout (because of connections being still active)
• [CORE-2856] - Non-NULL key in unique index could be not found when key is removed
• [CORE-2858] - Possible memory trashing when raising some exceptions to signal failed security checks
• [CORE-2865] - SegFault when superserver is restarted
• [CORE-2871] - Outer ORDER BY clause has no effect
• [CORE-2879] - Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
• [CORE-2888] - A memory corruption cause incorrect query evaluation and may crash the server
• [CORE-2900] - "AV - The code attempted to access a virtual address without privilege to do so" using aggregate distinct
• [CORE-2908] - Engine could crash or raise not expected errors working with ODS 8.x database
• [CORE-2914] - Server crashes while restoring a database having an expression index referencing a non-existent UDF
• [CORE-2916] - Broken error handling in the case of a conversion error happened during index creation
• [CORE-2919] - Installation script ignores non-standard ports
• [CORE-2928] - Buffer overflow in gsec
• [CORE-2936] - Wrong page type (expected 7 found N) error
• [CORE-2943] - parsing error recursive query with two recursive parts
• [CORE-2956] - Problems with requests of procedure's parameters
• [CORE-2969] - rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them
• [CORE-2977] - FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
• [CORE-2993] - Fatal lock manager error "Invalid lock id (NNN)" while working with monitoring tables on a highly loaded system
• [CORE-2995] - Same error in status vector reported twice
• [CORE-2999] - Message "SCH_validate -- not entered" is logged in firebird.log when CS connection where events was used is finished
• [CORE-3001] - Install fails to create user & group "firebird"
• [CORE-3011] - Server hangs or crashes while monitoring connections repeatedly attaching and detaching
• [CORE-3015] - Various "Cannot initialize the shared memory region" errors
• [CORE-3016] - On disconnect it is possible to see "Fatal lock manager error: invalid lock id (0), errno: 0" in firebird.log
• [CORE-3019] - Startup failure of SS and SC on linux gentoo
• [CORE-3022] - gpre C++ compiler warnings with GCC 4.4.1
• [CORE-3034] - Bugcheсk 300 (can't find shared latch)
• [CORE-3041] - Engine could hang when working with read-only database
• [CORE-3050] - Race condition in LocksCache::get() could lead to AV in the engine
• [CORE-3064] - Using both the procedure name and alias inside an explicit plan crashes the server
• [CORE-3067] - Objects not unmapped when shared memory is closed
• [CORE-3079] - Strong slowing down inserts with EVENT-s in a single transaction.
• [CORE-3091] - Built-in function POWER(X, Y) does not work when the X argument is negative and the Y value is scaled numeric but integral
• [CORE-3103] - Select statement with more non indexed reads in version 2.5RC3 as in version 2.1.3

Improvement

• [CORE-1658] - Avoid memory consumption of <page size> bytes per every temporary blob
• [CORE-2597] - Backport RPAD and LPAD return types from FB 2.5
• [CORE-2769] - Make XNET_CONNECT_TIMEOUT in xnet.h user configurable

New Feature

• [CORE-2655] - port to Renesas SH CPU (sh4)

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