Release Notes - Firebird Core - Version 2.5 Alpha 1 - HTML format

Bug

  • [CORE-479] - Grants overwrite previous rdb$security_classes entries
  • [CORE-490] - GPRE does not recognize COALESCE
  • [CORE-1079] - Every attach of fbclient/fbembed library to the host process leaks 64KB of memory
  • [CORE-1105] - Database alias is visible when trying to drop database
  • [CORE-1254] - Problem with DISTINCT and insensitive collations
  • [CORE-1307] - Switch -s of fb_inet_server not processed correctly
  • [CORE-1357] - DummyPacketInterval mechanism broken
  • [CORE-1363] - ISQL crash when converted-from-double string longer than 23 bytes
  • [CORE-1390] - DB aliases do not work over XNET protocol with DatabaseAccess = None
  • [CORE-1410] - Deadlock in classic server on linux
  • [CORE-1421] - SuperServer can't shutdown immediately after shutdown request after failed login attempt
  • [CORE-1507] - isql linecount facility in scripts goes out of sync after an INPUT command.
  • [CORE-1512] - Connection lost running script
  • [CORE-1566] - nbackup uses aliases incorrectly
  • [CORE-1639] - XNet aliases problem
  • [CORE-1671] - atexit() calls in client libraries cause segfaults if the libraries are used in dlopen()ed modules
  • [CORE-1680] - "gsec display" only shows some first users when there are many users (>50) in security database
  • [CORE-1689] - 'There are <n> dependencies' error message shows the wrong count of dependent objects.
  • [CORE-1692] - Firebird::string::vprintf() fails with long resulting string
  • [CORE-1693] - Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers
  • [CORE-1694] - Bug in create/alter Database trigger (with Russian comment)
  • [CORE-1703] - Delays/lockups when the GBAK output is redirected to another process
  • [CORE-1724] - Common table expressions cannot be used in computed columns and quantified predicates (IN / ANY / ALL)
  • [CORE-1726] - Failure in isc_service_start()
  • [CORE-1728] - Monitoring tables do not work after fresh linux install.
  • [CORE-1730] - One directory in TempDirectories config setting not availibile
  • [CORE-1731] - Sometimes engine may "hang" using 100% CPU load and no IO activity for the few minutes
  • [CORE-1735] - Bug in SET DEFAULT statement
  • [CORE-1749] - DDL statement with AUTODDL ON won't show statistics
  • [CORE-1755] - AV in isc_start_transaction - null pointer at tr_handle
  • [CORE-1756] - AV in isc_start_transaction (isc_start_multiple) - bad TEB
  • [CORE-1763] - The client library does not set options SO_KEEPALIVE, TCP_NODELAY for socket at connection
  • [CORE-1766] - Incorrect owner and group of isc_monitor1 file on linux's classic server
  • [CORE-1770] - Bugcheck 291 in DDL
  • [CORE-1774] - Problem with COLLATE ES_ES_CI_AI
  • [CORE-1775] - Bad performance of security checking during prepare
  • [CORE-1777] - Engine allows conflicting table reservation specifications in TPB
  • [CORE-1778] - GSEC does not authenticate user correctly
  • [CORE-1782] - ISQL crashes when fetching data for a column having alias longer than 30 characters
  • [CORE-1784] - Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT
  • [CORE-1788] - Deadlock in DYN subsystem (superserver)
  • [CORE-1790] - PAG_page_count returns 3 for just created database
  • [CORE-1793] - AV at prepare of query with unused parametrized CTE
  • [CORE-1795] - Server crashes on SQL script
  • [CORE-1797] - OLD/NEW.RDB$DB_KEY returns incorrect result in triggers
  • [CORE-1798] - RDB$DB_KEY evaluates to NULL in INSERT ... RETURNING
  • [CORE-1802] - Maximum key size using PXW_CSY collation
  • [CORE-1805] - Database is not restored correctly using Services API
  • [CORE-1807] - fbserver assigned to non-canonical port after abnormal termination
  • [CORE-1810] - Usernames with '.' character
  • [CORE-1811] - Incorrect parser's reaction to the unquoted usage of the keyword "VALUE"
  • [CORE-1817] - The RelaxedAliasChecking parameter has no effect concerning RDB$DB_KEY
  • [CORE-1818] - Temporary files used for temporary page spaces are not deleted after use on Posix platform
  • [CORE-1820] - Bug in FB2.0 Setup. Setup program don't detect runned server.
  • [CORE-1826] - changeRunUser.sh and restoreRootRunUser.sh scripts does not change run user in init.d scripts
  • [CORE-1828] - Error with ABS in dialect 1
  • [CORE-1830] - Possible index corruption with multiply updates of the same record in the same transaction and using of savepoints
  • [CORE-1837] - Procedure text is stored truncated in system tables if any variable have default value
  • [CORE-1838] - SET STATISTICS INDEX on index of GTT may wrongly change index id by maximum available number for database page size
  • [CORE-1839] - AV when sorting by field, calculated using recursive CTE
  • [CORE-1840] - Small memory leak per every DDL execution
  • [CORE-1841] - If some VIEW used derived tables and long table names\aliases, It is possible to overflow RDB$VIEW_RELATIONS.RDB$CONTEXT_NAME
  • [CORE-1843] - gbak with service manager don't allow path with space
  • [CORE-1844] - Valgrind often reports "Conditional jump or move depends on uninitialised value(s)" in check_status_vector()
  • [CORE-1845] - Some standard calls show server installation directory to regular users
  • [CORE-1854] - Value of CURRENT_USER may be not in upper case when using unix OS auth.
  • [CORE-1859] - Arithmetic overflow or division by zero has occurred. in MAX function
  • [CORE-1862] - Isql's extracted script is unusable with interdependent selectable procedures in FB 2.1
  • [CORE-1864] - SELECT operator does not work in ISQL
  • [CORE-1868] - AV in isc_dsql_free_statement()
  • [CORE-1869] - Roles granting/revoking logic (differs between 2.0 and 2.1)
  • [CORE-1875] - Error on script with current_date
  • [CORE-1876] - Incremental backups with NBACKUP broken in 2.1
  • [CORE-1879] - Server uses wrong authentication method
  • [CORE-1881] - Database monitoring may crash the server or badly affect its page locking logic
  • [CORE-1884] - Random AVs using stored procedures with expressions as default values of input parameters
  • [CORE-1885] - CREATE COLLATION connection lost under Posix
  • [CORE-1887] - New created databases have wrong access rights
  • [CORE-1890] - Database monitoring process may hang under high load
  • [CORE-1891] - SHOW VIEW shows non-sense information for view fields with expressions
  • [CORE-1902] - XNET protocol does not work correctly in SuperClassic
  • [CORE-1905] - Hash sign (#) in filenames in aliases.conf not handled correctly
  • [CORE-1907] - Dropping and adding a domain constraint in the same transaction leaves incorrect dependencies
  • [CORE-1909] - Garbage in firebird.log on linux/amd64
  • [CORE-1910] - Not valid fields in MERGE's insert clause are allowed
  • [CORE-1911] - Backup and restore is not MT safe when using the Services API
  • [CORE-1919] - Memory corruptions in EXECUTE STATEMENT may crash the server
  • [CORE-1926] - MON$DATABASE returns outdated transaction counters
  • [CORE-1930] - Possible AV in engine if procedure was altered to have no outputs and dependent procedures was not recompiled
  • [CORE-2555] - CI column does not group correctly with a second column

Improvement

  • [CORE-707] - Thread-Safe client library
  • [CORE-789] - Collation backup of RDB$DEFAULT_COLLATE_
  • [CORE-805] - Privileges of dynamic statements in SP
  • [CORE-886] - SPs in views
  • [CORE-1234] - More information about table what belongs to column when checking privileges
  • [CORE-1453] - Allow usage of functions in LIST delimiter parameter
  • [CORE-1598] - Optimize data retrieval for tables when no fields are accessed
  • [CORE-1600] - Show more detailed error message if TPB is wrong
  • [CORE-1634] - Do not allow malformed characters in UNICODE_FSS fields
  • [CORE-1658] - Avoid memory consumption of <page size> bytes per every temporary blob
  • [CORE-1660] - Control assignment of SYSDBA rights to windows administrators during trusted auth on per-database basis
  • [CORE-1682] - Improve the way of use uuid
  • [CORE-1695] - Fix source install for amd64-based systems, having sybmolic link lib64 to lib.
  • [CORE-1737] - Setting default collate for a database
  • [CORE-1741] - API change for efficient unprepare
  • [CORE-1750] - Include information about context variables into the monitoring tables
  • [CORE-1751] - Include detailed memory usage statistics into the monitoring tables
  • [CORE-1803] - Default COLLATE for CREATE DATABASE statement
  • [CORE-1814] - Change the root determination of the embedded Windows engine and load DLLs with altered search path (to search dependent DLLs on the same path of the loaded DLL)
  • [CORE-1827] - Win32 Embedded Server should pass control to application before calling exit(3)
  • [CORE-1853] - Allow EXECUTE STATEMENT to run queries against external databases
  • [CORE-1880] - Linux startup script silently exits when missing 'main' executable
  • [CORE-1928] - Allow EXECUTE STATEMENT to inherit access privileges of caller stored procedure or trigger

New Feature

  • [CORE-696] - User Account maintanance in SQL
  • [CORE-769] - Wildcards/Regular Expressions in WHERE clause - SIMILAR TO predicate
  • [CORE-790] - ALTER VIEW
  • [CORE-793] - Ability to drop client connection
  • [CORE-824] - accent ignoring collation for unicode
  • [CORE-1211] - Dynamic SQL (EXECUTE STATEMENT) with parameters
  • [CORE-1356] - TYPE OF COLUMN in PSQL
  • [CORE-1409] - Support for autonomous transactions
  • [CORE-1454] - ALTER mechanism for computed fields
  • [CORE-1527] - Add operator EQUIV (IS NOT DISTINCT) and NULLIF function to GPRE
  • [CORE-1614] - new function mechanism for view-sp handling problem solve
  • [CORE-1640] - CREATE OR ALTER VIEW statement
  • [CORE-1656] - Ability to format UUID from char(16) OCTETS to human readable form and vice versa
  • [CORE-1760] - Support hex numeric and string literals
  • [CORE-1761] - SQL2003 compliant SQLSTATE completion codes
  • [CORE-1831] - Creation of GBAK restore switches FIX_FSS_DATA and FIX_FSS_METADATA

Sub-task

  • [CORE-1781] - LIKE, STARTING WITH and CONTAINING may incorrect return true
  • [CORE-1819] - More efficient solution for CORE-1300 (Lower level index pages is missed from parent page)

Edit/Copy Release Notes

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