Release Notes - Firebird Core - Version 2.0.6 - HTML format

Bug

• [CORE-195] - Bugcheck 291
• [CORE-1089] - Wrong ordering with views, distinct, left join and order by
• [CORE-1923] - "instsvc remove" returns 1 when succefully executed
• [CORE-1961] - Bugcheck 210 (page in use during flush) is thrown during database validation
• [CORE-2157] - fbclient does not have libpthread dependency
• [CORE-2173] - Server crash after ubnormal disconnect with open ExecuteStatement
• [CORE-2245] - Error on restoring db with long exception from backup
• [CORE-2247] - Message and descriptor buffers are not aligned properly
• [CORE-2270] - isql consumes all memory and crashes when run in zlogin console
• [CORE-2271] - gfix reports db ownership error way too late
• [CORE-2272] - Server starts returning garbage when killing events connection attempt
• [CORE-2281] - *round UDFs broken for negative numbers
• [CORE-2282] - *truncate UDFs broken for numbers below -1
• [CORE-2291] - BUGCHECK 284
• [CORE-2306] - fbserver terminated abnormally when thread start failed
• [CORE-2326] - Access Violation when committing new view while trigger on rdb$relations in place
• [CORE-2354] - "fb_lock_print -ia" output is not flushed to a file between iterations
• [CORE-2355] - Incorrect handling of LOWER/UPPER when result string shrinks in terms of byte length
• [CORE-2368] - AV after isc_cancel_events if event was not found or already delivered
• [CORE-2395] - Lost the supplementary characters(UTF-8 4byte) at immediate API handling.
• [CORE-2411] - Optimizer chooses slower PLAN in v2.0.5/v2.1.2 than in v2.0.4/v2.1.1
• [CORE-2415] - Firebird crashes when out of /tmp space.
• [CORE-2437] - Buffer overflow on client when delivering events.
• [CORE-2444] - When more than one attachment register interests in events simultaneously and free space in events table is exhausted engine could hung
• [CORE-2449] - Unexpected "lock conflict" error can be thrown instead of other (expected) exception
• [CORE-2507] - Intermittent CreateFile failure
• [CORE-2563] - Possible DoS attack using the malformed packet sent into the connection port
• [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-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-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-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-2831] - isql shouldn't display db and user name when extracting a script
• [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-2871] - Outer ORDER BY clause has no effect
• [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-3041] - Engine could hang when working with read-only database

Improvement

• [CORE-2200] - Extremely slow executing a cross join of 3 tables in Firebird 2.X
• [CORE-2316] - Throttling Nbackup on large databases
• [CORE-2769] - Make XNET_CONNECT_TIMEOUT in xnet.h user configurable

Sub-task

• [CORE-2631] - Backport fix for bug CORE-2291 into v2.0.6

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