All Projects : Firebird Core (Key: CORE)

Project Lead: Dmitry Yemanov
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

  135 of 145 issues have been resolved
Alpha Release
   New Feature CORE-2021 UNRESOLVED Built-in replication Major Open
   Bug CORE-4481 UNRESOLVED Local database mode parameters are ignored Major Open
   Improvement CORE-2216 UNRESOLVED Nbackup as online dump 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
   New Feature CORE-2990 UNRESOLVED Physical (page-level) standby replication / page shipping Major Open
   New Feature CORE-658 UNRESOLVED Query timeout on the server Major Open
   Improvement CORE-809 UNRESOLVED Remove context limit for stored procedures / triggers Major Open
   Improvement CORE-1132 UNRESOLVED Exception context in PSQL exception handlers Major Reopened
   Improvement CORE-4238 UNRESOLVED Provide ability for engine to forcely make rollback for each TX that stays uncommitted more than some limit of time Minor Open
   New Feature CORE-985 UNRESOLVED Timeout parameters Minor Open
   Bug CORE-5234 FIXED Access violation on UDF crashes server Blocker Resolved
   Bug CORE-5410 FIXED Dependencies are not stored when using some type of contructions in subroutines Blocker Closed
   Bug CORE-5322 FIXED Cascade deletion in self-referencing table could raise "no current record for fetch operation" error Critical Closed
   Bug CORE-4483 FIXED Changed data not visible in WHEN-section if exception occured inside SP that has been called from this code Critical Closed
   Bug CORE-5383 FIXED Dependencies in Package not recognised Critical Closed
   Bug CORE-5194 FIXED Invalid computed by definition generated by isql -x Critical Closed
   Bug CORE-5268 FIXED Nested OR conditions may lead to incorrest results Critical Closed
   Bug CORE-5278 FIXED A number of SPB parameters fail in FB 3 & 4 Major Resolved
   Improvement CORE-5205 FIXED Add a switch to build linux binaries with builtin libtommath Major Resolved
   Bug CORE-5350 FIXED Assert in CachedMasterInterface::set Major Resolved
   Bug CORE-5184 FIXED Assertion in cloop dispatcher when trying to save exception information in status interface Major Resolved
   Bug CORE-5339 FIXED Assertion in createDatabase() when doing overwrite check Major Resolved
   Bug CORE-5252 FIXED Assertion on bugs.core_3029 in debug build Major Resolved
   Bug CORE-5225 FIXED Authentication end with first plugin that has the user but auth fails; should continue with next plugin Major Resolved
   Bug CORE-5393 FIXED Bad optimization of some operations with views containing subqueries Major Resolved
   Bug CORE-5181 FIXED Build fails when HAVE_MMAP is not defined Major Resolved
   Improvement CORE-5204 FIXED Build the Linux code with --enable-binreloc and create an option in the installer to install in different locations than /opt/firebird Major Resolved
   Bug CORE-1894 FIXED Circular dependencies between computed fields crashs the engine Major Resolved
   Bug CORE-5189 FIXED Codes of operation of user management plugin are missing in public API Major Resolved
   Bug CORE-5292 FIXED Database corrupted when trying to encrypt it but appropriate key is missing Major Resolved
   Bug CORE-5329 FIXED Database gets partially corrupted in the "no-reserve" mode Major Resolved
   Bug CORE-5179 FIXED Database-level statistics (MON$STAT_GROUP = 0) may contain multiple rows under concurrent load Major Resolved
   Improvement CORE-5180 FIXED Do not require root rights to build linux package Major Resolved
   Bug CORE-5326 FIXED Embedded - encrypting a database crashes host process when background encryption gets ready while no connection is established to that database Major Resolved
   Bug CORE-5296 FIXED Error in network protocol when performing callback to client for database crypt key Major Resolved
   Bug CORE-5390 FIXED ISQL crashes corrupting memory when statement length is greater than 10 MB Major Resolved
   Bug CORE-5182 FIXED Inconsistent effects of subsequent statement execution if failing during record refetch Major Resolved
   Bug CORE-5382 FIXED Incorrect processing (truncation) of SQL statement longer than 10MB Major Resolved
   Bug CORE-5226 FIXED Incorrect result set (missing records) may be returned by the ORDER plan query navigating on a descending index Major Resolved
   Bug CORE-5249 FIXED Incorrect use of readlink() system call Major Resolved
   Bug CORE-4701 FIXED Index and blob garbage collection doesn't take into accout data in undo log Major Resolved
   Improvement CORE-5374 FIXED Make database name available to crypt plugin Major Resolved
   Bug CORE-5294 FIXED Memory leak when use SHOW GRANTS on new empty database (3.0.1 & 4.0; SS & SC) Major Resolved
   Bug CORE-5359 FIXED OO API - MessageMetadata's getScale returns int and MetadataBuilder's setScale want unsigned Major Resolved
   Bug CORE-5277 FIXED Parameters with multibyte character sets allow to bypass the character limit of varchar fields Major Resolved
   Bug CORE-5384 FIXED Plugin manager fails to provide appropriate config information when name of configuration file is set in plugins.conf Major Resolved
   Bug CORE-5307 FIXED Random "invalid transaction handle" errors are returned from the engine Major Resolved
   Bug CORE-5337 FIXED Regression: The subquery in the insert list expressions ignore the changes made earlier in the same executable block. Major Resolved
   Bug CORE-5159 FIXED Regression: engine may throw transliteration errors when running from non-ASCII system path Major Resolved
   Bug CORE-5228 FIXED Restore may hang if the database contains more than 4 billion records Major Resolved
   Bug CORE-5162 FIXED SEC$ tables and tag/attributes Major Resolved
   Bug CORE-5285 FIXED Segfault when attachment is closed before it's request/statement/etc. Major Resolved
   Bug CORE-5171 FIXED Server crash on bugs.core_2890 in developer build Major Resolved
   Bug CORE-5157 FIXED Server goes into infinite loop when data is sent from client to the service in small packets Major Resolved
   Bug CORE-5154 FIXED Services API don't work with non-ascii database names Major Resolved
   Bug CORE-5203 FIXED Single CPU core fully utilized with Trace session Major Resolved
   Bug CORE-5289 FIXED Small memory leak when resultset is empty Major Resolved
   Bug CORE-5146 FIXED Suboptimal join order if one table has a selective predicate and MIN is calculated for the other one Major Resolved
   Bug CORE-5224 FIXED Transaction id tags for services API do not support new 48 bit transaction ids Major Resolved
   Bug CORE-5233 FIXED Unaligned Memory Access in MET_format Major Resolved
   Sub-task CORE-5346 FIXED CORE-1688
Window Function: named window
Major Resolved
   Sub-task CORE-3616 FIXED CORE-1688
Window Function: percent_rank()
Major Resolved
   Bug CORE-5244 FIXED Wrong error message when trying to execute SELECT statement using isc_dsql_execute_immediate Major Resolved
   Bug CORE-5355 FIXED XpbBuilder fails to create new TPB Major Resolved
   Bug CORE-5327 FIXED internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2307) Major Resolved
   Bug CORE-5232 FIXED 32-bit Locks on Big-Endian Systems Lead To Deadlock Major Closed
   Bug CORE-5133 FIXED ALTER SEQUENCE RESTART WITH does not change the initial value Major Closed
   Bug CORE-5241 FIXED Affected rows are not counted for some update operations with views Major Closed
   Improvement CORE-5167 FIXED Allow implicit conversion between boolean and string Major Closed
   New Feature CORE-5343 FIXED Allow particular DBA privileges to be transferred to regular users Major Closed
   Bug CORE-5305 FIXED CASCADE UPDATE fails for self-referencing FK Major Closed
   Bug CORE-5130 FIXED Compiler issues message about "invalid request BLR" when attempt to compile wrong DDL of view with both subquery and "WITH CHECK OPTION" in its DDL Major Closed
   Bug CORE-5273 FIXED Crash when attempt to create database with running trace ( internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2233) ) Major Closed
   Bug CORE-5313 FIXED Data type unknown error with LIST Major Closed
   Bug CORE-5264 FIXED Database cannot be unlocked (nbackup) if located on a raw device Major Closed
   Bug CORE-5231 FIXED EXECUTE STATEMENT: BLR error if more than 256 output parameters exist Major Closed
   Bug CORE-5142 FIXED Error "no current record to fetch" if some record is to be deleted both by the statement itself and by some trigger fired during statement execution Major Closed
   Bug CORE-1746 FIXED Expression index can be created while doing inserts into table Major Closed
   Bug CORE-5275 FIXED Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting Major Closed
   Bug CORE-5122 FIXED Expression index may not be used by the optimizer if created and used in different connection charsets Major Closed
   Bug CORE-5270 FIXED FBSVCMGR does not produce error while attempting to shutdown a database without specified timeout (prp_force_shutdown N) Major Closed
   Bug CORE-5210 FIXED Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work Major Closed
   Bug CORE-5279 FIXED Granting access rights to view is broken Major Closed
   Improvement CORE-2557 FIXED Grants on MON$ tables Major Closed
   Bug CORE-5165 FIXED HAVING COUNT(*) NOT IN ( <Q> ) prevent record from appearing in outer resultset when it should be there (<Q> = resultset without nulls) Major Closed
   Bug CORE-5236 FIXED IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins Major Closed
   Bug CORE-5207 FIXED ISQL -X may generate invalid GRANT USAGE statements for domains Major Closed
   Bug CORE-5220 FIXED ISQL -X: double quotes are missed for COLLATE <C> of CREATE DOMAIN statement when <C> is from any non-ascii charset Major Closed
   Bug CORE-5217 FIXED ISQL -x may crash while exporting an exception with message text length > 127 bytes Major Closed
   New Feature CORE-751 FIXED Implicitly active roles (and their permissions summarized) Major Closed
   Bug CORE-5248 FIXED Improve consistency in GRANT syntax between roles and privileges according to SQL standard Major Closed
   Improvement CORE-749 FIXED Increase maximum length of object names to 63 characters Major Closed
   Bug CORE-5351 FIXED LEFT JOIN incorrectly pushes UDF into the inner stream causing wrong results Major Closed
   Sub-task CORE-1780 FIXED CORE-1746
Move code in pcmet module into appropriate place (dfw and met)
Major Closed
   New Feature CORE-2762 FIXED New built-in function to check whether some role is implicitly active Major Closed
   Bug CORE-4985 FIXED Non-privileged user can implicitly count records in a restricted table Major Closed
   Bug CORE-5302 FIXED Performance regression when bulk inserting into table with indices Major Closed
   Improvement CORE-3637 FIXED Port for Linux/m68k Major Closed
   Bug CORE-5193 FIXED Precedence problem with operator IS Major Closed
   Bug CORE-5347 FIXED Races when initializing wire compression Major Closed
   Bug CORE-5367 FIXED Regression: (boolean) parameters as search condition no longer allowed Major Closed
   Bug CORE-5271 FIXED Regression: Can not create large index Major Closed
   Bug CORE-5304 FIXED Regression: Can not restore database with table contains field CHAR(n) and UTF8 character set Major Closed
   Bug CORE-5149 FIXED Regression: LEFT JOIN incorrectly pushes COALESCE into the inner stream causing wrong results Major Closed
   Bug CORE-5153 FIXED Regression: Server crashes when aggregate functions are used together with NOT IN predicate Major Closed
   Bug CORE-5381 FIXED Regression: could not execute query (select from view with nested view) Major Closed
   Bug CORE-5366 FIXED Regression: could not use CASE expression with more than 255 conditions. Major Closed
   Improvement CORE-5201 FIXED Return nonzero result code when restore fails on activating and creating deferred user index Major Closed
   Bug CORE-5222 FIXED SELECT WITH LOCK may raise unexpected update conflict errors under concurrent load Major Closed
   Bug CORE-5246 FIXED String truncation error while selecting from MON$ tables if some user-defined context variable exceeds 255 bytes in length Major Closed
   Bug CORE-5330 FIXED Trace session leads FB 4.0 to hang after 2nd launch of trivial .sql script. Neither attach to any database nor regular restart of FB service can be done. Major Closed
   Bug CORE-5161 FIXED Unique index could be created on non-unique data Major Closed
   Bug CORE-5341 FIXED User collate doesn't work with blobs Major Closed
   Sub-task CORE-3617 FIXED CORE-1688
Window Function: cume_dist()
Major Closed
   Sub-task CORE-3647 FIXED CORE-1688
Window Function: frame (rows / range) clause
Major Closed
   Sub-task CORE-3618 FIXED CORE-1688
Window Function: ntile(num_buckets integer)
Major Closed
   Bug CORE-5166 FIXED Wrong error message with UNIQUE BOOLEAN field Major Closed
   Sub-task CORE-5174 FIXED CORE-5171
Wrong sequence of savepoints may be produced by selectable procedure
Major Closed
   Bug CORE-5147 FIXED create trigger fails with ambiguous field name between table B and table A error Major Closed
   New Feature CORE-1815 FIXED Ability to grant role to another role Minor Resolved
   Improvement CORE-5266 FIXED Allow statement 'create OR ALTER user sysdba password ...' to initialize empty securityN.fdb as 'CREATE user ...' (i.e. which is typed without "or alter" clause) Minor Resolved
   Improvement CORE-5229 FIXED Allow to enforce IPv4 or IPv6 in URL-like connection strings Minor Resolved
   Sub-task CORE-5173 FIXED CORE-5171
Assertion in debug build on nested exception handlers
Minor Resolved
   Bug CORE-5223 FIXED Double dots are prohibited in file names if access is restricted to a list of directories Minor Resolved
   Improvement CORE-5257 FIXED Enable nested keys in plugin configuration Minor Resolved
   Bug CORE-5284 FIXED Firebird fails to build with USE_VALGRIND Minor Resolved
   Bug CORE-5308 FIXED ISQL hangs in BLOBVIEW command Minor Resolved
   Bug CORE-5404 FIXED Inconsistent column/line references when PSQL definitions return errors Minor Resolved
   Improvement CORE-5216 FIXED Provide location context (line/column numbers) for runtime errors raised inside EXECUTE BLOCK Minor Resolved
   Bug CORE-5314 FIXED UDFs declared with large varchars take excessive time to execute Minor Resolved
   Bug CORE-5291 FIXED Error messages differ when regular user tries to RESTORE database, depending on his default role and (perhaps) system privilege USE_GBAK_UTILITY Minor Closed
   Bug CORE-5218 FIXED Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x Minor Closed
   Improvement CORE-2192 FIXED Extend maximum database page size to 32KB Minor Closed
   Improvement CORE-5269 FIXED FBTRACEMGR should understand 'role <name>' command switch (needed to explicitly connect with role with "TRACE_ANY_ATTACHMENT" privilege) Minor Closed
   Bug CORE-5143 FIXED GBAK restore failed when there is SQL function accessing table and switch -O(NE_AT_A_TIME) is used Minor Closed
   Bug CORE-5237 FIXED Invalid handling of dot (.) and asterisk (*) in config file name and path for include clause Minor Closed
   Bug CORE-5183 FIXED Regression: line/column numbering may be twisted if syntax is used Minor Closed
   Bug CORE-4424 FIXED Rollback to wrong savepoint if several exception handlers on the same level are executed Minor Closed
   Bug CORE-5295 FIXED Validation could read after the end-of-file when handle multifile database Minor Closed
   Bug CORE-5140 FIXED Wrong error message when user tries to set number of page buffers into not supported value Minor Closed
   Bug CORE-5155 FIXED [CREATE OR] ALTER USER statement: clause PASSWORD (if present) must be always specified just after USER Minor Closed
   Bug CORE-5348 FIXED Databases created at build process are owned by Windows administrator, not SYSDBA Trivial Closed
   Bug CORE-5141 FIXED Field definition allows several NOT NULL clauses Trivial Closed
   Improvement CORE-5119 FIXED Support autocommit mode in SET TRANSACTION statement Trivial Closed
   Bug CORE-5139 FIXED mistake in comment "can't ise MutexLockGuard here" Trivial Closed
  6 of 6 issues have been resolved
Maintenance release
   Bug CORE-5318 FIXED Bug in ESQL applications Major Resolved
   Bug CORE-5120 FIXED Configure: snprintf function is already defined on MSVC 2015 Major Resolved
   Bug CORE-5387 FIXED Memory leak - a lot of 4Kb-sized regions remain mapped till the death of the process Major Resolved
   Bug CORE-4742 FIXED gfix -shut single -force 0 ..... not working as documented with 2.5.3 & 2.5.4 Major Resolved
   Bug CORE-5401 FIXED High load in touch thread Major Closed
   Bug CORE-5236 FIXED IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins Major Closed
  0 of 16 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
   Improvement CORE-4409 UNRESOLVED Enhancement in precision of calculations with NUMERIC/DECIMAL Major Open
   Improvement CORE-1082 UNRESOLVED Improve the statistics engine allowing auto-updating and gatherig more statistic data. Major Open
   Task CORE-5238 UNRESOLVED Replace xinetd support with the native listener 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-820 UNRESOLVED isc_dsql_exec* should allow list of parameter sets 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


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

Preset Filters

Project Summary

Open Open 1175
In Progress In Progress 4
Reopened Reopened 26
Resolved Resolved 342
Closed Closed 3700

Open Issues

By Priority
Blocker Blocker 7
Critical Critical 38
Major Major 765
Minor Minor 345
Trivial Trivial 50

By Assignee
Adriano dos Santos Fernandes 33
Alexander Peshkov 37
Claudio Valderrama C. 3
Dimitry Sibiryakov 1
Dmitry Yemanov 80
Michal Kubeček 1
Paul Reeves 19
Roman Simakov 1
Vlad Khorsun 70
Unassigned 960