All Projects : Firebird Core (Key: CORE)

Project Lead: Dmitry Yemanov
URL: http://www.firebirdsql.org/index.php?op=devel&sub=engine
Description:
Everything that belong to core Firebird distribution package, i.e. the engine, basic tools, UDF's, character sets and collations, documentation/readme, installers etc.

Release Notes

Change Log Scope: previous 3 versions | all versions 3.0.7 ( 20/Oct/20 | Release Notes) Maintenance release    CORE-6346 FIXED New connection to the server hangs    CORE-6347 FIXED New connections to database server sometimes stall, when there is existing connection to database.    CORE-6424 FIXED Firebird 3.0.7 (x64) Installer is missing the employee.fdb database    CORE-6371 FIXED CORE-6364 Avoid server crash on shutdown in case of wrong reference counting in UDR    CORE-6388 FIXED DEV_BUILD client asserts when closing event thread    CORE-6339 FIXED Detach server from security database when missing plugin data structures cause an error    CORE-6360 FIXED Engine may hang due to races when starting crypt thread and simultaneous shutdown    CORE-6411 FIXED FB crashes on attempt to create table with number of fields greater than 5460.    CORE-6147 FIXED PLG$SRP table, PLG$SRP_VIEW View instructions are strangely added in the metadata script extracted when Windows trusted authentication is enabled    CORE-6364 FIXED Wrong reference counting in UDR trigger sample    CORE-6358 FIXED Adding NOT NULL column with DEFAULT value may cause default values to update when selecting or have the wrong charset    CORE-6340 FIXED Alternate quoting does not work on some particular cases    CORE-6362 FIXED Better diagnostic when 'Missing security context'    CORE-6351 FIXED Computed field could be wrongly evaluated as NULL    CORE-6292 FIXED MAC OS X client does not work in embedded mode    CORE-6392 FIXED Space in database path prevent working gbak -se ... -b "pat to/database" backup    CORE-6396 FIXED Unknown tag (0) in isc_svc_query() results    CORE-6348 FIXED Wire compression causes freezes    CORE-6253 FIXED Crash caused by the locked fb_lock file    CORE-6370 FIXED Memory leak at server, when client select computed field, which used COALESCE or CAST    CORE-6413 FIXED Remove PIDFile/-pidfile directive/option from firebird Super(Server/Classic) systemd unit 3.0.6 ( 26/Jun/20 | Release Notes) Maintenance release    CORE-6295 UNRESOLVED Incomplete header files    CORE-6296 FIXED Many connections results in poor performance    CORE-6343 FIXED Rolled back transaction produces unexpected results leading to duplicate values in PRIMARY KEY field    CORE-6116 FIXED The Metadata script extracted using ISQL of a database restored from a Firebird 2.5.9 Backup is invalid/incorrect when table has COMPUTED BY field    CORE-6212 FIXED Authentication plugin on server may get garbage data from client instead empty packet    CORE-6208 FIXED CREATE DATABASE grant is lost in security.db after backup/restore cycle    CORE-6323 FIXED File-system ID may be duplicated among databases located on different volumes    CORE-6221 FIXED Incorrect (throw-based) allocFunc for zlib1. Possible memory leak.    CORE-6331 FIXED Memory leak with some statements and expressions    CORE-6334 FIXED Missing relocation support    CORE-6230 FIXED Unable to connect with database if security.db reference is removed from databases.conf file    CORE-6224 FIXED [AV] Re-destruction of the rem_port object    CORE-6246 FIXED [fbclient] Problem with too many number of columns in resultset.    CORE-6217 FIXED [inet.cpp] Wrong work with pointer: delete ptr; ptr=new ;    CORE-6231 FIXED access violation on shutdown of xnet connection to local database when events have been registered    CORE-6264 FIXED gbak with PIPE to stdout: invalid content if user '-se <host>:service_mgr' command switch    CORE-6283 FIXED isNullable() in message metadata, returned by metadata builder, does not match with datatype set by setType() in metadata builder    CORE-6216 FIXED request size limit exceeded when selecting from a table with large number of indicies    CORE-6110 FIXED 64-bit transaction IDs are not stored properly in status vector    CORE-6254 FIXED AV in engine when using SET TRANSACTION and ON TRANSACTION START trigger uses EXECUTE STATEMENT against current transaction    CORE-6314 FIXED Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit    CORE-6130 FIXED Creating backup to stdout using service manager is broken    CORE-5972 FIXED External engine trigger crashing server if table have computed field    CORE-6329 FIXED GBAK with service_mgr and WinSSPI authentication for Windows SYSTEM user producing error in clumplet API    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    CORE-6274 FIXED Increase parse speed of long queries    CORE-6280 FIXED MERGE statement loses parameters in WHEN (NOT) MATCHED clause that will never be matched, crashes server in some situations    CORE-6319 FIXED NBACKUP locks db file on error    CORE-6237 FIXED Performance problem when using SRP plugin    CORE-6251 FIXED Regression: crash when built-in function LEFT() or RIGHT() missed 2nd argument (number of characters to be taken).    CORE-6269 FIXED Server (on Linux) ignores KeepAlive settings, when client connection is lost, the related server connection/process is not killed    CORE-6345 FIXED Server crashes on overflow of division result    CORE-6317 FIXED Server is crashing on long GRANT statement    CORE-6250 FIXED Signature mismatch when creating package body on identical packaged procedure header    CORE-6252 FIXED UNIQUE CONSTRAINT violation    CORE-5862 FIXED Varchar computed column without explicit type does not populate RDB$CHARACTER_LENGTH    CORE-6310 FIXED Varchar length limit is not enforced when assigning string with trailing spaces in MBCS    CORE-6260 FIXED Warnings not always displayed in ISQL    CORE-6233 FIXED Wrong dependencies of stored function on view after backup and restore    CORE-6309 FIXED fbsvcmgr can not decode information buffer returned by gfix list limbo service    CORE-5364 FIXED gfix -online normal <db> (being issued in window #1) does not produce error when there is sysdba attachment in window #2    CORE-6227 FIXED isc_info_svc_user_dbpath always returns alias of main security database    CORE-6265 FIXED mapping rules destroyed by backup / restore    CORE-6266 FIXED Deleting records from MON$ATTACHMENTS using ORDER BY clause doesn't close the corresponding attachments    CORE-4933 FIXED Add better transaction control to isql    CORE-6189 FIXED Building bundled libtommath fails    CORE-2251 FIXED gbak doesn't return error code 4.0 Beta 2 ( 14/May/20 | Release Notes) Beta Release    CORE-6207 FIXED Modifications needed to complile Firebird.pas under FPC    CORE-6137 FIXED Server crashes when it run SQL    CORE-6090 FIXED BLOB fields may be suddenly set to NULLs during UPDATE after a table format change    CORE-6040 FIXED Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field    CORE-6116 FIXED The Metadata script extracted using ISQL of a database restored from a Firebird 2.5.9 Backup is invalid/incorrect when table has COMPUTED BY field    CORE-6203 FIXED "Error reading data from the connection" is raised sometimes when using non-default authentication plugin    CORE-3983 FIXED Ability to authenticate user in "execute statement on external data source" by hash of current password    CORE-6032 FIXED Add DPB properties for time zone bind and decfloat configuration    CORE-5902 FIXED Add Firebird Event fails with error "While isc_que_events - Failed to establish a secondary connection for event processing."    CORE-6004 FIXED Add a configuration switch to disable the "TCP Loopback Fast Path" option (Windows only)    CORE-6268 FIXED Add methods to set various names (field, relation, etc.) in metadata builder.    CORE-6017 FIXED Add transaction info fb_info_tra_snapshot_number    CORE-6080 FIXED Attempt to drop existing user randomly fails with "336723990 : record not found for user"    CORE-6212 FIXED Authentication plugin on server may get garbage data from client instead empty packet    CORE-6150 FIXED Bugcheck when PK\UK\FK constraint check read record already marked as damaged    CORE-6208 FIXED CREATE DATABASE grant is lost in security.db after backup/restore cycle    CORE-6170 FIXED Cannot install on CentOS 8 because version of LibTomMath and LibNCurses library    CORE-6220 FIXED Enable delivery of known to the client key to any connection to the server    CORE-6168 FIXED Engine cant determine datatype in SQL: Unknown SQL Data type (32752). In current snapshot build    CORE-6143 FIXED Error 'Multiple maps found for ...' is raised in not appropriate case    CORE-6063 FIXED FB3 (protocol 13) returns op_accept instead op_accept_data    CORE-6221 FIXED Incorrect (throw-based) allocFunc for zlib1. Possible memory leak.    CORE-6281 FIXED Invalid timestamp errors with RDB$TIME_ZONE_UTIL.TRANSITIONS    CORE-6067 FIXED Memory leak in fbclient    CORE-6289 FIXED Put RDB$ prefix in RDB$TIME_ZONE_UTIL.TRANSITIONS input/output parameters    CORE-6108 FIXED Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters    CORE-6243 FIXED Regression: v4 Beta 1 rejects POSITION element of v2.5 defined SQL2003 CREATE TRIGGER syntax    CORE-6015 FIXED Segfault when using expression index with complex expression    CORE-6045 FIXED Segmentation fault in fbtracemgr when closing it using ctrl-C    CORE-6027 FIXED Server hang on new attachment right after trace session stop    CORE-6230 FIXED Unable to connect with database if security.db reference is removed from databases.conf file    CORE-6224 FIXED [AV] Re-destruction of the rem_port object    CORE-6217 FIXED [inet.cpp] Wrong work with pointer: delete ptr; ptr=new ;    CORE-6231 FIXED access violation on shutdown of xnet connection to local database when events have been registered    CORE-5976 FIXED gbak multi-database file restore uses wrong minimum number of pages for first database file    CORE-6264 FIXED gbak with PIPE to stdout: invalid content if user '-se <host>:service_mgr' command switch    CORE-6283 FIXED isNullable() in message metadata, returned by metadata builder, does not match with datatype set by setType() in metadata builder    CORE-6216 FIXED request size limit exceeded when selecting from a table with large number of indicies    CORE-6171 FIXED "No current record for fetch operation" with queries with aggregated subselect    CORE-6088 FIXED "SIMILAR TO" hangs when processing parenthesis    CORE-6110 FIXED 64-bit transaction IDs are not stored properly in status vector    CORE-6254 FIXED AV in engine when using SET TRANSACTION and ON TRANSACTION START trigger uses EXECUTE STATEMENT against current transaction    CORE-6026 FIXED Alignment issue with FB_MESSAGE C++ macro (as well UDR macros) and BIGINT/DECFLOAT types in Linux 32-bits    CORE-6089 FIXED BLOBs are unnecessarily copied during UPDATE after a table format change    CORE-6057 FIXED Bind setting for Firebird 4 extended precision numeric/decimal    CORE-6271 FIXED Bind time with time zone to legacy produces wrong values    CORE-5957 FIXED Bug in SIMILAR TO when adding numeric quantifier as bound for repetetion of expression leads to empty resultset    CORE-6218 FIXED COUNT(DISTINCT <DECFLOAT_FIELD>) leads FB to crash when there are duplicate values of this field    CORE-5445 FIXED Cannot install on Debian Stretch/Testing because version of LibTomMath library    CORE-6058 FIXED Change behavior of skipped and repeated wall times within time zones    CORE-6282 FIXED Change type of MON$ATTACHMENTS.MON$IDLE_TIMER and MON$STATEMENTS.MON$STATEMENT_TIMER to TIMESTAMP WITH TIME ZONE    CORE-6109 FIXED Changing FLOAT to a SQL standard compliant FLOAT datatype    CORE-6211 FIXED Command "ISQL -X" can not extract ROLE name when use multi-byte charset for connection (4.x only is affected)    CORE-6097 FIXED Connection does not see itself in the MON$ATTACHMENTS when Domain/Username (using SSPI) is 31 bytes long    CORE-5697 FIXED Conversion from numeric literals to DECFLOAT adds precision that is not originally present    CORE-5696 FIXED Conversion from zero numeric literals to DECFLOAT results in incorrect value    CORE-6130 FIXED Creating backup to stdout using service manager is broken    CORE-6086 FIXED Creating of the large procedure crashes the server.    CORE-3925 FIXED Creating self-referential FK crashes database (bug-check) whether constraint violation had place    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 )    CORE-6278 FIXED Efficient table scans for DBKEY-based range conditions    CORE-6072 FIXED Ensure providers compatibility across versions    CORE-6142 FIXED Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously    CORE-6093 FIXED CORE-6072 Errors simultaneously accessing security database from two engines    CORE-6091 FIXED CORE-6072 Errors when processing correct SQL statements in engine12 provider loaded by FB4 server    CORE-5658 FIXED Execute statement with excess parameters    CORE-6095 FIXED Extend trace record for COMMIT/ROLLBACK RETAINING to allow chaining of transaction ids    CORE-5972 FIXED External engine trigger crashing server if table have computed field    CORE-6272 FIXED Failed attach to database not traced    CORE-5691 FIXED File description on Firebird executables should be specific    CORE-6007 FIXED Firebird does not build on Mac with fresh toolchain    CORE-5888 FIXED Firebird server on Android has problem with numerics    CORE-6182 FIXED Firebird's internal timer incorrectly resets existing timer entries    CORE-6205 FIXED Generate proper error for UNION DISTINCT with more than 255 columns    CORE-6163 FIXED Generator pages are not encrypted    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    CORE-6009 FIXED CORE-2917 I/O error during "open" operation for file "/tmp/firebird/fb_trace_*" in firebird.log    CORE-6044 FIXED ISQL issues with increased identifier length    CORE-6138 FIXED Inconsistent behavior regarding visibility of master record on detail inserts    CORE-6144 FIXED Inconsistent behaviour of the NEW context variable in AFTER UPDATE OR DELETE triggers    CORE-6104 FIXED Incorrect error "invalid request handle" is thrown when an embedded user doesn't have SELECT permissions    CORE-6046 FIXED Incorrect time zone parsing reads garbage in memory    CORE-6274 FIXED Increase parse speed of long queries    CORE-3773 FIXED Inefficient memory usage and speed of SIMILAR TO when handling long text BLOB    CORE-4874 FIXED Infinite "similar to" matching    CORE-3435 FIXED Lateral derived tables    CORE-6031 FIXED Little valgrind memory leak in isc_attach_database    CORE-5784 FIXED Lock folder inizialization is not multi-process safe    CORE-5074 FIXED Lost the charset ID in selection of array element    CORE-6280 FIXED MERGE statement loses parameters in WHEN (NOT) MATCHED clause that will never be matched, crashes server in some situations    CORE-4462 FIXED Make it possible to restore compressed .nbk files without explicitly decompressing them    CORE-6018 FIXED Make it possible to start multiple transactions (possibly in different attachments) using the same initial transaction snapshot    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    CORE-6294 FIXED Negative 128-bit integer constants are not accepted in DEFAULT clause    CORE-6181 FIXED Operations when using "SET DECFLOAT BIND BIGINT,n" with result of 11+ digits, fail with "Decimal float invalid operation"    CORE-6186 FIXED Original content of column which is involved into ENCRYPT() is displayed as distorted view after this call    CORE-6237 FIXED Performance problem when using SRP plugin    CORE-6078 FIXED Permissions for create or alter statements are not checked.    CORE-6087 FIXED Problem with casting within UNION    CORE-6166 FIXED Problems with long object names (> 255 bytes)    CORE-6236 FIXED RDB$TIME_ZONE_UTIL package has wrong privilege for PUBLIC    CORE-6251 FIXED Regression: crash when built-in function LEFT() or RIGHT() missed 2nd argument (number of characters to be taken).    CORE-6016 FIXED Rename RDB$GET_CONTEXT('SYSTEM', 'SNAPSHOT_CN') to RDB$GET_CONTEXT('SYSTEM', 'SNAPSHOT_NUMBER')    CORE-6071 FIXED Restore of encrypted backup of database with SQL dialect 1 fails    CORE-6287 FIXED SET BIND OF type1 TO type2    CORE-6262 FIXED SHOW DOMAIN/TABLE does not display character set of system objects    CORE-5931 FIXED SIMILAR TO does not return result when invalid pattern is used (with two adjacent special characters that should be escaped but aren't)    CORE-5664 FIXED SIMILAR TO is substantially (500-700x) slower than LIKE on trivial pattern matches with VARCHAR data.    CORE-4893 FIXED SIMILAR-TO leads FB to crash when checking blob with size > 2Gb for matching to string literal    CORE-5892 FIXED SQL SECURITY DEFINER context is not properly evaluated for monitoring tables    CORE-6285 FIXED SQL-level replication management    CORE-6159 FIXED SUBSTRING SIMILAR is described with wrong data type in DSQL    CORE-6160 FIXED SUBSTRING of non-text/-blob is described to return NONE character set in DSQL    CORE-6033 FIXED SUBSTRING(CURRENT_TIMESTAMP) does not work    CORE-6068 FIXED Server hangs when compiling big package with error    CORE-6069 FIXED Show OS-specific error when entrypont is not found in dynamic library    CORE-6250 FIXED Signature mismatch when creating package body on identical packaged procedure header    CORE-6185 FIXED Some (wrong ?) parameters of ENCRYPT() leads FB to crash    CORE-6038 FIXED Srp user manager sporadically creates users which can not attach    CORE-6034 FIXED The original time zone should be set to the current time zone at routine invocation    CORE-6028 FIXED Trigger on system table restored in FB3 database and can't be deleted    CORE-6252 FIXED UNIQUE CONSTRAINT violation    CORE-6083 FIXED CORE-4726 USING PLUGIN clause does not work in RECREATE USER    CORE-6214 FIXED Update outdated tzdata version    CORE-6206 FIXED VARCHAR of insufficient length used for set bind of decfloat to varchar    CORE-3858 FIXED Very poor performance of SIMILAR TO on some arguments + unable to disconnect via DELETE FROM MON$ATTACHMENTS    CORE-6260 FIXED Warnings not always displayed in ISQL    CORE-6050 FIXED When FB 3 fbclient.dll connects to a remote FB 2.5 server, it tries to open local (client-side) directories and files    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 ...')    CORE-4463 FIXED CORE-4462 Windows implementation for 4462    CORE-6233 FIXED Wrong dependencies of stored function on view after backup and restore    CORE-6141 FIXED fbsvcmgr action_repair rpr_list_limbo_trans does not show list of transactions in LIMBO state    CORE-6000 FIXED gbak issues "Your user name and password are not defined" when command switch "-fe(tch_password) ..." is specified when run as service    CORE-5364 FIXED gfix -online normal <db> (being issued in window #1) does not produce error when there is sysdba attachment in window #2    CORE-6227 FIXED isc_info_svc_user_dbpath always returns alias of main security database    CORE-6265 FIXED mapping rules destroyed by backup / restore    CORE-6266 FIXED Deleting records from MON$ATTACHMENTS using ORDER BY clause doesn't close the corresponding attachments    CORE-6248 FIXED A number of errors when database name is longer than 255 symbols    CORE-4739 FIXED Accent insensitive comparison: diacritical letters with DIAGONAL crossing stroke pass only test on EQUALITY to their non-accented forms    CORE-4933 FIXED Add better transaction control to isql    CORE-6219 FIXED Add support for special (inf/nan) values when sorting DECFLOAT values    CORE-6061 FIXED Building with --with-builtin-tommath doesn't work    CORE-6049 FIXED Builtin functions converting binary string to hexadecimal representation and vice versa    CORE-3380 FIXED Disable reading from new BLOB    CORE-4579 FIXED Distribute separate header files instead merged one    CORE-6043 FIXED GTTs do not release used space    CORE-6197 FIXED Memory leak in INET_connect()    CORE-6239 FIXED Procedures and EXECUTE BLOCK without RETURNS should not be allowed to use SUSPEND    CORE-4726 FIXED Provide ability to do: REcreate user <user_name> password <user_pwd>    CORE-6279 FIXED Put options in user management statements in any order    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    CORE-6019 FIXED Wire compression not working without MSVC 2010 runtime installation (FB4 Beta1)    CORE-5099 FIXED build with gcc6 broken    CORE-2251 FIXED gbak doesn't return error code    CORE-6056 FIXED overflow warings in some collations    CORE-5538 FIXED Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern)    CORE-6048 FIXED Provide ability to see current state of DB encryption    CORE-6174 FIXED ibase.h is missing from nightly builds

Reports

Preset Filters

Project Summary

	Open	1390	22%
	In Progress	4
	Reopened	26
	Resolved	491	8%
	Closed	4339	69%

Open Issues

	Blocker	10	1%
	Critical	52	4%
	Major	890	63%
	Minor	397	28%
	Trivial	71	5%

By Assignee

Adriano dos Santos Fernandes	26	2%
Alexander Peshkov	46	3%
Claudio Valderrama C.	3
Dmitry Yemanov	83	6%
Egor Pugin	1
Michal Kubeček	1
Paul Reeves	18	1%
Roman Simakov	2
Vlad Khorsun	77	5%
Unassigned	1163	82%