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
August to November 2010

November 2010

New development
  • Researched abilities for better cardinality estimations
  • Fixed a number of v3-only regressions:
    • assertion when restoring a database having expression inside referencing non-existent UDFs
    • inability to restore privileges granted to roles
    • inability to alter the [[NOT] DETERMINISTIC] clause
    • SET TRANSACTION statement doesn't work
Bug Fixing
  • CORE-3256: Error "request depth exceeded" may appear while preparing a select query against a view with explicit plan
  • CORE-3218: Statement cancellation request might be silently ignored by the currently running SQL code
  • CORE-3217: Server crashes inside the lock manager when multiple connections are attaching/detaching simultaneously
  • CORE-3210: Error "no current record for fetch operation" in SELECT query
  • CORE-3208: Significant memory leaks with recursive queries
  • CORE-3207: Access violation inside isc_start_multiple() on begin transaction
  • CORE-3059: RemoteFileOpenAbility fails on Windows
  • Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
  • CORE-1038: Remote shadows on NT-based systems
  • Unregistered: Server crashes while shutting down the database
  • Unregistered: Server crashes while printing database pools into a file
  • Unregistered: Minor corrections in the optimizer, resolving the known regressions
  • Unregistered: More than 128 expression indices cannot be created without restarting the server
  • Unregistered: Incorrect collection of inner streams for aggregates
October 2010

New development
  • Basic network support for the fb_ping() API call
  • Fixed a few problems with PSQL functions
Bug Fixing
  • CORE-3205: isc_dsql_exec_immed2() doesn't return error codes isc_stream_eof and isc_sing_select_err
  • CORE-3203: UPDATE OR INSERT with RETURNING causes "Invalid Cursor" error
  • CORE-3202: execute_immediate API call family may crash the remote server
  • CORE-2827: Very slow prepare for complex interrelated metadata with many triggers indirectly involved in the operation being prepared
  • Unregistered (backport): Faster lookup in the security classes
  • CORE-1234 (backport): More information about table what belongs to column when checking privileges
Miscellaneous
  • Two webinars (v2.5 launch and performance testing)
September 2010

Bug Fixing
  • CORE-3137: Partial rollback is possible for a selectable procedure modifying data
  • CORE-3131: WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U
  • CORE-3003: Procedure suspend check may cause restore to fail
  • Unregistered (backport): Error in the BLR printer output
August 2010

New development
  • Fixed incomplete processing of UDF arguments, causing server crashes
Bug Fixing
  • CORE-3103: Select statement with more non indexed reads in version 2.5RC3 as in version 2.1.3
  • CORE-2822 (post-fix): Error "no current row for fetch operation" when subquery includes a non-trivial derived table
  • CORE-2155: Join of SP with view or table may fail with 'No current record for fetch operation'
  • CORE-1079 (post-fix): Every attach of fbclient/fbembed library to the host process leaks 64KB of memory
Dmitry Yemanov
Penza, Russia
August to November 2010

November 2010

New development
  • Researched abilities for better cardinality estimations
  • Fixed a number of v3-only regressions:
    • assertion when restoring a database having expression inside referencing non-existent UDFs
    • inability to restore privileges granted to roles
    • inability to alter the [[NOT] DETERMINISTIC] clause
    • SET TRANSACTION statement doesn't work
Bug Fixing
  • CORE-3256: Error "request depth exceeded" may appear while preparing a select query against a view with explicit plan
  • CORE-3218: Statement cancellation request might be silently ignored by the currently running SQL code
  • CORE-3217: Server crashes inside the lock manager when multiple connections are attaching/detaching simultaneously
  • CORE-3210: Error "no current record for fetch operation" in SELECT query
  • CORE-3208: Significant memory leaks with recursive queries
  • CORE-3207: Access violation inside isc_start_multiple() on begin transaction
  • CORE-3059: RemoteFileOpenAbility fails on Windows
  • Bugcheck "Too many savepoints (287)" at rollback after exception at EXECUTE BLOCK with exception handler
  • CORE-1038: Remote shadows on NT-based systems
  • Unregistered: Server crashes while shutting down the database
  • Unregistered: Server crashes while printing database pools into a file
  • Unregistered: Minor corrections in the optimizer, resolving the known regressions
  • Unregistered: More than 128 expression indices cannot be created without restarting the server
  • Unregistered: Incorrect collection of inner streams for aggregates
October 2010

New development
  • Basic network support for the fb_ping() API call
  • Fixed a few problems with PSQL functions
Bug Fixing
  • CORE-3205: isc_dsql_exec_immed2() doesn't return error codes isc_stream_eof and isc_sing_select_err
  • CORE-3203: UPDATE OR INSERT with RETURNING causes "Invalid Cursor" error
  • CORE-3202: execute_immediate API call family may crash the remote server
  • CORE-2827: Very slow prepare for complex interrelated metadata with many triggers indirectly involved in the operation being prepared
  • Unregistered (backport): Faster lookup in the security classes
  • CORE-1234 (backport): More information about table what belongs to column when checking privileges
Miscellaneous
  • Two webinars (v2.5 launch and performance testing)
September 2010

Bug Fixing
  • CORE-3137: Partial rollback is possible for a selectable procedure modifying data
  • CORE-3131: WIN1257_LV (Latvian) collation is wrong for 4 letters: A E I U
  • CORE-3003: Procedure suspend check may cause restore to fail
  • Unregistered (backport): Error in the BLR printer output
August 2010

New development
  • Fixed incomplete processing of UDF arguments, causing server crashes
Bug Fixing
  • CORE-3103: Select statement with more non indexed reads in version 2.5RC3 as in version 2.1.3
  • CORE-2822 (post-fix): Error "no current row for fetch operation" when subquery includes a non-trivial derived table
  • CORE-2155: Join of SP with view or table may fail with 'No current record for fetch operation'
  • CORE-1079 (post-fix): Every attach of fbclient/fbembed library to the host process leaks 64KB of memory
Dmitry Yemanov
Penza, Russia