Release Notes - Firebird Core - Version 3.0.3 - HTML format

Bug

  • [CORE-2284] - Records left in RDB$PAGES after rollback of CREATE TABLE statement
  • [CORE-2502] - Aliase in CTE
  • [CORE-2731] - Recursive EXECUTE STATEMENT works wrong
  • [CORE-2853] - page 14194, page type 5 lock conversion denied (215)
  • [CORE-4492] - OR/IN predicates for RDB$DBKEY lead to NATURAL plan
  • [CORE-5415] - [security3.fdb] wrong page type page 22 is of wrong type (expected pointer, found index root)
  • [CORE-5416] - [FB3] Memory Leaks. FB does not release memory after load tests.
  • [CORE-5510] - 3+ versions may send status vector with more then 20 items to old clients and cause disconnect
  • [CORE-5516] - Firebird service crashes when stopping
  • [CORE-5517] - Classic server periodically raise "Global mapping memory overflow" and need to be restarted to accept new connections
  • [CORE-5521] - Race condition between event notification and event registration
  • [CORE-5526] - External routines receives parameters with incorrect length or datatype
  • [CORE-5527] - External routines does not receive default values for they output parameters
  • [CORE-5528] - internal Firebird consistency check (limbo impossible (184), file: vio.cpp line: 2379)
  • [CORE-5533] - Crash on 3.0 and 4.0 when DB contains database-level trigger
  • [CORE-5535] - Garbage value in RDB$FIELD_SUB_TYPE in RDB$FUNCTION_ARGUMENTS after altering function
  • [CORE-5540] - Every other execution of embedded isql slow
  • [CORE-5542] - Database-level triggers related to TRANSACTION events (i.e. start, commit and rollback) do not take in account their POSITION index (when more than one trigger for the same event type is defined)
  • [CORE-5547] - Server crashes while compiling stored procedure with nested references to query-based computed fields
  • [CORE-5549] - Errors building / running FB on non-SSE enabled HW
  • [CORE-5550] - Computed decimal field in a view has wrong RDB$FIELD_PRECISION
  • [CORE-5553] - Database cannot be encrypted if DatabaseAccess is set to None
  • [CORE-5555] - 3.0 error handling for SELECT WITH LOCK breaks compatibility with 2.5
  • [CORE-5562] - Firebird crashes when UDF (Delphi?) gets loaded and unloaded frequently
  • [CORE-5566] - Server crashes while restoring backup if the shadow file already exists
  • [CORE-5567] - Direct system table modifications are not completely prohibited
  • [CORE-5569] - ISQL incorrectly pads UNICODE_FSS/UTF8 columns when they use a collation
  • [CORE-5570] - Negative infinity (double) shown incorrectly without sign in isql
  • [CORE-5576] - Bugcheck on queries containing WITH LOCK clause
  • [CORE-5579] - request synchronization error in the GBAK utility (restore)
  • [CORE-5580] - Signature of packaged functions is not checked for mismatch with [NOT] DETERMINISTIC attribute
  • [CORE-5588] - DbInfo interface is not passed to ancillary instances of plugin
  • [CORE-5591] - Engine hangs soon after some errors during transaction start
  • [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-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-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-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-5677] - Dirty RDB$PAGES after an error after phase 3 of create_relation

Improvement

  • [CORE-3295] - Estimate the actual record compression ratio in the optimizer
  • [CORE-4913] - Database backup using Nbackup is getting slow when directed to NAS over SMB protocol
  • [CORE-5543] - Restore of pre ODS 11.1 database can leave RDB$RELATION_TYPE null
  • [CORE-5602] - slow changes on domain
  • [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-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

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.