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

Road Map View personal road map Scope: next 3 versions | all versions 4.0 Beta 1 ( Release Notes ) Progress:    193 of 209 issues have been resolved Beta Release    CORE-2479 UNRESOLVED Add TRUNCATE TABLE    CORE-4017 UNRESOLVED Add Transaction Parameters in Autonomous Transactions    CORE-3708 UNRESOLVED Add actual configuration settings to the monitoring tables    CORE-4823 UNRESOLVED Add support for Hash/merge algorithms for outer joins    CORE-4402 UNRESOLVED Add timing statistics to the monitoring tables    CORE-5239 UNRESOLVED Add virtual table SEC$ROLES to return all roles currently active for the connected user    CORE-2021 UNRESOLVED Built-in replication    CORE-1082 UNRESOLVED Improve the statistics engine allowing auto-updating and gatherig more statistic data.    CORE-4481 UNRESOLVED Local database mode parameters are ignored    CORE-4401 UNRESOLVED Optimize the record-level RLE algorithm for a denser compression of shorter-than-declared strings and sets of subsequent NULLs    CORE-809 UNRESOLVED Remove context limit for stored procedures / triggers    CORE-2992 UNRESOLVED Shorten backup/restore duration    CORE-1686 UNRESOLVED Support value distribution histograms    CORE-3435 UNRESOLVED Lateral derived tables    CORE-909 UNRESOLVED Ability to retrieve Server Current UTC/GMT Timestamp    CORE-4726 UNRESOLVED Provide ability to do: REcreate user <user_name> password <user_pwd>    CORE-5118 FIXED Indices on computed fields are broken after restore (all keys are NULL)    CORE-5982 FIXED error read permission for BLOB field, when it is input/output procedure`s parametr    CORE-5686 FIXED Firebird 3.0.2 allows any protocol version >= 10 to connect, including interbase protocol 14    CORE-5600 FIXED Invalid blob id when add a new blob column of type text and update another field    CORE-5702 FIXED Firebird Handle Leak Windows    CORE-5844 FIXED Firebird freeze for new connections    CORE-5830 FIXED Encryption Interface crashing Firebird process when working on big db file (6.7GB)    CORE-5943 FIXED Server crashes preparing a query with both DISTINCT/ORDER BY and non-field expression in the select list    CORE-5757 FIXED deadlock with events    CORE-5712 FIXED Access to the name of DB encryption key    CORE-5601 FIXED CORE-5536 Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call    CORE-5800 FIXED After backup/restore the indexes by expression on computed field are not working properly.    CORE-5887 FIXED Allow the use of management statements in PSQL blocks    CORE-5674 FIXED Allow unused Common Table Expressions    CORE-5819 FIXED Attachment might not gone after it was DELETEd FROM MON$ATTACHMENTS    CORE-1662 FIXED CORE-5808 Compress backup on the fly    CORE-5730 FIXED Connection to server may hang when working with encrypted databases over non-TCP protocol    CORE-5970 FIXED Crypto functions in firebird    CORE-5872 FIXED Database validation reports false errors "Record XXX has bad transaction" and\or "Record XXX is wrong length" when record transaction number is greater than 2^32    CORE-5750 FIXED Date-time parsing is very weak    CORE-5879 FIXED Error reading/writing data to connection    CORE-5793 FIXED Error returned from DbCryptPlugin::setKey() is not shown    CORE-5972 FIXED External engine trigger crashing server if table have computed field    CORE-5980 FIXED Firebird 2.5.6 & 25.8 server crash    CORE-5959 FIXED Firebird returns wrong time after changes of time zone    CORE-5861 FIXED GRANT OPTION is not checked for new object    CORE-5954 FIXED Garbage collection in intermediate record versions    CORE-5612 FIXED Gradual slowdown compilation (create, recreate or drop) of views    CORE-5973 FIXED Handling FP overflow in double precision value when converting from decfloat.    CORE-5851 FIXED Incomplete fix for CORE-5779 - missing builds/posix/prefix.linux_riscv64    CORE-5986 FIXED Incorrect evaluation of NULL IS [NOT] {FALSE | TRUE}    CORE-5721 FIXED Information items isc_info_length and fb_info_crypt_state have same code    CORE-5891 FIXED Invalid events are released in mapping shared memory when dead process is detected    CORE-5855 FIXED Latest builds of Firebird 4.0 cannot backup DB with generators which contains space in the names    CORE-5900 FIXED Login attempts while engine is shutting down caused unnecessary delays in shutdown process    CORE-5948 FIXED Make WIN_SSPI plugin produce keys for wirecrypt plugin    CORE-5928 FIXED Make it possible for AuthClient plugin to access authentication block from DPB.    CORE-5639 FIXED Mapping rule using WIN_SSPI plugin: windows user group conversion to firebird role does not work    CORE-5899 FIXED Memory leak in GBAK code when used as service    CORE-5918 FIXED Memory pool statistics is not accurate    CORE-5804 FIXED Multiple error in REVOKE operator    CORE-5896 FIXED NOT NULL constraint is not synchronized after rename column    CORE-5886 FIXED Nbackup does not work after 32K of backups iterations    CORE-5881 FIXED Network server ignores any error that took place in KeyHolderPlugin when establishing initial callback with client    CORE-5755 FIXED No error if the GRANT target object does not exist    CORE-5614 FIXED Physical backup merge stage could run too long, especially with huge page cache    CORE-5651 FIXED Problem migrating users to V3.0    CORE-5788 FIXED Proposed Security Patch: Replacement of use of SHA-1 in the SRP Client Proof with SHA-256    CORE-5610 FIXED Provide info about database (or alias) which was in use during "Error during sweep: connection shutdown"    CORE-5921 FIXED Provide information about Global Commit Number, Commit Number of currently used database snapshot (if any) and Commit Numbers assigned to the committed transactions    CORE-5907 FIXED Regression: can not launch trace if its 'database' section contains regexp pattern with curvy brackets to enclose quantifier    CORE-5717 FIXED Reject non-constant date/time/timestamp literals    CORE-5746 FIXED CORE-5612 Remove the restriction on create/delete, enable/disable the user indexes in system tables    CORE-2440 FIXED Restoring DB with computed index on computed field provides wrong index and wrong select results    CORE-5547 FIXED Server crashes while compiling stored procedure with nested references to query-based computed fields    CORE-5760 FIXED Server process crashes while restoring database    CORE-5883 FIXED Services version 1 cleanup    CORE-5685 FIXED Sometime it is impossible to cancel\kill connection executing external query    CORE-5953 FIXED Statement level read consistency in read-committed transactions    CORE-5860 FIXED Support auth_plugin_list dpb/spb item from application to client    CORE-5808 FIXED Support backup of encrypted databases    CORE-694 FIXED Support for time zones    CORE-5706 FIXED Trace config with misplaced "{" lead firebird to crash    CORE-5880 FIXED Unhandled: C0000005.ACCESS_VIOLATION    CORE-5673 FIXED Unique constraint not working in encrypted database on first command    CORE-5927 FIXED With some non-standard authentication plugins providing correct crypt key wire anyway remains not encrypted    CORE-5645 FIXED Wrong transaction can be passed to external engine    CORE-5436 FIXED [FB3 SC] Server hangs (under load test)    CORE-5893 FIXED gbak may crash database when mixing alias with full database name    CORE-5829 FIXED gsec does not release user manager plugin    CORE-5796 FIXED gstat may produce faulty report about presence of some none-encrypted pages in database    CORE-5989 FIXED iconv / libiconv 1.15 vs libc / libiconv_open | common/isc_file.cpp    CORE-5930 FIXED internal Firebird consistency check (Incorrect snapshot deallocation - too few slots)    CORE-5776 FIXED "Input parameter mismatch" error after altering external function into PSQL function    CORE-5754 FIXED ALTER TRIGGER check privilege for alter database instead of table    CORE-5681 FIXED AV when external statement is executed and local transaction is rolled back    CORE-5620 FIXED Add builtin functions FIRST_DAY and LAST_DAY    CORE-5913 FIXED CORE-5536 Add context variables with compression and encryption status of current connection    CORE-5779 FIXED Add support for riscv64    CORE-5735 FIXED Additional keyholder opens unauthorized connections to encrypted database    CORE-2502 FIXED Aliases and error about cyclic dependencies in CTE    CORE-5865 FIXED Alignment error on x86_64    CORE-1592 FIXED Altering procedure parameters can lead to unrestorable database    CORE-5904 FIXED An attempt to create global mapping with long (> SQL identifier length) FROM field fails    CORE-5926 FIXED Attempt to create mapping with non-ascii user name which is encoded in SINGLE-BYTE codepage (win 1251) leads to '-Malformed string' message.    CORE-5704 FIXED Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible    CORE-5648 FIXED Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation    CORE-5659 FIXED Bad PLAN generated for query on Firebird v3.0    CORE-5846 FIXED CREATE VIEW issues "Implementation of text subtype 512 not located"    CORE-5630 FIXED Can't create the shadow file.    CORE-5863 FIXED Classic process crashes when client disconnected    CORE-5822 FIXED Client gets SQLSTATE = 28000 ("user/password not defined") if WireCrypt = Disabled is used on client side. Rather error SQLSTATE = 08006 ("Error occurred... check server firebird.log") should be raised    CORE-5772 FIXED CORE-5757 Client hangs when working with events under high load    CORE-5070 FIXED Compound index cannot be used for filtering in some ORDER/GROUP BY queries    CORE-5911 FIXED Connection could hung after no activity for 60 seconds    CORE-5536 FIXED Connections compressed and encrypted in MON$ATTACHMENTS table    CORE-5833 FIXED DDL triggers for some object types (views, exceptions, roles, indexes, domains) are lost in backup-restore process    CORE-5699 FIXED DECFLOAT should not throw exceptions when +/-NaN, +/-sNaN and +/-Infinity is used in comparisons    CORE-5700 FIXED DECFLOAT underflow should yield zero instead of an error    CORE-5769 FIXED Database crypt plugin sample on Pascal is broken    CORE-5710 FIXED Datatype declaration DECFLOAT without precision should use a default precision    CORE-5950 FIXED Deadlock when attaching to bugchecked database    CORE-5677 FIXED Dirty RDB$PAGES after an error after phase 3 of create_relation    CORE-5694 FIXED Duplicate values in columns with a unique constraint    CORE-5908 FIXED Enhance dynamic libraries loading related error messages    CORE-4409 FIXED Enhancement in precision of calculations with NUMERIC/DECIMAL    CORE-5598 FIXED Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan    CORE-3295 FIXED Estimate the actual record compression ratio in the optimizer    CORE-5719 FIXED FB >= 3 crashes when restoring backup made by FB 2.5.    CORE-5965 FIXED FB3 Optimiser chooses less efficient plan than FB2.5 optimiser    CORE-5713 FIXED Field alias disapears in complex query    CORE-5728 FIXED Field subtype of DEC_FIXED columns not returned by isc_info_sql_sub_type    CORE-5615 FIXED Firebird 3 crashing randomly    CORE-405 FIXED Garbage vs indices/constraints    CORE-5611 FIXED Higher memory consumption for prepared statements    CORE-5840 FIXED Ignor of reference privilege    CORE-5768 FIXED Implement FILTER-clause for aggregate functions    CORE-5905 FIXED Inconsistencies with PSQL FUNCTION vs UDF    CORE-5837 FIXED Inconsistent results when working with GLOBAL TEMPORARY TABLE ON COMMIT PRESERVE ROWS    CORE-5871 FIXED Incorrect caching of the subquery result (procedure call) in independent queries    CORE-5742 FIXED Incorrect error message in iSQL when trying to create database with wrong password    CORE-5884 FIXED Initial global mapping from srp plugin does not work    CORE-5764 FIXED Installation of Firebird 3.0.3 on SLES 12 SP3 fails with ''Could not find acceptable ICU library"    CORE-5395 FIXED Invalid data type for negation (minus operator)    CORE-5737 FIXED Invalid parameters of gds transaction in ISQL    CORE-5718 FIXED Make TempCacheLimit setting database-wise    CORE-5727 FIXED Make faster engine response on cancel\shutdown signals when scanning long list of pointer pages    CORE-5660 FIXED Make flush of big number of dirty pages faster    CORE-5643 FIXED Message "Operating system call munmap failed. Error code 12" can appear in firebird.log under heavy load (2.5.x, CS, SC)    CORE-5654 FIXED Mixed intermediate build files for plugins examples    CORE-5791 FIXED ODS for windows builds and linux-x64 (on the one side) and linux-x86 (on the other side) does not match    CORE-4492 FIXED OR/IN predicates for RDB$DBKEY lead to NATURAL plan    CORE-5795 FIXED ORDER BY clause on compound index may disable usage of other indices    CORE-5845 FIXED ORDER BY on index can cause suboptimal index choices    CORE-5773 FIXED PSQL cursor doesn't see inserted record    CORE-5646 FIXED Parse error when compiling a statement causes memory leak until attachment is disconnected    CORE-5753 FIXED Parser should not allow to use GRANT OPTION for FUNCTION and PACKAGE    CORE-5618 FIXED Part of the pages of the second level blobs is not released when deleting relations.    CORE-5695 FIXED Position function does not consider the collation for blob    CORE-5876 FIXED Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"    CORE-5898 FIXED ROLE not passed in EXECUTE STATEMENT ... ON EXTERNAL    CORE-5667 FIXED 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-5756 FIXED Regression: FB crashes when trying to recreate table that is in use by DML (3.0.3; 3.0.4; 4.0.0)    CORE-5480 FIXED SUBSTRING startposition smaller than 1 should be allowed    CORE-5650 FIXED Segfault when procedure dropped on classic server    CORE-5824 FIXED Segmentation fault during install on Linux    CORE-5815 FIXED Server hangs for 60/120 seconds if client exits during database encryption key transfer callback    CORE-5780 FIXED Server hangs when client tries to send too long DB encryption key(s)    CORE-5613 FIXED SuperServer could hung when changing physical backup state under high load    CORE-5720 FIXED Sweep in Firebird 3 in CS mode could run too slow when there is big load on server    CORE-5852 FIXED There is no check of existance generator and exception when privileges are granted    CORE-5817 FIXED Unable to compile Firebird with ICU 60 or higer    CORE-5955 FIXED Unable to init binreloc with ld >= 2.31    CORE-5726 FIXED Unclear error message when inserting value exceeding max of dec_fixed decimal    CORE-5747 FIXED User can grant usage privilege by himself    CORE-5790 FIXED User with DROP DATABASE privilege can't drop database    CORE-5862 FIXED Varchar computed column without explicit type does not populate RDB$CHARACTER_LENGTH    CORE-5657 FIXED Various UDF-related security vulnerabilities    CORE-5703 FIXED When database validation fixes "orphan page" errors it also should adjust "lowest free page" marker (pip_min) on corresponding PIP, if necessary    CORE-5843 FIXED Wrong handling of failures of TRANSACTION START trigger    CORE-5974 FIXED Wrong result of select distinct with decfload/timezone/collated column    CORE-5638 FIXED Wrong result with index on case-insensitive collation using NUMERIC-SORT    CORE-5762 FIXED Wrong transaction number in RDB$PAGES relation may cause infinite recusrion in engine and segfault    CORE-5783 FIXED execute statement ignores the text of the SQL-query after a comment of the form "-"    CORE-5653 FIXED gbak restore with large number of small blobs very slow using Linux Classic    CORE-5934 FIXED gpre_boot fails to link using cmake, undefined reference 'dladdr' and 'dlerror'    CORE-5649 FIXED isc_add_user / isc_modify_user produce unusable user record    CORE-5655 FIXED isc_info_sql_relation_alias reports incorrect alias for CTE or nested queries    CORE-5841 FIXED no permission for SELECT access to TABLE PLG$SRP in newer snapshot    CORE-5637 FIXED string right truncation on restore of security db    CORE-2284 DUPLICATE Records left in RDB$PAGES after rollback of CREATE TABLE statement    CORE-5870 FIXED ISQL's "show database" command works wrong with 64-bit numbers    CORE-5831 FIXED Not user friendly output of gstat at encrypted database    CORE-3808 FIXED Provide ability to return all columns using RETURNING (eg RETURNING *)    CORE-5705 FIXED Store precision of DECFLOAT in RDB$FIELDS    CORE-5593 FIXED System function RDB$ROLE_IN_USE cannot take long role names    CORE-5778 FIXED install.sh fails if -path argument contains "firebird"    CORE-5624 FIXED using backslash in alias on linux does not work    CORE-5847 FIXED "Malformed string" instead of key value in PK violation error message    CORE-5724 FIXED Add ability to use "install.sh -path /opt/my_path" without need to install FB first in the default folder ("/opt/firebird")    CORE-5606 FIXED Add expression index name to exception message if computation failed    CORE-4529 FIXED Allow to use index when GROUP BY on field which has DESCENDING index    CORE-5676 FIXED Consider equivalence classes for index navigation    CORE-5684 FIXED Error "no current record for fetch operation" is raised while deleting record from MON$ATTACHMENTS using ORDER BY clause    CORE-5605 FIXED Incorrect check for existing MAP in a case when pre-FB3 security database is used    CORE-5647 FIXED Increase number of formats/versions of views from 255 to 32K    CORE-5765 FIXED Missing directives in Firebird.pas    CORE-5874 FIXED Provide name of read-only column incorrectly referenced in UPDATE ... SET xxx    CORE-4964 FIXED Real errors during connect to security database are hidden by Srp user manager. Errors should be logged no matter what AuthServer is used.    CORE-5770 FIXED User who is allowed to manage other users must have this ability WITHOUT need to grant him RDB$ADMIN role (which is related to admin tasks in "main" database rather than in security_db)    CORE-5629 FIXED gstat output does not include datetime of analysis    CORE-5675 FIXED isc_vax_integer() and isc_portable_integer() work wrongly with short negative numbers    CORE-5741 FIXED Word "fixing" in gbak output is too scary 2.5.9 ( Release Notes ) Progress:    20 of 20 issues have been resolved Maintenance release    CORE-5118 FIXED Indices on computed fields are broken after restore (all keys are NULL)    CORE-5943 FIXED Server crashes preparing a query with both DISTINCT/ORDER BY and non-field expression in the select list    CORE-5757 FIXED deadlock with events    CORE-5800 FIXED After backup/restore the indexes by expression on computed field are not working properly.    CORE-5935 FIXED Bugcheck 165 (cannot find tip page)    CORE-5980 FIXED Firebird 2.5.6 & 25.8 server crash    CORE-5936 FIXED Firebird server segfaults in the end of database backup    CORE-5853 FIXED Forward-compatible expressions LOCALTIME and LOCALTIMESTAMP    CORE-5014 FIXED Interrupt of aux connection during TCP setup phase causes unclear error messages in firebird.log    CORE-5017 FIXED Interrupt of aux connection during TCP setup phase causes server exit due to unhandled exception    CORE-2440 FIXED Restoring DB with computed index on computed field provides wrong index and wrong select results    CORE-5685 FIXED Sometime it is impossible to cancel\kill connection executing external query    CORE-4565 FIXED GDSCODE can have value = 0 in WHEN-section under some concurrent env., only in SC or CS (not in SS)    CORE-5434 FIXED Read-only transactions in SuperServer could avoid immediate write of Header and TIP pages after change    CORE-5910 FIXED Server crash after kill in EDS manager destructor    CORE-5762 FIXED Wrong transaction number in RDB$PAGES relation may cause infinite recusrion in engine and segfault    CORE-5868 FIXED fbintl exports internal functions on darwin    CORE-2493 FIXED Append the IP address of the remote host to error messages in firebird.log for TCP connections    CORE-5939 FIXED Crash for "gbak -se -b database nul"    CORE-5847 FIXED "Malformed string" instead of key value in PK violation error message 3.0.5 ( Release Notes ) Progress:    29 of 30 issues have been resolved Maintenance release    CORE-5966 UNRESOLVED Slow performance when executing SQL scripts as non-SYSDBA user    CORE-5118 FIXED Indices on computed fields are broken after restore (all keys are NULL)    CORE-5982 FIXED error read permission for BLOB field, when it is input/output procedure`s parametr    CORE-5943 FIXED Server crashes preparing a query with both DISTINCT/ORDER BY and non-field expression in the select list    CORE-5800 FIXED After backup/restore the indexes by expression on computed field are not working properly.    CORE-5935 FIXED Bugcheck 165 (cannot find tip page)    CORE-5980 FIXED Firebird 2.5.6 & 25.8 server crash    CORE-5959 FIXED Firebird returns wrong time after changes of time zone    CORE-5936 FIXED Firebird server segfaults in the end of database backup    CORE-5986 FIXED Incorrect evaluation of NULL IS [NOT] {FALSE | TRUE}    CORE-5948 FIXED Make WIN_SSPI plugin produce keys for wirecrypt plugin    CORE-5928 FIXED Make it possible for AuthClient plugin to access authentication block from DPB.    CORE-5639 FIXED Mapping rule using WIN_SSPI plugin: windows user group conversion to firebird role does not work    CORE-5918 FIXED Memory pool statistics is not accurate    CORE-5907 FIXED Regression: can not launch trace if its 'database' section contains regexp pattern with curvy brackets to enclose quantifier    CORE-2440 FIXED Restoring DB with computed index on computed field provides wrong index and wrong select results    CORE-5927 FIXED With some non-standard authentication plugins providing correct crypt key wire anyway remains not encrypted    CORE-5989 FIXED iconv / libiconv 1.15 vs libc / libiconv_open | common/isc_file.cpp    CORE-5926 FIXED Attempt to create mapping with non-ascii user name which is encoded in SINGLE-BYTE codepage (win 1251) leads to '-Malformed string' message.    CORE-5070 FIXED Compound index cannot be used for filtering in some ORDER/GROUP BY queries    CORE-5950 FIXED Deadlock when attaching to bugchecked database    CORE-5965 FIXED FB3 Optimiser chooses less efficient plan than FB2.5 optimiser    CORE-5395 FIXED Invalid data type for negation (minus operator)    CORE-5823 FIXED No permission for SELECT access to blob field in stored procedure.    CORE-5795 FIXED ORDER BY clause on compound index may disable usage of other indices    CORE-5845 FIXED ORDER BY on index can cause suboptimal index choices    CORE-5955 FIXED Unable to init binreloc with ld >= 2.31    CORE-5934 FIXED gpre_boot fails to link using cmake, undefined reference 'dladdr' and 'dlerror'    CORE-5724 FIXED Add ability to use "install.sh -path /opt/my_path" without need to install FB first in the default folder ("/opt/firebird")    CORE-5741 FIXED Word "fixing" in gbak output is too scary

Reports

Preset Filters

Project Summary

	Open	1304	22%
	In Progress	3
	Reopened	27
	Resolved	458	8%
	Closed	4007	69%

Open Issues

	Blocker	8	1%
	Critical	43	3%
	Major	854	64%
	Minor	369	28%
	Trivial	60	4%

By Assignee

Adriano dos Santos Fernandes	24	2%
Alexander Peshkov	47	4%
Claudio Valderrama C.	3
Dmitry Yemanov	80	6%
Michal Kubeček	1
Paul Reeves	14	1%
Roman Simakov	3
Vlad Khorsun	71	5%
Unassigned	1091	82%