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:    108 of 125 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 timezones with timestamp    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-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-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-5721 FIXED Information items isc_info_length and fb_info_crypt_state have same code    CORE-5804 FIXED Multiple error in REVOKE operator    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-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-5610 FIXED Provide info about database (or alias) which was in use during "Error during sweep: connection shutdown"    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-5685 FIXED Sometime it is impossible to cancel\kill connection executing external query    CORE-5808 FIXED Support backup of encrypted databases    CORE-5706 FIXED Trace config with misplaced "{" lead firebird to crash    CORE-5673 FIXED Unique constraint not working in encrypted database on first command    CORE-5645 FIXED Wrong transaction can be passed to external engine    CORE-5436 FIXED [FB3 SC] Server hangs (under load test)    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-820 FIXED isc_dsql_exec* should allow list of parameter sets    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-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-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-5630 FIXED Can't create the shadow file.    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-5536 FIXED Connections compressed and encrypted in MON$ATTACHMENTS table    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-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-5742 FIXED Incorrect error message in iSQL when trying to create database with wrong password    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-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-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-5817 FIXED Unable to compile Firebird with ICU 60 or higer    CORE-5790 FIXED User with DROP DATABASE privilege can't drop database    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-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-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-5831 FIXED Not user friendly output of gstat at encrypted database    CORE-5705 FIXED Store precision of DECFLOAT in RDB$FIELDS    CORE-5778 FIXED install.sh fails if -path argument contains "firebird"    CORE-5624 FIXED using backslash in alias on linux does not work    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-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 3.0.4 ( Release Notes ) Progress:    35 of 35 issues have been resolved Maintenance release    CORE-5702 FIXED Firebird Handle Leak Windows    CORE-5830 FIXED Encryption Interface crashing Firebird process when working on big db file (6.7GB)    CORE-5757 FIXED deadlock with events    CORE-5819 FIXED Attachment might not gone after it was DELETEd FROM MON$ATTACHMENTS    CORE-5745 FIXED GRANT privileges error during database restore    CORE-5804 FIXED Multiple error in REVOKE operator    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-5746 FIXED CORE-5612 Remove the restriction on create/delete, enable/disable the user indexes in system tables    CORE-5760 FIXED Server process crashes while restoring database    CORE-5436 FIXED [FB3 SC] Server hangs (under load test)    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-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-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-5743 FIXED Conversion error when both GROUP/ORDER BY expressions and WHERE expressions contain literals    CORE-5769 FIXED Database crypt plugin sample on Pascal is broken    CORE-405 FIXED Garbage vs indices/constraints    CORE-5742 FIXED Incorrect error message in iSQL when trying to create database with wrong password    CORE-5737 FIXED Invalid parameters of gds transaction in ISQL    CORE-5773 FIXED PSQL cursor doesn't see inserted record    CORE-5753 FIXED Parser should not allow to use GRANT OPTION for FUNCTION and PACKAGE    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-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-5817 FIXED Unable to compile Firebird with ICU 60 or higer    CORE-5790 FIXED User with DROP DATABASE privilege can't drop database    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-5831 FIXED Not user friendly output of gstat at encrypted database    CORE-5778 FIXED install.sh fails if -path argument contains "firebird"    CORE-5765 FIXED Missing directives in Firebird.pas    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. 2.5.9 ( Release Notes ) Progress:    7 of 7 issues have been resolved Maintenance release    CORE-5757 FIXED deadlock with events    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-5762 FIXED Wrong transaction number in RDB$PAGES relation may cause infinite recusrion in engine and segfault    CORE-2493 FIXED Append the IP address of the remote host to error messages in firebird.log for TCP connections

Reports

Preset Filters

Project Summary

	Open	1283	23%
	In Progress	3
	Reopened	28
	Resolved	407	7%
	Closed	3929	70%

Open Issues

	Blocker	9	1%
	Critical	39	3%
	Major	843	64%
	Minor	366	28%
	Trivial	57	4%

By Assignee

Adriano dos Santos Fernandes	37	3%
Alexander Peshkov	52	4%
Claudio Valderrama C.	3
Dmitriy Starodubov	1
Dmitry Yemanov	84	6%
Michal Kubeček	1
Paul Reeves	14	1%
Roman Simakov	1
Vlad Khorsun	68	5%
Unassigned	1053	80%