Join Firebird!

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

Follow Us

Select your media preference

Newsletter

Subscribe to Firebird’s Newsletter to receive the latest news

Developer's Report: Firebird Core Development & Coordination
May 2014 to October 2014
 
October 2014
 
New development:
  • CORE-3526: Support for WHEN SQLSTATE
  • CORE-2530: Denser data stream and better prefetch logic in the network protocol
Bugfixing:
  • CORE-4568: Server may crash while disconnecting from the database under load
  • Fixed regression with NULL items of the message not beng zero-initialized
September 2014
 
New development:
  • CORE-4564: Add per-table performance counters to the monitoring tables
  • CORE-2897: Don't send full length of field over the wire when field is null
  • Optimized the shared counters code for SS
Bugfixing:
  • CORE-4532: Server crashes while reserving a table under high load
August 2014
 
New development:
  • CORE-4528: Allow hash/merge joins for non-field (dbkey or derived expression) equalities
  • Added specific error code for read conflicts in RC NO_REC_VER mode
  • Added more record-level performance counters
Bugfixing:
  • CORE-4530: DB_KEY based join of two tables may be ineffective
  • Fixed regression in the trace reporting UPDATES in statistics when doing INSERT into
  • Fixed a crash when the database monitoring is used concurrently under load
  • Fixed possible deadlocks between a worker thread and an attachment-level AST
July 2014
 
New development:
  • Improved synchronization and performance of the monitoring requests
  • Improved the detailed plan output
Bugfixing:
  • CORE-4500: Firebird crashes after unsuccessful remapping of the lock table's shared memory
  • CORE-4498: FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval
  • CORE-4480: ISQL issues warning: "Bad debug info format" when connect to database with stored function after it's restoring
June 2014
 
New development:
  • CORE-2303: Include plan in MON$STATEMENTS
Bugfixing:
  • CORE-4460: Expressions containing some built-in functions may be badly optimized
  • CORE-3305: "BLOB not found" error after creation/altering of the invalid trigger
May 2014
 
New development:
  • CORE-4437: Add support for the RETURNING clause to Embedded SQL
  • CORE-4438: Add support for UPDATE OR INSERT statement to Embedded SQL
  • Improved performance of the hash join algorithm
Bugfixing:
  • CORE-4447: Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
  • CORE-4422: FB crashes when using row_number()over( PARTITION BY x) in ORDER by clause
  • CORE-4419: Server crashes while sorting records longer than 128KB
  • Fixed the restore issue with PSQL functions
  • Fixed the issue with UNION ALL vs WITH LOCK

Dmitry Yemanov
Penza, Russia
May 2014 to October 2014
 
October 2014
 
New development:
  • CORE-3526: Support for WHEN SQLSTATE
  • CORE-2530: Denser data stream and better prefetch logic in the network protocol
Bugfixing:
  • CORE-4568: Server may crash while disconnecting from the database under load
  • Fixed regression with NULL items of the message not beng zero-initialized
September 2014
 
New development:
  • CORE-4564: Add per-table performance counters to the monitoring tables
  • CORE-2897: Don't send full length of field over the wire when field is null
  • Optimized the shared counters code for SS
Bugfixing:
  • CORE-4532: Server crashes while reserving a table under high load
August 2014
 
New development:
  • CORE-4528: Allow hash/merge joins for non-field (dbkey or derived expression) equalities
  • Added specific error code for read conflicts in RC NO_REC_VER mode
  • Added more record-level performance counters
Bugfixing:
  • CORE-4530: DB_KEY based join of two tables may be ineffective
  • Fixed regression in the trace reporting UPDATES in statistics when doing INSERT into
  • Fixed a crash when the database monitoring is used concurrently under load
  • Fixed possible deadlocks between a worker thread and an attachment-level AST
July 2014
 
New development:
  • Improved synchronization and performance of the monitoring requests
  • Improved the detailed plan output
Bugfixing:
  • CORE-4500: Firebird crashes after unsuccessful remapping of the lock table's shared memory
  • CORE-4498: FB 3.0 crashes when getting an explained plan for a DBKEY based retrieval
  • CORE-4480: ISQL issues warning: "Bad debug info format" when connect to database with stored function after it's restoring
June 2014
 
New development:
  • CORE-2303: Include plan in MON$STATEMENTS
Bugfixing:
  • CORE-4460: Expressions containing some built-in functions may be badly optimized
  • CORE-3305: "BLOB not found" error after creation/altering of the invalid trigger
May 2014
 
New development:
  • CORE-4437: Add support for the RETURNING clause to Embedded SQL
  • CORE-4438: Add support for UPDATE OR INSERT statement to Embedded SQL
  • Improved performance of the hash join algorithm
Bugfixing:
  • CORE-4447: Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
  • CORE-4422: FB crashes when using row_number()over( PARTITION BY x) in ORDER by clause
  • CORE-4419: Server crashes while sorting records longer than 128KB
  • Fixed the restore issue with PSQL functions
  • Fixed the issue with UNION ALL vs WITH LOCK

Dmitry Yemanov
Penza, Russia