All Projects : Firebird Core : Engine (Component)

Lead: Dmitry Yemanov
Description: Firebird database engine, all architectures and platform ports


 Select:   Open Issues   Road Map   Change Log   Popular Issues   

Change Log

Progress: 
  95 of 95 issues have been resolved
Beta Release
   Bug CORE-6137 FIXED Server crashes when it run SQL Critical Resolved
   Bug CORE-6090 FIXED BLOB fields may be suddenly set to NULLs during UPDATE after a table format change Critical Closed
   Improvement CORE-6032 FIXED Add DPB properties for time zone bind and decfloat configuration Major Resolved
   Improvement CORE-6004 FIXED Add a configuration switch to disable the "TCP Loopback Fast Path" option (Windows only) Major Resolved
   Improvement CORE-6017 FIXED Add transaction info fb_info_tra_snapshot_number Major Resolved
   Bug CORE-6080 FIXED Attempt to drop existing user randomly fails with "336723990 : record not found for user" Major Resolved
   Bug CORE-6150 FIXED Bugcheck when PK\UK\FK constraint check read record already marked as damaged Major Resolved
   Bug CORE-6168 FIXED Engine cant determine datatype in SQL: Unknown SQL Data type (32752). In current snapshot build Major Resolved
   Bug CORE-6143 FIXED Error 'Multiple maps found for ...' is raised in not appropriate case Major Resolved
   Bug CORE-6063 FIXED FB3 (protocol 13) returns op_accept instead op_accept_data Major Resolved
   Bug CORE-6281 FIXED Invalid timestamp errors with RDB$TIME_ZONE_UTIL.TRANSITIONS Major Resolved
   Task CORE-6289 FIXED Put RDB$ prefix in RDB$TIME_ZONE_UTIL.TRANSITIONS input/output parameters Major Resolved
   Bug CORE-6243 FIXED Regression: v4 Beta 1 rejects POSITION element of v2.5 defined SQL2003 CREATE TRIGGER syntax Major Resolved
   Bug CORE-6230 FIXED Unable to connect with database if security.db reference is removed from databases.conf file Major Resolved
   Bug CORE-6224 FIXED [AV] Re-destruction of the rem_port object Major Resolved
   Bug CORE-6217 FIXED [inet.cpp] Wrong work with pointer: delete ptr; ptr=new ; Major Resolved
   Bug CORE-6264 FIXED gbak with PIPE to stdout: invalid content if user '-se <host>:service_mgr' command switch Major Resolved
   Bug CORE-6171 FIXED "No current record for fetch operation" with queries with aggregated subselect Major Closed
   Bug CORE-6088 FIXED "SIMILAR TO" hangs when processing parenthesis Major Closed
   Bug CORE-6110 FIXED 64-bit transaction IDs are not stored properly in status vector Major Closed
   Bug CORE-6254 FIXED AV in engine when using SET TRANSACTION and ON TRANSACTION START trigger uses EXECUTE STATEMENT against current transaction Major Closed
   Bug CORE-6089 FIXED BLOBs are unnecessarily copied during UPDATE after a table format change Major Closed
   Improvement CORE-6057 FIXED Bind setting for Firebird 4 extended precision numeric/decimal Major Closed
   Bug CORE-6271 FIXED Bind time with time zone to legacy produces wrong values Major Closed
   Bug CORE-6218 FIXED COUNT(DISTINCT <DECFLOAT_FIELD>) leads FB to crash when there are duplicate values of this field Major Closed
   Improvement CORE-6058 FIXED Change behavior of skipped and repeated wall times within time zones Major Closed
   Bug CORE-6282 FIXED Change type of MON$ATTACHMENTS.MON$IDLE_TIMER and MON$STATEMENTS.MON$STATEMENT_TIMER to TIMESTAMP WITH TIME ZONE Major Closed
   New Feature CORE-6109 FIXED Changing FLOAT to a SQL standard compliant FLOAT datatype Major Closed
   Bug CORE-6211 FIXED Command "ISQL -X" can not extract ROLE name when use multi-byte charset for connection (4.x only is affected) Major Closed
   Bug CORE-5697 FIXED Conversion from numeric literals to DECFLOAT adds precision that is not originally present Major Closed
   Bug CORE-5696 FIXED Conversion from zero numeric literals to DECFLOAT results in incorrect value Major Closed
   Bug CORE-6086 FIXED Creating of the large procedure crashes the server. Major Closed
   Bug CORE-3925 FIXED Creating self-referential FK crashes database (bug-check) whether constraint violation had place Major Closed
   Bug CORE-6238 FIXED DECFLOAT: subtraction Num1 - Num2 leads to "Decimal float overflow" if Num2 is specified in scientific notation and less than max double ( 1.7976931348623157e308 ) Major Closed
   Improvement CORE-6278 FIXED Efficient table scans for DBKEY-based range conditions Major Closed
   Improvement CORE-6072 FIXED Ensure providers compatibility across versions Major Closed
   Improvement CORE-5658 FIXED Execute statement with excess parameters Major Closed
   Bug CORE-5972 FIXED External engine trigger crashing server if table have computed field Major Closed
   Bug CORE-6272 FIXED Failed attach to database not traced Major Closed
   Bug CORE-5691 FIXED File description on Firebird executables should be specific Major Closed
   Bug CORE-5888 FIXED Firebird server on Android has problem with numerics Major Closed
   Bug CORE-6182 FIXED Firebird's internal timer incorrectly resets existing timer entries Major Closed
   Bug CORE-6163 FIXED Generator pages are not encrypted Major Closed
   Bug CORE-6290 FIXED Hex number used at end of statement (for exame with CREATE DOMAIN ... DEFAULT) may read invalid memory and produce wrong values or exceptions Major Closed
   Sub-task CORE-6009 FIXED CORE-2917
I/O error during "open" operation for file "/tmp/firebird/fb_trace_*" in firebird.log
Major Closed
   Bug CORE-6138 FIXED Inconsistent behavior regarding visibility of master record on detail inserts Major Closed
   Bug CORE-6144 FIXED Inconsistent behaviour of the NEW context variable in AFTER UPDATE OR DELETE triggers Major Closed
   Bug CORE-6046 FIXED Incorrect time zone parsing reads garbage in memory Major Closed
   Improvement CORE-6274 FIXED Increase parse speed of long queries Major Closed
   Bug CORE-4874 FIXED Infinite "similar to" matching Major Closed
   New Feature CORE-3435 FIXED Lateral derived tables Major Closed
   Bug CORE-5784 FIXED Lock folder inizialization is not multi-process safe Major Closed
   Bug CORE-5074 FIXED Lost the charset ID in selection of array element Major Closed
   Bug CORE-6280 FIXED MERGE statement loses parameters in WHEN (NOT) MATCHED clause that will never be matched, crashes server in some situations Major Closed
   New Feature CORE-6018 FIXED Make it possible to start multiple transactions (possibly in different attachments) using the same initial transaction snapshot Major Closed
   Improvement CORE-6286 FIXED Make usage of TIMESTAMP/TIME WITH TIME ZONE convenient for users when appropriate ICU library is not installed on the client side Major Closed
   Bug CORE-6181 FIXED Operations when using "SET DECFLOAT BIND BIGINT,n" with result of 11+ digits, fail with "Decimal float invalid operation" Major Closed
   Bug CORE-6186 FIXED Original content of column which is involved into ENCRYPT() is displayed as distorted view after this call Major Closed
   Bug CORE-6087 FIXED Problem with casting within UNION Major Closed
   Bug CORE-6166 FIXED Problems with long object names (> 255 bytes) Major Closed
   Bug CORE-6236 FIXED RDB$TIME_ZONE_UTIL package has wrong privilege for PUBLIC Major Closed
   Task CORE-6016 FIXED Rename RDB$GET_CONTEXT('SYSTEM', 'SNAPSHOT_CN') to RDB$GET_CONTEXT('SYSTEM', 'SNAPSHOT_NUMBER') Major Closed
   New Feature CORE-6287 FIXED SET BIND OF type1 TO type2 Major Closed
   Bug CORE-5664 FIXED SIMILAR TO is substantially (500-700x) slower than LIKE on trivial pattern matches with VARCHAR data. Major Closed
   Bug CORE-4893 FIXED SIMILAR-TO leads FB to crash when checking blob with size > 2Gb for matching to string literal Major Closed
   Bug CORE-5892 FIXED SQL SECURITY DEFINER context is not properly evaluated for monitoring tables Major Closed
   New Feature CORE-6285 FIXED SQL-level replication management Major Closed
   Bug CORE-6159 FIXED SUBSTRING SIMILAR is described with wrong data type in DSQL Major Closed
   Bug CORE-6160 FIXED SUBSTRING of non-text/-blob is described to return NONE character set in DSQL Major Closed
   Bug CORE-6033 FIXED SUBSTRING(CURRENT_TIMESTAMP) does not work Major Closed
   Improvement CORE-6069 FIXED Show OS-specific error when entrypont is not found in dynamic library Major Closed
   Bug CORE-6250 FIXED Signature mismatch when creating package body on identical packaged procedure header Major Closed
   Bug CORE-6038 FIXED Srp user manager sporadically creates users which can not attach Major Closed
   Bug CORE-6034 FIXED The original time zone should be set to the current time zone at routine invocation Major Closed
   Bug CORE-6252 FIXED UNIQUE CONSTRAINT violation Major Closed
   Sub-task CORE-6083 FIXED CORE-4726
USING PLUGIN clause does not work in RECREATE USER
Major Closed
   Bug CORE-6214 FIXED Update outdated tzdata version Major Closed
   Bug CORE-6206 FIXED VARCHAR of insufficient length used for set bind of decfloat to varchar Major Closed
   Bug CORE-6260 FIXED Warnings not always displayed in ISQL Major Closed
   Bug CORE-6134 FIXED Win_Sspi in the list of auth plugins leads message about failed login to be changed (from 'Your user name and password are not defined...' to 'Missing security context ...') Major Closed
   Bug CORE-6233 FIXED Wrong dependencies of stored function on view after backup and restore Major Closed
   Bug CORE-6141 FIXED fbsvcmgr action_repair rpr_list_limbo_trans does not show list of transactions in LIMBO state Major Closed
   Bug CORE-5364 FIXED gfix -online normal <db> (being issued in window #1) does not produce error when there is sysdba attachment in window #2 Major Closed
   Bug CORE-6253 FIXED Crash caused by the locked fb_lock file Minor Resolved
   Bug CORE-6266 FIXED Deleting records from MON$ATTACHMENTS using ORDER BY clause doesn't close the corresponding attachments Minor Resolved
   Bug CORE-6248 FIXED A number of errors when database name is longer than 255 symbols Minor Closed
   Improvement CORE-6219 FIXED Add support for special (inf/nan) values when sorting DECFLOAT values Minor Closed
   Improvement CORE-6049 FIXED Builtin functions converting binary string to hexadecimal representation and vice versa Minor Closed
   Bug CORE-3380 FIXED Disable reading from new BLOB Minor Closed
   Bug CORE-6043 FIXED GTTs do not release used space Minor Closed
   Improvement CORE-6239 FIXED Procedures and EXECUTE BLOCK without RETURNS should not be allowed to use SUSPEND Minor Closed
   Improvement CORE-6279 FIXED Put options in user management statements in any order Minor Closed
   Bug CORE-6241 FIXED Values greater than number of days between 01.01.0001 and 31.12.9999 (=3652058) can be added or subtracted from DATE Minor Closed
   Improvement CORE-5538 FIXED Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern) Trivial Closed
   Improvement CORE-6048 FIXED Provide ability to see current state of DB encryption Trivial Closed
Progress: 
  41 of 42 issues have been resolved
Maintenance release
   Bug CORE-5966 UNRESOLVED Slow performance when executing SQL scripts as non-SYSDBA user Major Open
   Bug CORE-5982 FIXED error read permission for BLOB field, when it is input/output procedure`s parametr Blocker Closed
   Bug CORE-6137 FIXED Server crashes when it run SQL Critical Resolved
   Bug CORE-6090 FIXED BLOB fields may be suddenly set to NULLs during UPDATE after a table format change Critical Closed
   Bug CORE-5943 FIXED Server crashes preparing a query with both DISTINCT/ORDER BY and non-field expression in the select list Critical Closed
   Improvement CORE-6004 FIXED Add a configuration switch to disable the "TCP Loopback Fast Path" option (Windows only) Major Resolved
   Bug CORE-5935 FIXED Bugcheck 165 (cannot find tip page) Major Resolved
   Bug CORE-6150 FIXED Bugcheck when PK\UK\FK constraint check read record already marked as damaged Major Resolved
   Bug CORE-6143 FIXED Error 'Multiple maps found for ...' is raised in not appropriate case Major Resolved
   Bug CORE-6204 FIXED FB crash because TraceSvcJrd::checkPrivileges can pass NULL in 'alias' Major Resolved
   Bug CORE-6063 FIXED FB3 (protocol 13) returns op_accept instead op_accept_data Major Resolved
   Bug CORE-5959 FIXED Firebird returns wrong time after changes of time zone Major Resolved
   Bug CORE-6171 FIXED "No current record for fetch operation" with queries with aggregated subselect Major Closed
   Bug CORE-6089 FIXED BLOBs are unnecessarily copied during UPDATE after a table format change Major Closed
   Bug CORE-5070 FIXED Compound index cannot be used for filtering in some ORDER/GROUP BY queries Major Closed
   Bug CORE-6086 FIXED Creating of the large procedure crashes the server. Major Closed
   Bug CORE-3925 FIXED Creating self-referential FK crashes database (bug-check) whether constraint violation had place Major Closed
   Bug CORE-5995 FIXED Creator user name is empty in user trace sessions Major Closed
   Improvement CORE-6072 FIXED Ensure providers compatibility across versions Major Closed
   Bug CORE-5965 FIXED FB3 Optimiser chooses less efficient plan than FB2.5 optimiser Major Closed
   Bug CORE-5980 FIXED Firebird crashes due to concurrent operations with expression indices Major Closed
   Bug CORE-5888 FIXED Firebird server on Android has problem with numerics Major Closed
   Bug CORE-5936 FIXED Firebird server segfaults in the end of database backup Major Closed
   Bug CORE-6182 FIXED Firebird's internal timer incorrectly resets existing timer entries Major Closed
   Bug CORE-6163 FIXED Generator pages are not encrypted Major Closed
   Sub-task CORE-6009 FIXED CORE-2917
I/O error during "open" operation for file "/tmp/firebird/fb_trace_*" in firebird.log
Major Closed
   Bug CORE-6138 FIXED Inconsistent behavior regarding visibility of master record on detail inserts Major Closed
   Bug CORE-6144 FIXED Inconsistent behaviour of the NEW context variable in AFTER UPDATE OR DELETE triggers Major Closed
   Bug CORE-5395 FIXED Invalid data type for negation (minus operator) Major Closed
   Bug CORE-5784 FIXED Lock folder inizialization is not multi-process safe Major Closed
   Bug CORE-5074 FIXED Lost the charset ID in selection of array element Major Closed
   Bug CORE-5795 FIXED ORDER BY clause on compound index may disable usage of other indices Major Closed
   Bug CORE-5845 FIXED ORDER BY on index can cause suboptimal index choices Major Closed
   Bug CORE-6087 FIXED Problem with casting within UNION Major Closed
   Bug CORE-5985 FIXED Regression: ROLE does not passed in ES/EDS (specifying it in the statement is ignored) Major Closed
   Bug CORE-2440 FIXED Restoring DB with computed index on computed field provides wrong index and wrong select results Major Closed
   Bug CORE-6038 FIXED Srp user manager sporadically creates users which can not attach Major Closed
   Bug CORE-5993 FIXED When creation of audit log file fails, there is no error message in firebird.log Major Closed
   Bug CORE-6134 FIXED Win_Sspi in the list of auth plugins leads message about failed login to be changed (from 'Your user name and password are not defined...' to 'Missing security context ...') Major Closed
   Bug CORE-6141 FIXED fbsvcmgr action_repair rpr_list_limbo_trans does not show list of transactions in LIMBO state Major Closed
   Bug CORE-6043 FIXED GTTs do not release used space Minor Closed
   Bug CORE-5991 FIXED Trace could not work correctly with quoted file names in trace configurations Minor Closed
Progress: 
  15 of 15 issues have been resolved
Maintenance release
   Bug CORE-5943 FIXED Server crashes preparing a query with both DISTINCT/ORDER BY and non-field expression in the select list Critical Closed
   Bug CORE-5757 FIXED deadlock with events Critical Closed
   Bug CORE-5935 FIXED Bugcheck 165 (cannot find tip page) Major Resolved
   Improvement CORE-5853 FIXED Forward-compatible expressions LOCALTIME and LOCALTIMESTAMP Major Resolved
   Bug CORE-5014 FIXED Interrupt of aux connection during TCP setup phase causes unclear error messages in firebird.log Major Resolved
   Bug CORE-5017 FIXED Interrupt of aux connection during TCP setup phase causes server exit due to unhandled exception Major Resolved
   Bug CORE-5980 FIXED Firebird crashes due to concurrent operations with expression indices Major Closed
   Bug CORE-5936 FIXED Firebird server segfaults in the end of database backup Major Closed
   Bug CORE-5074 FIXED Lost the charset ID in selection of array element Major Closed
   Improvement CORE-5434 FIXED Read-only transactions in SuperServer could avoid immediate write of Header and TIP pages after change Major Closed
   Bug CORE-2440 FIXED Restoring DB with computed index on computed field provides wrong index and wrong select results Major Closed
   Bug CORE-5910 FIXED Server crash after kill in EDS manager destructor Major Closed
   Improvement CORE-2493 FIXED Append the IP address of the remote host to error messages in firebird.log for TCP connections Minor Resolved
   Bug CORE-5847 FIXED "Malformed string" instead of key value in PK violation error message Minor Closed
   Bug CORE-6043 FIXED GTTs do not release used space Minor Closed

Preset Filters


Component Summary

Open Open 725
   22%
In Progress In Progress 3
Reopened Reopened 16
Resolved Resolved 252
   8%
Closed Closed 2358
   70%

Open Issues

By Priority
Blocker Blocker 1
Critical Critical 23
   3%
Major Major 494
   66%
Minor Minor 204
   27%
Trivial Trivial 22
   3%

By Assignee
Adriano dos Santos Fernandes 9
   1%
Alexander Peshkov 23
   3%
Dmitry Yemanov 66
   9%
Paul Reeves 2
Roman Simakov 2
Vlad Khorsun 56
   8%
Unassigned 586
   79%