Join Firebird!

Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses

Join!

Follow Us

Select your media preference

Newsletter

Subscribe to Firebird’s Newsletter to receive the latest news

Developer's Report: Firebird Core Development
January - May 2016
January
trunk
  • New feature CORE-1538 :  Add an option to isc_database_info to return the number of free pages in a database
  • Improvement CORE-5063 : Make "show database" command to show numbers of used and free pages in database
  • Improvement CORE-2493 : Append the IP address of the remote host to error messages in firebird.log for TCP connections
  • Fixed bug CORE-5075 : Triger on DISCONNECT with dynamic SQL (ES 'insert into ...'): 1) does not work in 3.0
  • Fixed bug CORE-5078 : "Invalid BLOB ID" error
  • Update VC10 and VC12 builds
  • Reworked some parts of newly introduced 64-bit transaction IDs:
  • Remove LCK_idx_reserve introduced with 64-bit transaction ID.
  • Restore original logic in BTR_next_index (wait for tx lock when index build is in progress).
  • Use irt_repeat::irt_root to store high 32 bit of tra_num.
  • It also fixed deadlock related with LCK_idx_reserve lock (reported privately).
B2_5_Release
  • Fixed bug CORE-5068 : gbak with invalid parameter crashes FB
  • Fixed bug CORE-5078 : "Invalid BLOB ID" error
February
trunk
  • Fixed bug CORE-5087 : Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
  • Frontport code from v2.5. It should fix CORE-5102 : FB3.0 RC1 Fbclient.dll function calls modify FPU control word
  • Fixed bug CORE-5101 : Backup restore is slow in FB3 when the database contains many small tables with indices
  • Fixed bug CORE-5104 : External data source selects became slow. Thanks to Alex
  • Simplest fix for bug CORE-5110 : False PK\FK violation could be reported when attachment used isc_dpb_no_garbage_collect flag
  • Forward ported for CORE-5067 : Blocking new connections as a consequence of the too long sweep security2.fdb
  • Fixed known issues with MERGE and stable cursor (see CORE-3362). Thanks to Dmitry for idea
B2_5_Release
  • Fixed bug CORE-5067 : Blocking new connections as a consequence of the too long sweep security2.fdb
  • Backport fix bug CORE-5087 : Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
  • Simplest fix for bug CORE-5110 : False PK\FK violation could be reported when attachment used isc_dpb_no_garbage_collect flag
  • Fixed bug CORE-5117 : Firebird embedded could crash on unload if was used as pure client only
March
trunk
  • Fixed bug CORE-5140 : Wrong error message when user tries to set number of page buffers into not supported value
  • Fixed "bug" CORE-5139 : mistake in comment "can't ise MutexLockGuard here"
  • MSVC14 build
  • Fixed part of the issues at CORE-5099 and CORE-5120
  • Fixed bug CORE-5161 : Unique index could be created on non-unique data
  • Applied initial patch from red-soft for contiguous incremental backup ("Physical replication using NBACKUP")
  • Full name for INPLACE option
  • System index for RDB$BACKUP_HISTORY (RDB$GUID)
  • Let nbackup skip another tags on header page and limit search by page boundaries
  • Fixed examples build issue (VC10-14).
B3_0_Release
  • Backport fix for bug CORE-5140 : Wrong error message when user tries to set number of page buffers to an unsupported value
  • MSVC14 build
  • Fixed part of the issues at CORE-5099 and CORE-5120
  • Fixed bug CORE-5161 : Unique index could be created on non-unique data
  • Fixed examples build issue (VC10-14).
B2_5_Release
  • Fixed bug CORE-4645 : internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
  • Backport fix for bug CORE-5161 : Unique index could be created on non-unique data
B2_1_Release
  • Backport fix for bug CORE-5161 : Unique index could be created on non-unique data
April
master
  • Forward ported fix for bug CORE-4645 : internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
  • Review and apply patch by Marius: Add VC14 Solution files for icu. Fixed warning and use links to correct projects
  • Fixed bug CORE-5120 :  Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work
B3_0_Release
  • Forward ported fix for bug CORE-4645 : internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
  • Fixed bug CORE-5120 :  Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work
May
master
  • Place expression index support routines where it should be.
  • Add protection from changes while expression index is built.
  • Remove PCMET module.
  • Refactor relation protection routines into a class.
  • Fixed bug CORE-5234 :  Access violation on UDF crashes server
B3_0_Release
  • Place expression index support routines where it should be.
  • Add protection from changes while expression index is built.
  • Remove PCMET module.
  • Refactor relation protection routines into a class.
  • Fixed bug CORE-5234 :  Access violation on UDF crashes server
B2_5_Release
  • Forward ported fix for bug CORE-1746 : Expression index can be created while doing inserts into table
  • Fixed bug CORE-5240 : Restore database with large page buffer - connection lost to database
Other:
  • A patch by Nickolay Samofatov re. statement level read-consistency and intermediate garbage collection is under active investigation: it is applied to the current codebase (see fork by RedSoft at GitHub https://github.com/redsoftbiz/firebird/commits/read_consistency), few errors is found and fixed, More work to be done.
  • Some performance regressions in v3 are under investigation, work in progress
Vladyslav Khorsun
Dnetpropetrovsk, Ukraine
January - May 2016
January
trunk
  • New feature CORE-1538 :  Add an option to isc_database_info to return the number of free pages in a database
  • Improvement CORE-5063 : Make "show database" command to show numbers of used and free pages in database
  • Improvement CORE-2493 : Append the IP address of the remote host to error messages in firebird.log for TCP connections
  • Fixed bug CORE-5075 : Triger on DISCONNECT with dynamic SQL (ES 'insert into ...'): 1) does not work in 3.0
  • Fixed bug CORE-5078 : "Invalid BLOB ID" error
  • Update VC10 and VC12 builds
  • Reworked some parts of newly introduced 64-bit transaction IDs:
  • Remove LCK_idx_reserve introduced with 64-bit transaction ID.
  • Restore original logic in BTR_next_index (wait for tx lock when index build is in progress).
  • Use irt_repeat::irt_root to store high 32 bit of tra_num.
  • It also fixed deadlock related with LCK_idx_reserve lock (reported privately).
B2_5_Release
  • Fixed bug CORE-5068 : gbak with invalid parameter crashes FB
  • Fixed bug CORE-5078 : "Invalid BLOB ID" error
February
trunk
  • Fixed bug CORE-5087 : Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
  • Frontport code from v2.5. It should fix CORE-5102 : FB3.0 RC1 Fbclient.dll function calls modify FPU control word
  • Fixed bug CORE-5101 : Backup restore is slow in FB3 when the database contains many small tables with indices
  • Fixed bug CORE-5104 : External data source selects became slow. Thanks to Alex
  • Simplest fix for bug CORE-5110 : False PK\FK violation could be reported when attachment used isc_dpb_no_garbage_collect flag
  • Forward ported for CORE-5067 : Blocking new connections as a consequence of the too long sweep security2.fdb
  • Fixed known issues with MERGE and stable cursor (see CORE-3362). Thanks to Dmitry for idea
B2_5_Release
  • Fixed bug CORE-5067 : Blocking new connections as a consequence of the too long sweep security2.fdb
  • Backport fix bug CORE-5087 : Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
  • Simplest fix for bug CORE-5110 : False PK\FK violation could be reported when attachment used isc_dpb_no_garbage_collect flag
  • Fixed bug CORE-5117 : Firebird embedded could crash on unload if was used as pure client only
March
trunk
  • Fixed bug CORE-5140 : Wrong error message when user tries to set number of page buffers into not supported value
  • Fixed "bug" CORE-5139 : mistake in comment "can't ise MutexLockGuard here"
  • MSVC14 build
  • Fixed part of the issues at CORE-5099 and CORE-5120
  • Fixed bug CORE-5161 : Unique index could be created on non-unique data
  • Applied initial patch from red-soft for contiguous incremental backup ("Physical replication using NBACKUP")
  • Full name for INPLACE option
  • System index for RDB$BACKUP_HISTORY (RDB$GUID)
  • Let nbackup skip another tags on header page and limit search by page boundaries
  • Fixed examples build issue (VC10-14).
B3_0_Release
  • Backport fix for bug CORE-5140 : Wrong error message when user tries to set number of page buffers to an unsupported value
  • MSVC14 build
  • Fixed part of the issues at CORE-5099 and CORE-5120
  • Fixed bug CORE-5161 : Unique index could be created on non-unique data
  • Fixed examples build issue (VC10-14).
B2_5_Release
  • Fixed bug CORE-4645 : internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
  • Backport fix for bug CORE-5161 : Unique index could be created on non-unique data
B2_1_Release
  • Backport fix for bug CORE-5161 : Unique index could be created on non-unique data
April
master
  • Forward ported fix for bug CORE-4645 : internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
  • Review and apply patch by Marius: Add VC14 Solution files for icu. Fixed warning and use links to correct projects
  • Fixed bug CORE-5120 :  Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work
B3_0_Release
  • Forward ported fix for bug CORE-4645 : internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
  • Fixed bug CORE-5120 :  Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work
May
master
  • Place expression index support routines where it should be.
  • Add protection from changes while expression index is built.
  • Remove PCMET module.
  • Refactor relation protection routines into a class.
  • Fixed bug CORE-5234 :  Access violation on UDF crashes server
B3_0_Release
  • Place expression index support routines where it should be.
  • Add protection from changes while expression index is built.
  • Remove PCMET module.
  • Refactor relation protection routines into a class.
  • Fixed bug CORE-5234 :  Access violation on UDF crashes server
B2_5_Release
  • Forward ported fix for bug CORE-1746 : Expression index can be created while doing inserts into table
  • Fixed bug CORE-5240 : Restore database with large page buffer - connection lost to database
Other:
  • A patch by Nickolay Samofatov re. statement level read-consistency and intermediate garbage collection is under active investigation: it is applied to the current codebase (see fork by RedSoft at GitHub https://github.com/redsoftbiz/firebird/commits/read_consistency), few errors is found and fixed, More work to be done.
  • Some performance regressions in v3 are under investigation, work in progress
Vladyslav Khorsun
Dnetpropetrovsk, Ukraine
This site and the pages contained within are Copyright © 2000-2020, Firebird Project. Firebird® is a registered trademark of Firebird Foundation Incorporated.
Developed by DQ Team.