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

 Select:   Open Issues   Road Map   Change Log   Popular Issues   Subversion Commits   Versions   Components   

Road Map

Progress: 
  108 of 125 issues have been resolved
Beta Release
   New Feature CORE-2479 UNRESOLVED Add TRUNCATE TABLE Major Open
   Improvement CORE-4017 UNRESOLVED Add Transaction Parameters in Autonomous Transactions Major Open
   Improvement CORE-3708 UNRESOLVED Add actual configuration settings to the monitoring tables Major Open
   Improvement CORE-4823 UNRESOLVED Add support for Hash/merge algorithms for outer joins Major Open
   Improvement CORE-4402 UNRESOLVED Add timing statistics to the monitoring tables Major Open
   Improvement CORE-5239 UNRESOLVED Add virtual table SEC$ROLES to return all roles currently active for the connected user Major Open
   New Feature CORE-2021 UNRESOLVED Built-in replication Major Open
   Improvement CORE-1082 UNRESOLVED Improve the statistics engine allowing auto-updating and gatherig more statistic data. Major Open
   Bug CORE-4481 UNRESOLVED Local database mode parameters are ignored Major Open
   Improvement CORE-4401 UNRESOLVED Optimize the record-level RLE algorithm for a denser compression of shorter-than-declared strings and sets of subsequent NULLs Major Open
   Improvement CORE-809 UNRESOLVED Remove context limit for stored procedures / triggers Major Open
   Improvement CORE-2992 UNRESOLVED Shorten backup/restore duration Major Open
   New Feature CORE-694 UNRESOLVED Support timezones with timestamp Major Open
   New Feature CORE-1686 UNRESOLVED Support value distribution histograms Major Open
   New Feature CORE-3435 UNRESOLVED Lateral derived tables Major Reopened
   New Feature CORE-909 UNRESOLVED Ability to retrieve Server Current UTC/GMT Timestamp Minor Open
   Improvement CORE-4726 UNRESOLVED Provide ability to do: REcreate user <user_name> password <user_pwd> Minor Open
   Bug CORE-5686 FIXED Firebird 3.0.2 allows any protocol version >= 10 to connect, including interbase protocol 14 Blocker Closed
   Bug CORE-5600 FIXED Invalid blob id when add a new blob column of type text and update another field Blocker Closed
   Bug CORE-5702 FIXED Firebird Handle Leak Windows Critical Resolved
   Bug CORE-5830 FIXED Encryption Interface crashing Firebird process when working on big db file (6.7GB) Critical Closed
   Bug CORE-5757 FIXED deadlock with events Critical Closed
   Improvement CORE-5712 FIXED Access to the name of DB encryption key Major Resolved
   Sub-task CORE-5601 FIXED CORE-5536
Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call
Major Resolved
   Improvement CORE-5674 FIXED Allow unused Common Table Expressions Major Resolved
   Bug CORE-5819 FIXED Attachment might not gone after it was DELETEd FROM MON$ATTACHMENTS Major Resolved
   Sub-task CORE-1662 FIXED CORE-5808
Compress backup on the fly
Major Resolved
   Bug CORE-5730 FIXED Connection to server may hang when working with encrypted databases over non-TCP protocol Major Resolved
   Bug CORE-5721 FIXED Information items isc_info_length and fb_info_crypt_state have same code Major Resolved
   Bug CORE-5804 FIXED Multiple error in REVOKE operator Major Resolved
   Bug CORE-5791 FIXED ODS for windows builds and linux-x64 (on the one side) and linux-x86 (on the other side) does not match Major Resolved
   Improvement CORE-5614 FIXED Physical backup merge stage could run too long, especially with huge page cache Major Resolved
   Bug CORE-5651 FIXED Problem migrating users to V3.0 Major Resolved
   Improvement CORE-5610 FIXED Provide info about database (or alias) which was in use during "Error during sweep: connection shutdown" Major Resolved
   Sub-task CORE-5746 FIXED CORE-5612
Remove the restriction on create/delete, enable/disable the user indexes in system tables
Major Resolved
   Bug CORE-5547 FIXED Server crashes while compiling stored procedure with nested references to query-based computed fields Major Resolved
   Bug CORE-5760 FIXED Server process crashes while restoring database Major Resolved
   Bug CORE-5685 FIXED Sometime it is impossible to cancel\kill connection executing external query Major Resolved
   New Feature CORE-5808 FIXED Support backup of encrypted databases Major Resolved
   Bug CORE-5706 FIXED Trace config with misplaced "{" lead firebird to crash Major Resolved
   Bug CORE-5673 FIXED Unique constraint not working in encrypted database on first command Major Resolved
   Bug CORE-5645 FIXED Wrong transaction can be passed to external engine Major Resolved
   Bug CORE-5436 FIXED [FB3 SC] Server hangs (under load test) Major Resolved
   Bug CORE-5829 FIXED gsec does not release user manager plugin Major Resolved
   Bug CORE-5796 FIXED gstat may produce faulty report about presence of some none-encrypted pages in database Major Resolved
   New Feature CORE-820 FIXED isc_dsql_exec* should allow list of parameter sets Major Resolved
   Bug CORE-5776 FIXED "Input parameter mismatch" error after altering external function into PSQL function Major Closed
   Bug CORE-5754 FIXED ALTER TRIGGER check privilege for alter database instead of table Major Closed
   Bug CORE-5681 FIXED AV when external statement is executed and local transaction is rolled back Major Closed
   New Feature CORE-5620 FIXED Add builtin functions FIRST_DAY and LAST_DAY Major Closed
   Improvement CORE-5779 FIXED Add support for riscv64 Major Closed
   Bug CORE-5735 FIXED Additional keyholder opens unauthorized connections to encrypted database Major Closed
   Bug CORE-2502 FIXED Aliases and error about cyclic dependencies in CTE Major Closed
   Improvement CORE-5704 FIXED Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible Major Closed
   Improvement CORE-5648 FIXED Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation Major Closed
   Bug CORE-5659 FIXED Bad PLAN generated for query on Firebird v3.0 Major Closed
   Bug CORE-5630 FIXED Can't create the shadow file. Major Closed
   Bug 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 Major Closed
   Sub-task CORE-5772 FIXED CORE-5757
Client hangs when working with events under high load
Major Closed
   New Feature CORE-5536 FIXED Connections compressed and encrypted in MON$ATTACHMENTS table Major Closed
   Bug CORE-5699 FIXED DECFLOAT should not throw exceptions when +/-NaN, +/-sNaN and +/-Infinity is used in comparisons Major Closed
   Bug CORE-5700 FIXED DECFLOAT underflow should yield zero instead of an error Major Closed
   Bug CORE-5769 FIXED Database crypt plugin sample on Pascal is broken Major Closed
   Bug CORE-5710 FIXED Datatype declaration DECFLOAT without precision should use a default precision Major Closed
   Bug CORE-5677 FIXED Dirty RDB$PAGES after an error after phase 3 of create_relation Major Closed
   Bug CORE-5694 FIXED Duplicate values in columns with a unique constraint Major Closed
   Improvement CORE-4409 FIXED Enhancement in precision of calculations with NUMERIC/DECIMAL Major Closed
   Bug CORE-5598 FIXED Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan Major Closed
   Improvement CORE-3295 FIXED Estimate the actual record compression ratio in the optimizer Major Closed
   Bug CORE-5719 FIXED FB >= 3 crashes when restoring backup made by FB 2.5. Major Closed
   Bug CORE-5713 FIXED Field alias disapears in complex query Major Closed
   Bug CORE-5728 FIXED Field subtype of DEC_FIXED columns not returned by isc_info_sql_sub_type Major Closed
   Bug CORE-5615 FIXED Firebird 3 crashing randomly Major Closed
   Bug CORE-405 FIXED Garbage vs indices/constraints Major Closed
   Bug CORE-5611 FIXED Higher memory consumption for prepared statements Major Closed
   Bug CORE-5742 FIXED Incorrect error message in iSQL when trying to create database with wrong password Major Closed
   Bug CORE-5737 FIXED Invalid parameters of gds transaction in ISQL Major Closed
   Improvement CORE-5718 FIXED Make TempCacheLimit setting database-wise Major Closed
   Improvement CORE-5727 FIXED Make faster engine response on cancel\shutdown signals when scanning long list of pointer pages Major Closed
   Improvement CORE-5660 FIXED Make flush of big number of dirty pages faster Major Closed
   Bug 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) Major Closed
   Bug CORE-5654 FIXED Mixed intermediate build files for plugins examples Major Closed
   Bug CORE-4492 FIXED OR/IN predicates for RDB$DBKEY lead to NATURAL plan Major Closed
   Bug CORE-5773 FIXED PSQL cursor doesn't see inserted record Major Closed
   Bug CORE-5646 FIXED Parse error when compiling a statement causes memory leak until attachment is disconnected Major Closed
   Bug CORE-5753 FIXED Parser should not allow to use GRANT OPTION for FUNCTION and PACKAGE Major Closed
   Bug CORE-5618 FIXED Part of the pages of the second level blobs is not released when deleting relations. Major Closed
   Bug CORE-5695 FIXED Position function does not consider the collation for blob Major Closed
   Bug 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 Major Closed
   Bug 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) Major Closed
   Bug CORE-5480 FIXED SUBSTRING startposition smaller than 1 should be allowed Major Closed
   Bug CORE-5650 FIXED Segfault when procedure dropped on classic server Major Closed
   Bug CORE-5824 FIXED Segmentation fault during install on Linux Major Closed
   Bug CORE-5815 FIXED Server hangs for 60/120 seconds if client exits during database encryption key transfer callback Major Closed
   Bug CORE-5780 FIXED Server hangs when client tries to send too long DB encryption key(s) Major Closed
   Bug CORE-5613 FIXED SuperServer could hung when changing physical backup state under high load Major Closed
   Bug CORE-5720 FIXED Sweep in Firebird 3 in CS mode could run too slow when there is big load on server Major Closed
   Bug CORE-5817 FIXED Unable to compile Firebird with ICU 60 or higer Major Closed
   Bug CORE-5790 FIXED User with DROP DATABASE privilege can't drop database Major Closed
   Bug CORE-5657 FIXED Various UDF-related security vulnerabilities Major Closed
   Improvement 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 Major Closed
   Bug CORE-5638 FIXED Wrong result with index on case-insensitive collation using NUMERIC-SORT Major Closed
   Bug CORE-5762 FIXED Wrong transaction number in RDB$PAGES relation may cause infinite recusrion in engine and segfault Major Closed
   Bug CORE-5783 FIXED execute statement ignores the text of the SQL-query after a comment of the form "-" Major Closed
   Bug CORE-5653 FIXED gbak restore with large number of small blobs very slow using Linux Classic Major Closed
   Bug CORE-5649 FIXED isc_add_user / isc_modify_user produce unusable user record Major Closed
   Bug CORE-5655 FIXED isc_info_sql_relation_alias reports incorrect alias for CTE or nested queries Major Closed
   Bug CORE-5637 FIXED string right truncation on restore of security db Major Closed
   Bug CORE-2284 DUPLICATE Records left in RDB$PAGES after rollback of CREATE TABLE statement Major Closed
   Bug CORE-5831 FIXED Not user friendly output of gstat at encrypted database Minor Resolved
   Improvement CORE-5705 FIXED Store precision of DECFLOAT in RDB$FIELDS Minor Resolved
   Bug CORE-5778 FIXED install.sh fails if -path argument contains "firebird" Minor Resolved
   Bug CORE-5624 FIXED using backslash in alias on linux does not work Minor Resolved
   Improvement CORE-5606 FIXED Add expression index name to exception message if computation failed Minor Closed
   Improvement CORE-4529 FIXED Allow to use index when GROUP BY on field which has DESCENDING index Minor Closed
   Improvement CORE-5676 FIXED Consider equivalence classes for index navigation Minor Closed
   Bug CORE-5684 FIXED Error "no current record for fetch operation" is raised while deleting record from MON$ATTACHMENTS using ORDER BY clause Minor Closed
   Bug CORE-5605 FIXED Incorrect check for existing MAP in a case when pre-FB3 security database is used Minor Closed
   Improvement CORE-5647 FIXED Increase number of formats/versions of views from 255 to 32K Minor Closed
   Bug CORE-5765 FIXED Missing directives in Firebird.pas Minor Closed
   Bug 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. Minor Closed
   Improvement 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) Minor Closed
   Improvement CORE-5629 FIXED gstat output does not include datetime of analysis Minor Closed
   Bug CORE-5675 FIXED isc_vax_integer() and isc_portable_integer() work wrongly with short negative numbers Minor Closed
   Improvement CORE-5741 FIXED Word "fixing" in gbak output is too scary Trivial Resolved
Progress: 
  35 of 35 issues have been resolved
Maintenance release
   Bug CORE-5702 FIXED Firebird Handle Leak Windows Critical Resolved
   Bug CORE-5830 FIXED Encryption Interface crashing Firebird process when working on big db file (6.7GB) Critical Closed
   Bug CORE-5757 FIXED deadlock with events Critical Closed
   Bug CORE-5819 FIXED Attachment might not gone after it was DELETEd FROM MON$ATTACHMENTS Major Resolved
   Bug CORE-5745 FIXED GRANT privileges error during database restore Major Resolved
   Bug CORE-5804 FIXED Multiple error in REVOKE operator Major Resolved
   Bug CORE-5791 FIXED ODS for windows builds and linux-x64 (on the one side) and linux-x86 (on the other side) does not match Major Resolved
   Sub-task CORE-5746 FIXED CORE-5612
Remove the restriction on create/delete, enable/disable the user indexes in system tables
Major Resolved
   Bug CORE-5760 FIXED Server process crashes while restoring database Major Resolved
   Bug CORE-5436 FIXED [FB3 SC] Server hangs (under load test) Major Resolved
   Bug CORE-5829 FIXED gsec does not release user manager plugin Major Resolved
   Bug CORE-5796 FIXED gstat may produce faulty report about presence of some none-encrypted pages in database Major Resolved
   Bug CORE-5776 FIXED "Input parameter mismatch" error after altering external function into PSQL function Major Closed
   Bug CORE-5754 FIXED ALTER TRIGGER check privilege for alter database instead of table Major Closed
   Bug 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 Major Closed
   Sub-task CORE-5772 FIXED CORE-5757
Client hangs when working with events under high load
Major Closed
   Bug CORE-5743 FIXED Conversion error when both GROUP/ORDER BY expressions and WHERE expressions contain literals Major Closed
   Bug CORE-5769 FIXED Database crypt plugin sample on Pascal is broken Major Closed
   Bug CORE-405 FIXED Garbage vs indices/constraints Major Closed
   Bug CORE-5742 FIXED Incorrect error message in iSQL when trying to create database with wrong password Major Closed
   Bug CORE-5737 FIXED Invalid parameters of gds transaction in ISQL Major Closed
   Bug CORE-5773 FIXED PSQL cursor doesn't see inserted record Major Closed
   Bug CORE-5753 FIXED Parser should not allow to use GRANT OPTION for FUNCTION and PACKAGE Major Closed
   Bug 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) Major Closed
   Bug CORE-5824 FIXED Segmentation fault during install on Linux Major Closed
   Bug CORE-5815 FIXED Server hangs for 60/120 seconds if client exits during database encryption key transfer callback Major Closed
   Bug CORE-5780 FIXED Server hangs when client tries to send too long DB encryption key(s) Major Closed
   Bug CORE-5817 FIXED Unable to compile Firebird with ICU 60 or higer Major Closed
   Bug CORE-5790 FIXED User with DROP DATABASE privilege can't drop database Major Closed
   Bug CORE-5762 FIXED Wrong transaction number in RDB$PAGES relation may cause infinite recusrion in engine and segfault Major Closed
   Bug CORE-5783 FIXED execute statement ignores the text of the SQL-query after a comment of the form "-" Major Closed
   Bug CORE-5831 FIXED Not user friendly output of gstat at encrypted database Minor Resolved
   Bug CORE-5778 FIXED install.sh fails if -path argument contains "firebird" Minor Resolved
   Bug CORE-5765 FIXED Missing directives in Firebird.pas Minor Closed
   Bug 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. Minor Closed
Progress: 
  7 of 7 issues have been resolved
Maintenance release
   Bug CORE-5757 FIXED deadlock with events Critical Closed
   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-5685 FIXED Sometime it is impossible to cancel\kill connection executing external query Major Resolved
   Bug CORE-4565 FIXED GDSCODE can have value = 0 in WHEN-section under some concurrent env., only in SC or CS (not in SS) Major Closed
   Bug CORE-5762 FIXED Wrong transaction number in RDB$PAGES relation may cause infinite recusrion in engine and segfault 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

Reports

User Workload Report
Version Workload Report
Time Tracking Report
Single Level Group By Report

Preset Filters


Project Summary

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

Open Issues

By Priority
Blocker Blocker 9
   1%
Critical Critical 39
   3%
Major Major 843
   64%
Minor Minor 366
   28%
Trivial 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%