Release Notes - Firebird Core - Version 3.0 Alpha 2 - HTML format

Bug

  • [CORE-362] - Impossible to enter certain characters in isql
  • [CORE-2165] - Unnecessary 1 index read may occur when using strict inequality condition
  • [CORE-2648] - Nbackup's delta file ignored Forced Writes database setting
  • [CORE-3921] - "record disappeared (186), file: vio.cpp line: 408" + CPU 100% (when bugcheckabort=1 and sweep starts at gap ~21000)
  • [CORE-3989] - Bad performance / slow response when many concurrent sorts are executed
  • [CORE-4145] - Memory leak when preparing Execute Block which uses domains
  • [CORE-4149] - New permission types are not displayed by ISQL
  • [CORE-4153] - Attempting to use Legacy_Auth directly after install doesn't work, restart of service is required
  • [CORE-4155] - External routines DDL in Packages wrongly report error for termination with semi-colon
  • [CORE-4156] - RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE.
  • [CORE-4158] - Regression: LIKE with escape doesn't work
  • [CORE-4159] - Incorrect memory statistics is reported
  • [CORE-4160] - The parameterized exception does not accept not ASCII characters as parameter
  • [CORE-4162] - Warnings are not returned from attachDatabase() call
  • [CORE-4163] - Configuration fbtrace.conf contains syntax errors
  • [CORE-4164] - Owner name is missing for generators/exceptions restored from a backup
  • [CORE-4168] - Backup containing procedures or triggers that select from external tables cannot be restored with ExternalFileAccess=None
  • [CORE-4173] - Setting generator value twice in single transaction will set it to zero
  • [CORE-4176] - Monitoring tables return incomplete information in SC/CS configurations
  • [CORE-4177] - Problem with some boolean expressions not being allowed
  • [CORE-4178] - New API should return proper metadata properties, not the historical artifacts
  • [CORE-4180] - CREATE COLLATION does not verify base collation charset
  • [CORE-4184] - Executing empty EXECUTE BLOCK with NotNull output parameter raised error
  • [CORE-4185] - FB craches with "invalid lock id (NNNNN)"
  • [CORE-4198] - Incorrect "token unknown" error when the SQL string ends with a hex number literal
  • [CORE-4200] - An uncommitted select of the pseudo table sec$users blocks new database connections
  • [CORE-4201] - Regression: Computed field returns null value inside BI trigger
  • [CORE-4202] - Regression: Backup/Restore from old version to v3.0 fails with BLR error
  • [CORE-4203] - Cannot create packaged routines with [VAR]CHAR parameters
  • [CORE-4205] - ISQL -x does not output the START WITH clause of generators/sequences
  • [CORE-4211] - Embedded engine hangs for 5 seconds when closing, errors about timeout in shutdown process and invalid mutex placed in firebird.log.
  • [CORE-4212] - Dropping FK on GTT crashes server
  • [CORE-4214] - GTT should not reference permanent relation
  • [CORE-4216] - Memory leak with TRIGGER ON TRANSACTION COMMIT
  • [CORE-4219] - Regular expressions with double-slash fail in trace
  • [CORE-4225] - Server crashes when attempting to trace activity on database having a db-level trigger
  • [CORE-4227] - Regression: Wrong evaluation of BETWEEN and boolean expressions due to parser conflict
  • [CORE-4229] - Bidirectional cursor is not positioned by the first call of FETCH LAST
  • [CORE-4234] - Error with IF (subfunc()) when subfunc returns a boolean
  • [CORE-4235] - Deadlock is possible while accessing the monitoring tables under concurrent load
  • [CORE-4236] - Database shutdown is reported as successfully completed before all active connections are in fact interrupted
  • [CORE-4237] - FB3 vs FB2.5. Different metadata for UDF return argument
  • [CORE-4240] - Regression: recursive query in SQL query returns incorrect results if more than one branch bypass
  • [CORE-4241] - FB 3.0 alpha: Empty password will pass login
  • [CORE-4244] - Problem with creation procedure which contain adding text in DOS864 charset
  • [CORE-4247] - Delete "where current of" cursor fails for tables with newly added fields
  • [CORE-4250] - AV in guardian at process shutdown
  • [CORE-4251] - Guardian service could write garbage after the end of message in the Event Log
  • [CORE-4255] - Parametrized queries using RDB$DB_KEY do not work
  • [CORE-4258] - Regression: Wrong boundary for minimum value for BIGINT/DECIMAL(18)
  • [CORE-4259] - Don't call setlocale(LC_CTYPE, "") in isql for Windows
  • [CORE-4261] - Wrong result of join when joined fields are created via row_number() function
  • [CORE-4262] - Context parsing error with derived tables and CASE functions
  • [CORE-4265] - Unexpected lock conflict error may be raised while connecting to a heavily loaded database
  • [CORE-4267] - Server crashes while sweeping the database
  • [CORE-4268] - Server may crash while disconnecting from a database
  • [CORE-4269] - Wrong output when field with result of windowed function is used in query with useless WHERE 0=0 and GROUP BY clause
  • [CORE-4270] - Error in case of subquery with windowed function + where <field> IN(select ...)
  • [CORE-4271] - Engine crashs in case of re-creation of an erratic package body
  • [CORE-4281] - FB 3: TYPE OF arguments of stored functions will hang firebird engine if depending domain or column is changed
  • [CORE-4283] - Resource temporarily unavailable errors while simultaneously registering events
  • [CORE-4289] - Regression: NOT-null field from derived table became NULL when is referred outside DT
  • [CORE-4293] - FB crashes on SELECT with long/complex list of compound AND/OR'd predicates
  • [CORE-4297] - Gfix crashed when description of limbo transaction have size large than 1KB
  • [CORE-4298] - fbsvcmgr doesn't recognise sts_record_versions and other sts switches
  • [CORE-4302] - Lookup (or scan) in descending index could be very inefficient for some keys
  • [CORE-4315] - Usage of field's alias in view WITH CHECK OPTION leads to incorrect compile error or incorrect internal triggers

Improvement

  • [CORE-1846] - Allow index walk (ORDER plan) when there's a composite index {A, B} and the query looks like WHERE A = ? ORDER BY B
  • [CORE-3365] - Extend syntax for ALTER USER CURRENT_USER
  • [CORE-3931] - SQL commands to query/alter users description
  • [CORE-4085] - Add systemd init scripts
  • [CORE-4148] - Increase ISQL buffer size from 64 KB to 10 MB, as the engine
  • [CORE-4154] - Firebird.conf should list names of (standard) authentication + usermanager plugins
  • [CORE-4165] - Replace the hierarchical union execution with the plain one
  • [CORE-4199] - Add optional START WITH clause to identity columns
  • [CORE-4206] - Add RESTART [WITH] clause for alter identity columns
  • [CORE-4215] - Execution of SET STATISTICS INDEX statement could block or slow execution of concurrent attachments
  • [CORE-4218] - Add database owner to mon$database
  • [CORE-4222] - Provide ability to know which auth. method was applied for establishing connect
  • [CORE-4273] - Per-database control on access to database from remote stations
  • [CORE-4285] - Choose the best matching index for navigation
  • [CORE-4290] - Extensible property support which can add properties (name-value pairs) to users (which are stored in the security database and can be managed in some way)
  • [CORE-4350] - Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause)

New Feature


Edit/Copy Release Notes

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