Release Notes - Firebird Core - Version 2.5 RC3 - HTML format

Bug

• [CORE-195] - Bugcheck 291
• [CORE-1089] - Wrong ordering with views, distinct, left join and order by
• [CORE-2628] - FB 2.5-beta2-win32 denied FreeAdhocUDF library functions.
• [CORE-2750] - Physical backup cannot restart operations after the explicit difference file has been dropped
• [CORE-2756] - substring from timestamp - unexpected result
• [CORE-2825] - some patches for building on Debian/kFreeBSD and FreeBSD
• [CORE-2826] - Join condition fails for UTF-8 databases.
• [CORE-2833] - Changing data that affects an expression index that contains references to null date fields fails
• [CORE-2844] - Unresolved symbol references when linking fbsvcmgr and fbtracemgr
• [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-2851] - Problem with fb_cancel_operation
• [CORE-2852] - Server crash when executing syntactically wrong SQL statement with an active trace session
• [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-2859] - Security database remains locked after replacing database
• [CORE-2861] - Cannot remove user with dot in login
• [CORE-2862] - configure --with-fbudf breaks build on CentOS
• [CORE-2864] - Listener process of Classic Server leak handles
• [CORE-2867] - SuperClassic leaks semaphores on disconnect
• [CORE-2871] - Outer ORDER BY clause has no effect
• [CORE-2875] - String right truncation error when char column longer than 4096 bytes compared with string constant
• [CORE-2876] - Wrong backup mode when using "alter database add difference file"
• [CORE-2879] - Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
• [CORE-2886] - Query with "NOT IN <subselect from view>" fails
• [CORE-2888] - A memory corruption cause incorrect query evaluation and may crash the server
• [CORE-2893] - Expression in a subquery may be treated as invariant and produce incorrect results
• [CORE-2896] - Embedded connections done by root (like gbak, gsec, gfix) hang in linux
• [CORE-2898] - CHAR_TO_UUID and UUID_TO_CHAR works different in big/little endian architectures
• [CORE-2900] - "AV - The code attempted to access a virtual address without privilege to do so" using aggregate distinct
• [CORE-2907] - Exception handling with EXECUTE STATEMENT
• [CORE-2908] - Engine could crash or raise not expected errors working with ODS 8.x database
• [CORE-2910] - PK index is not used for derived tables
• [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-2917] - Sever Hangs on I/O error during "open" operation for file "/tmp/firebird/fb_trace_ksVDoc"
• [CORE-2919] - Installation script ignores non-standard ports
• [CORE-2920] - Incorrect execution of volatile SQL statements inside EXECUTE STATEMENT
• [CORE-2923] - Problem with dependencies between a procedure and a view using that procedure
• [CORE-2926] - "make install" fails on linux
• [CORE-2928] - Buffer overflow in gsec
• [CORE-2929] - "Invalid ESCAPE sequence" when connecting to the database
• [CORE-2930] - DROP VIEW drops output parameters of used stored procedures
• [CORE-2933] - Very slow execution of a script that creates a lot of metadata
• [CORE-2934] - Memory leak in FB2.5 trace plugin
• [CORE-2936] - Wrong page type (expected 7 found N) error
• [CORE-2940] - Trace output could contain garbage data left from filtered out statements
• [CORE-2942] - Huge (>10Gb) memory consumption by some fb_inet_server processes
• [CORE-2943] - parsing error recursive query with two recursive parts
• [CORE-2948] - Segfault when server is exiting
• [CORE-2956] - Problems with requests of procedure's parameters
• [CORE-2965] - Incorrect ROW_COUNT value after SINGULAR condition
• [CORE-2966] - Wrong results or unexpected errors while sorting a large data set
• [CORE-2971] - Invalid UPDATE OR INSERT usage may lead to successive "request depth exceeded. (Recursive definition?)" error
• [CORE-2977] - FB 2.1 incorrectly works with indexed fields of type DATE in OLD ODS (9.1)
• [CORE-2981] - Error in Trace plugin (use local symbols in query)
• [CORE-2984] - gbak -v srv:db stdout creates a broken backup
• [CORE-2985] - The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
• [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-3000] - Error on delete user "ADMIN"
• [CORE-3001] - Install fails to create user & group "firebird"
• [CORE-3003] - Procedure suspend check may cause restore to fail
• [CORE-3006] - /tmp/firebird and files in it may get 'root' (i.e. GID == 0) group
• [CORE-3010] - First connect to any database shows MON$MEMORY_USED = 4Gb
• [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-3017] - Files left at Firebird's lock directory
• [CORE-3019] - Startup failure of SS and SC on linux gentoo
• [CORE-3021] - Segfault in DEV_BUILD
• [CORE-3034] - Bugcheсk 300 (can't find shared latch)
• [CORE-3038] - The insert failed because a column definition includes validation constraints. validation error for variable
• [CORE-3046] - Assertion after ALTER TABLE
• [CORE-3067] - Objects not unmapped when shared memory is closed

Improvement

• [CORE-3008] - Add attachment's CHARACTER SET name into corresponding trace records

Task

• [CORE-2517] - Not coping library on FreeBSD

Sub-task

• [CORE-2996] - Fix error code incompatibility introduced in fix for CORE-2552

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