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:    172 of 189 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-694 UNRESOLVED Support for time zones    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-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-5943 FIXED Server crashes preparing a query with both DISTINCT/ORDER BY and non-field expression in the select list    CORE-5830 FIXED Encryption Interface crashing Firebird process when working on big db file (6.7GB)    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-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-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-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-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-5950 FIXED Deadlock when attaching to bugchecked database    CORE-5879 FIXED Error reading/writing data to connection    CORE-5793 FIXED Error returned from DbCryptPlugin::setKey() is not shown    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-5768 FIXED Implement FILTER-clause for aggregate functions    CORE-5851 FIXED Incomplete fix for CORE-5779 - missing builds/posix/prefix.linux_riscv64    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-5746 FIXED CORE-5612 Remove the restriction on create/delete, enable/disable the user indexes in system tables    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-5706 FIXED Trace config with misplaced "{" lead firebird to crash    CORE-5955 FIXED Unable to init binreloc with ld >= 2.31    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-5934 FIXED gpre_boot fails to link using cmake, undefined reference 'dladdr' and 'dlerror'    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-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-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-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-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-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-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-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-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-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-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-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-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-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:    15 of 15 issues have been resolved Maintenance release    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-5935 FIXED Bugcheck 165 (cannot find tip page)    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-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-5847 FIXED "Malformed string" instead of key value in PK violation error message 3.0.5 ( Release Notes ) Progress:    16 of 16 issues have been resolved Maintenance release    CORE-5943 FIXED Server crashes preparing a query with both DISTINCT/ORDER BY and non-field expression in the select list    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-5935 FIXED Bugcheck 165 (cannot find tip page)    CORE-5950 FIXED Deadlock when attaching to bugchecked database    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-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-5823 FIXED No permission for SELECT access to blob field in stored procedure.    CORE-5907 FIXED Regression: can not launch trace if its 'database' section contains regexp pattern with curvy brackets to enclose quantifier    CORE-5955 FIXED Unable to init binreloc with ld >= 2.31    CORE-5927 FIXED With some non-standard authentication plugins providing correct crypt key wire anyway remains not encrypted    CORE-5934 FIXED gpre_boot fails to link using cmake, undefined reference 'dladdr' and 'dlerror'    CORE-5741 FIXED Word "fixing" in gbak output is too scary

Reports

Preset Filters

Project Summary

	Open	1311	23%
	In Progress	3
	Reopened	28
	Resolved	450	8%
	Closed	3985	69%

Open Issues

	Blocker	9	1%
	Critical	42	3%
	Major	860	64%
	Minor	373	28%
	Trivial	58	4%

By Assignee

Adriano dos Santos Fernandes	28	2%
Alexander Peshkov	48	4%
Claudio Valderrama C.	3
Dmitry Yemanov	84	6%
Michal Kubeček	1
Paul Reeves	14	1%
Roman Simakov	2
Vlad Khorsun	72	5%
Unassigned	1090	81%