Firebird Documentation IndexFirebird 3.0.3 Release Notes → Bugs Fixed
Firebird Home Firebird Home Prev: Remote Client RecognitionFirebird Documentation IndexUp: Firebird 3.0.3 Release NotesNext: Firebird 3.0.2 Release: Bug Fixes

Bugs Fixed

Table of Contents

Firebird 3.0.3 Release: Bug Fixes
Firebird 3.0.2 Release: Bug Fixes
Firebird 3.0.1 Release: Bug Fixes
Firebird 3.0.0 Release: Bug Fixes
Firebird 3.0 Release Candidate 2: Bug Fixes and Minor Improvements
Firebird 3.0 Release Candidate 1: Bug Fixes and Minor Improvements
Firebird 3.0 Second Beta Release: Bug Fixes
Firebird 3.0 Second Beta Release: Improvements
Firebird 3.0 First Beta Release
Firebird 3.0 Second Alpha Release
Firebird 3.0 First Alpha Release

Firebird 3.0.3 Release: Bug Fixes

The following bug fixes were reported prior to the v.3.0.3 official release:

Core Engine

(CORE-5735)     An additional keyholder could open unauthorized connections to an encrypted database, creating a vulnerability.

fixed by A. Peshkov

    ~ ~ ~     

(CORE-5720)     Sweep in Classic mode could run too slowly when there was a big load on the server.

fixed by V. Khorsun

    ~ ~ ~     

(CORE-5713)     A field alias could disappear in a complex query

fixed by A. dos Santos Fernandes

    ~ ~ ~     

(CORE-5695)     The function position did not consider the collation for BLOBs.

fixed by V. Khorsun

    ~ ~ ~     

(CORE-5694)     Duplicate values could occur in columns with the UNIQUE constraint.

fixed by V. Khorsun

    ~ ~ ~     

(CORE-5684)     Error “no current record for fetch operation” was raised while deleting a record from MON$ATTACHMENTS using ORDER BY clause

fixed by D. Yemanov

    ~ ~ ~     

(CORE-5681)     An access violation could occur when an external statement was executed and the local transaction was rolled back.

fixed by V. Khorsun

    ~ ~ ~     

(CORE-5675)     isc_vax_integer() and isc_portable_integer() did not work properly with short negative numbers.

fixed by D. Sibiryakov

    ~ ~ ~     

(CORE-5673)     Unique constraint would not work in an encrypted database on first command.

fixed by A. Peshkov

    ~ ~ ~     

(CORE-5667)     Message “CTE 'X' has cyclic dependencies” would appear when 'X' was the alias for a result set and there was a previous CTE part in the query with the same name 'X'.

fixed by V. Khorsun

    ~ ~ ~     

(CORE-5659)     The optimizer was generating a bad plan under certain conditions.

fixed by D. Yemanov

    ~ ~ ~     

(CORE-5655)     isc_info_sql_relation_alias was reporting incorrect aliases for CTE or nested queries.

fixed by V. Khorsun

    ~ ~ ~     

(CORE-5645)     A wrong transaction could be passed to the external engine.

fixed by A. dos Santos Fernades

    ~ ~ ~     

(CORE-5643)     Message “Operating system call munmap failed. Error code 12” could appear in firebird.log under heavy load in Classic or Superclassic.

fixed by A. Peshkov

    ~ ~ ~     

(CORE-5638)     Wrong result with index on case-insensitive collation using NUMERIC-SORT.

fixed by A. dos Santos Fernandes

    ~ ~ ~     

(CORE-5618)     Some portions of the pages of second-level blobs were not released when dropping relations.

fixed by D. Logashov

    ~ ~ ~     

(CORE-5605)     When running with a plug-in to access a V.2.5 database, the engine would incorrectly check for existing MAP if a pre-FB3 security database was used.

fixed by A. Peshkov

    ~ ~ ~     

(CORE-5600)     An invalid blob id would be reported when adding a new blob column of type text and updating another field in the same operation.

fixed by V.Khorsun

    ~ ~ ~     

(CORE-5598)     Error “Block size exceeds implementation restriction” could occur while inner joining large datasets with a long key using the HASH JOIN plan.

fixed by D. Yemanov

    ~ ~ ~     

(CORE-5588)     DbInfo interface was not being passed to ancillary instances of a plug-in.

fixed by A. Peshkov

    ~ ~ ~     

(CORE-5580)     Signatures of packaged functions were not being checked for mismatch with the [NOT] DETERMINISTIC attribute.

fixed by A. dos Santos Fernandes

    ~ ~ ~     

(CORE-5576)     Queries containing a WITH LOCK clause could trigger a bugcheck.

fixed by R. Simakov

    ~ ~ ~     

(CORE-5567)     Direct system table modifications were not completely prohibited.

fixed by A. dos Santos Fernandes

    ~ ~ ~     

(CORE-5555)     Error handling for SELECT WITH LOCK broke compatibility with Firebird 2.5.

fixed by V. Khorsun

    ~ ~ ~     

(CORE-5553)     A database could not be encrypted if the DatabaseAccess was set to None.

fixed by A. Peshkov

    ~ ~ ~     

(CORE-5550)     A computed decimal field in a view could be stored with the wrong RDB$FIELD_PRECISION value.

fixed by A. dos Santos Fernandes

    ~ ~ ~     

(CORE-5549)     Errors could occur when building or running Firebird on hardware that did not have SSE enabled.

fixed by A. Peshkov

    ~ ~ ~     

(CORE-5542)     Database-level triggers related to TRANSACTION events (start/commit/rollback) were not taking their POSITION index into account.

fixed by A. dos Santos Fernandes

    ~ ~ ~     

(CORE-5535)     The value of RDB$FIELD_SUB_TYPE in RDB$FUNCTION_ARGUMENTS would be garbage after altering the function.

fixed by A. dos Santos Fernandes

    ~ ~ ~     

(CORE-5528)     Internal Firebird consistency check (limbo impossible (184), file: vio.cpp line: 2379)

fixed by V. Khorsun

    ~ ~ ~     

(CORE-5527)     External routines were not receiving default values for their output parameters.

fixed by A. dos Santos Fernandes

    ~ ~ ~     

(CORE-5526)     External routines could receive parameters with incorrect length or data type.

fixed by A. dos Santos Fernandes

    ~ ~ ~     

(CORE-5517)     Classic server could raise the error “Global mapping memory overflow” periodically and require restarting to accept new connections.

fixed by A. Peshknov

    ~ ~ ~     

(CORE-5416)     Memory leak: Firebird did not release memory after load tests.

fixed by V. Khorsun

    ~ ~ ~     

(CORE-5415)     Found and fixed an elusive bug whereby an unexpected memory overwrite could cause the in-memory image of a random database page to be corrupted.

fixed by V. Khorsun, with testing assistance from D. Kovalenko

    ~ ~ ~     

(CORE-4492)     With OR or IN predicates for RDB$DBKEY, the optimizer failed to use an INDEX plan when it should have.

fixed by D. Yemanov

    ~ ~ ~     

(CORE-2853)     Bugcheck: page N, page type 5 lock conversion denied (215).

fixed by V. Khorsun

    ~ ~ ~     

(CORE-2731)     Recursive EXECUTE STATEMENT was not working properly.

fixed by V. Khorsun

    ~ ~ ~     

(CORE-2502)     Cyclic dependency errors in CTE, involving aliases.

fixed by V. Khorsun

    ~ ~ ~     

(CORE-2284)     Records were left in RDB$PAGES after rollback of CREATE TABLE statement.

fixed by R. Simakov & D. Yemanov

    ~ ~ ~     

Server Crashes/Hang-ups

(CORE-5730)     The connection to the server could hang when working with encrypted databases over network protocol other than TCP.

fixed by A. Peshkov

    ~ ~ ~     

(CORE-5719)     Firebird 3 engine could crash when restoring from a backup made by Firebird 2.5.

fixed by A. dos Santos Fernandes

    ~ ~ ~     

(CORE-5707)     Begin and end of physical backup in the same transaction could crash the engine.

fixed by V. Khorsun

    ~ ~ ~     

(CORE-5706)     Trace config with misplaced “{” could lead to an engine crash.

fixed by A. dos Santos Fernandes

    ~ ~ ~     

(CORE-5591)     The engine could hang during transaction start, soon after certain errors.

fixed by A. Peshkov

    ~ ~ ~     

(CORE-5562)     Firebird could crash when a UDF was loaded and unloaded frequently.

fixed by A. Peshkov

    ~ ~ ~     

(CORE-5547)     The server could crash while compiling a stored procedure with nested references to query-based computed fields.

fixed by D. Yemanov

    ~ ~ ~     

(CORE-5533)     The engine could crash when a database contained a database-level trigger.

fixed by A. dos Santos Fernandes

    ~ ~ ~     

(CORE-5516)     Firebird service could crash when stopping.

fixed by V. Khorsun

    ~ ~ ~     

Builds

(CORE-5654)     Intermediate build files for plugins examples were mixed up.

fixed by A. Peshkov

    ~ ~ ~     

API/Remote Interface

(CORE-5721)     Information items isc_info_length and fb_info_crypt_state had the same code.

Important

Software using the fb_info_crypt_state constant should be recompiled to make it work with release 3.0.3 and later.

fixed by A. Peshkov

    ~ ~ ~     

(CORE-5686)     Firebird 3.0.2 would allow any protocol version >= 10 to connect, including InterBase protocol 14

fixed by M. Rotteveel

    ~ ~ ~     

(CORE-5649)     isc_add_user / isc_modify_user could produce an unusable user record.

fixed by A. Peshkov

    ~ ~ ~     

(CORE-5521)     A race condition could arise between event notification and event registration.

fixed by V. Khorsun

    ~ ~ ~     

(CORE-5510)     The engine could send a status vector with more than 20 items to old clients and cause a disconnection.

fixed by R. Simakov

    ~ ~ ~     

POSIX Only

(CORE-5650)     Dropping a procedure on the Classic server could cause a segmentation fault.

fixed by A. Peshkov

    ~ ~ ~     

(CORE-5624)     An old bug was fixed, whereby backslashes in path strings for use on POSIX file systems were not always converted to forward slashes.

fixed by A. Peshkov

    ~ ~ ~     

Utilities

gbak

(CORE-5653)     gbak restore with a large number of small blobs was very slow using Linux Classic.

fixed by R. Simakov

    ~ ~ ~     

(CORE-5630)     During restore, the shadow file could not be created.

fixed by A. Peshkov

    ~ ~ ~     

(CORE-5579)     A request synchronization error could occur in gbak during a restore.

fixed by V. Khorsun

    ~ ~ ~     

(CORE-5566)     The server could crash while restoring from a backup if the shadow file already existed.

fixed by D. Yemanov

    ~ ~ ~     

isql

(CORE-5569)     isql would incorrectly pad UNICODE_FSS/UTF8 columns when they used a collation.

fixed by A. dos Santos Fernandes

    ~ ~ ~     

(CORE-5570)     Negative infinity (double) was being shown incorrectly without the sign in isql.

fixed by A. dos Santos Fernandes

    ~ ~ ~     

nBackup

(CORE-5613)     Superserver could hang when changing physical backup state under high load

fixed by V. Khorsun

    ~ ~ ~     

(CORE-5540)     Alternate executions of an isql command from the command line in embedded mode would be 5 to 10 times slower, i.e., fast-slow-fast-slow...

fixed by V. Khorsun

    ~ ~ ~     

User Management

(CORE-5651)     Problem migrating users to V3.0.

fixed by A. Peshkov

    ~ ~ ~     

Prev: Remote Client RecognitionFirebird Documentation IndexUp: Firebird 3.0.3 Release NotesNext: Firebird 3.0.2 Release: Bug Fixes
Firebird Documentation IndexFirebird 3.0.3 Release Notes → Bugs Fixed