Release Notes - Firebird Core - Version 4.0 Beta 1 - HTML format

Bug

  • [CORE-2284] - Records left in RDB$PAGES after rollback of CREATE TABLE statement
  • [CORE-2502] - Aliases and error about cyclic dependencies in CTE
  • [CORE-4481] - Local database mode parameters are ignored
  • [CORE-4492] - OR/IN predicates for RDB$DBKEY lead to NATURAL plan
  • [CORE-5480] - SUBSTRING startposition smaller than 1 should be allowed
  • [CORE-5547] - Server crashes while compiling stored procedure with nested references to query-based computed fields
  • [CORE-5598] - Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
  • [CORE-5600] - Invalid blob id when add a new blob column of type text and update another field
  • [CORE-5605] - Incorrect check for existing MAP in a case when pre-FB3 security database is used
  • [CORE-5611] - Higher memory consumption for prepared statements
  • [CORE-5613] - SuperServer could hung when changing physical backup state under high load
  • [CORE-5618] - Part of the pages of the second level blobs is not released when deleting relations.
  • [CORE-5624] - using backslash in alias on linux does not work
  • [CORE-5630] - Can't create the shadow file.
  • [CORE-5638] - Wrong result with index on case-insensitive collation using NUMERIC-SORT
  • [CORE-5643] - Message "Operating system call munmap failed. Error code 12" can appear in firebird.log under heavy load (2.5.x, CS, SC)
  • [CORE-5645] - Wrong transaction can be passed to external engine
  • [CORE-5646] - Parse error when compiling a statement causes memory leak until attachment is disconnected
  • [CORE-5649] - isc_add_user / isc_modify_user produce unusable user record
  • [CORE-5650] - Segfault when procedure dropped on classic server
  • [CORE-5651] - Problem migrating users to V3.0
  • [CORE-5653] - gbak restore with large number of small blobs very slow using Linux Classic
  • [CORE-5654] - Mixed intermediate build files for plugins examples
  • [CORE-5655] - isc_info_sql_relation_alias reports incorrect alias for CTE or nested queries
  • [CORE-5657] - Various UDF-related security vulnerabilities
  • [CORE-5659] - Bad PLAN generated for query on Firebird v3.0
  • [CORE-5667] - Regression in 3.0+: message "CTE 'X' has cyclic dependencies" appear when 'X' is alias for resultset and there is previous CTE part with the same name 'X' in the query
  • [CORE-5673] - Unique constraint not working in encrypted database on first command
  • [CORE-5675] - isc_vax_integer() and isc_portable_integer() work wrongly with short negative numbers
  • [CORE-5677] - Dirty RDB$PAGES after an error after phase 3 of create_relation
  • [CORE-5681] - AV when external statement is executed and local transaction is rolled back
  • [CORE-5684] - Error "no current record for fetch operation" is raised while deleting record from MON$ATTACHMENTS using ORDER BY clause
  • [CORE-5685] - Sometime it is impossible to cancel\kill connection executing external query
  • [CORE-5686] - Firebird 3.0.2 allows any protocol version >= 10 to connect, including interbase protocol 14
  • [CORE-5694] - Duplicate values in columns with a unique constraint
  • [CORE-5695] - Position function does not consider the collation for blob
  • [CORE-5700] - DECFLOAT underflow should yield zero instead of an error
  • [CORE-5706] - Trace config with misplaced "{" lead firebird to crash
  • [CORE-5713] - Field alias disapears in complex query
  • [CORE-5719] - FB >= 3 crashes when restoring backup made by FB 2.5.
  • [CORE-5720] - Sweep in Firebird 3 in CS mode could run too slow when there is big load on server
  • [CORE-5721] - Information items isc_info_length and fb_info_crypt_state have same code
  • [CORE-5730] - Connection to server may hang when working with encrypted databases over non-TCP protocol
  • [CORE-5737] - Invalid parameters of gds transaction in ISQL
  • [CORE-5742] - Incorrect error message in iSQL when trying to create database with wrong password
  • [CORE-5753] - Parser should not allow to use GRANT OPTION for FUNCTION and PACKAGE
  • [CORE-5754] - ALTER TRIGGER check privilege for alter database instead of table
  • [CORE-5756] - Regression: FB crashes when trying to recreate table that is in use by DML (3.0.3; 3.0.4; 4.0.0)

Improvement

  • [CORE-809] - Remove context limit for stored procedures / triggers
  • [CORE-1082] - Improve the statistics engine allowing auto-updating and gatherig more statistic data.
  • [CORE-2992] - Shorten backup/restore duration
  • [CORE-3295] - Estimate the actual record compression ratio in the optimizer
  • [CORE-3708] - Add actual configuration settings to the monitoring tables
  • [CORE-4017] - Add Transaction Parameters in Autonomous Transactions
  • [CORE-4401] - Optimize the record-level RLE algorithm for a denser compression of shorter-than-declared strings and sets of subsequent NULLs
  • [CORE-4402] - Add timing statistics to the monitoring tables
  • [CORE-4409] - Enhancement in precision of calculations with NUMERIC/DECIMAL
  • [CORE-4529] - Allow to use index when GROUP BY on field which has DESCENDING index
  • [CORE-4726] - Provide ability to do: REcreate user <user_name> password <user_pwd>
  • [CORE-4823] - Add support for Hash/merge algorithms for outer joins
  • [CORE-5239] - Add virtual table SEC$ROLES to return all roles currently active for the connected user
  • [CORE-5606] - Add expression index name to exception message if computation failed
  • [CORE-5610] - Provide info about database (or alias) which was in use during "Error during sweep: connection shutdown"
  • [CORE-5614] - Physical backup merge stage could run too long, especially with huge page cache
  • [CORE-5629] - gstat output does not include datetime of analysis
  • [CORE-5647] - Increase number of formats/versions of views from 255 to 32K
  • [CORE-5648] - Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
  • [CORE-5660] - Make flush of big number of dirty pages faster
  • [CORE-5674] - Allow unused Common Table Expressions
  • [CORE-5676] - Consider equivalence classes for index navigation
  • [CORE-5703] - When database validation fixes "orphan page" errors it also should adjust "lowest free page" marker (pip_min) on corresponding PIP, if necessary
  • [CORE-5704] - Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible
  • [CORE-5712] - Access to the name of DB encryption key
  • [CORE-5718] - Make TempCacheLimit setting database-wise
  • [CORE-5727] - Make faster engine response on cancel\shutdown signals when scanning long list of pointer pages
  • [CORE-5741] - Word "fixing" in gbak output is too scary

New Feature

  • [CORE-694] - Support timezones with timestamp
  • [CORE-820] - isc_dsql_exec* should allow list of parameter sets
  • [CORE-909] - Ability to retrieve Server Current UTC/GMT Timestamp
  • [CORE-1686] - Support value distribution histograms
  • [CORE-2021] - Built-in replication
  • [CORE-2479] - Add TRUNCATE TABLE
  • [CORE-3435] - Lateral derived tables
  • [CORE-5536] - Connections compressed and encrypted in MON$ATTACHMENTS table
  • [CORE-5620] - Add builtin functions FIRST_DAY and LAST_DAY

Sub-task

  • [CORE-5601] - Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call

Edit/Copy Release Notes

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