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 INTL/DSQL Development
December 2010 to February 2011

February 2011

HEAD
  • Fixed CORE-3330 - Server crashes while recreating the table with a NULL -> NOT NULL change.
  • Fixed CORE-3201 - ATAN2 returns incorrect value for (0, 0).
  • Fixed a problem with COUNT in dialect 1.
  • Fixed CORE-3310 - RDB$GET_CONTEXT and between in view.
  • Fixed CORE-3338 - Some expression indexes with COALESCE, CASE and DECODE became inoperant.
  • Removed DSQL hidden variables expressions.
  • Refactored COALESCE, DECODE and (simple) CASE, using new BLR verbs.
  • Fixed v3 regression with UPDATE OR INSERT inside PROCEDURE/FUNCTION.
  • Fixed assert with DECODE/CASE with only test parameters and no values.
  • Fixed CORE-3255 - The server could crash using views with GROUP BY.
  • Do not reuse arbitrary nodes' impure space in aggregate. Relates to CORE-3255.
  • Fixed hang found with CORE-3340 test-case.
  • Simplified fix for problem with default values in formats.
  • Fixed DDL trigger crash reported in fb-devel.
  • Fixed problem with packages reported privately by Vlad.
  • Refactored out OPT_expression_equal while fixing checking of sameAs involving CASTs. Problem saw by Dmitry.
  • Added EVENT_TYPE and OBJECT_TYPE to DDL_TRIGGER context. Improvement suggested by Thomas Steinmaurer.
  • Updated TCS tests for FB 3.
  • Removed the legacy DSQL hash table module (HSHD).
  • Various DSQL refactorings.
2.5 Branch
  • Backport simplified fix for CORE-3255 - The server could crash using views with GROUP BY.
January 2011

HEAD
  • Fixed CORE-3306 - Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure.
  • Fixed CORE-3320 - Some MERGE syntax can crash the server.
  • Made the UDR engine work correctly with the new plugins code.
  • Fixed recursive query with ORDER BY.
  • Various DSQL refactorings
V2.5 branch
  • Backported fix for CORE-3306 - Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure.
  • Backported fix for CORE-3320 - Some MERGE syntax can crash the server.
V2.1 branch
  • Backported fix for CORE-3320 - Some MERGE syntax can crash the server
December 2010

HEAD
  •  
  • Make statement evaluation faster, reworking line/column handling.
  • Make expression evaluation faster, using more inlining.
  • Use the impure space of string variable in a consistently (first or subsequent request execution) and optimized (no double allocation) way.
  • Fixed CORE-2204 - Constraints on SP output parameters are checked even when the SP returns zero rows.
  • Feature CORE-726 - Boolean data type.
  • Fixed the crash about NEXT VALUE FOR reported in fb-devel.
  • Various DSQL refactorings.
V2.5 branch
  • Fixed CORE-3277 - Wrong result for RIGHT(UTF8 varchar).
Adriano dos Santos Fernandes
Sao Paulo, Brazil
December 2010 to February 2011

February 2011

HEAD
  • Fixed CORE-3330 - Server crashes while recreating the table with a NULL -> NOT NULL change.
  • Fixed CORE-3201 - ATAN2 returns incorrect value for (0, 0).
  • Fixed a problem with COUNT in dialect 1.
  • Fixed CORE-3310 - RDB$GET_CONTEXT and between in view.
  • Fixed CORE-3338 - Some expression indexes with COALESCE, CASE and DECODE became inoperant.
  • Removed DSQL hidden variables expressions.
  • Refactored COALESCE, DECODE and (simple) CASE, using new BLR verbs.
  • Fixed v3 regression with UPDATE OR INSERT inside PROCEDURE/FUNCTION.
  • Fixed assert with DECODE/CASE with only test parameters and no values.
  • Fixed CORE-3255 - The server could crash using views with GROUP BY.
  • Do not reuse arbitrary nodes' impure space in aggregate. Relates to CORE-3255.
  • Fixed hang found with CORE-3340 test-case.
  • Simplified fix for problem with default values in formats.
  • Fixed DDL trigger crash reported in fb-devel.
  • Fixed problem with packages reported privately by Vlad.
  • Refactored out OPT_expression_equal while fixing checking of sameAs involving CASTs. Problem saw by Dmitry.
  • Added EVENT_TYPE and OBJECT_TYPE to DDL_TRIGGER context. Improvement suggested by Thomas Steinmaurer.
  • Updated TCS tests for FB 3.
  • Removed the legacy DSQL hash table module (HSHD).
  • Various DSQL refactorings.
2.5 Branch
  • Backport simplified fix for CORE-3255 - The server could crash using views with GROUP BY.
January 2011

HEAD
  • Fixed CORE-3306 - Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure.
  • Fixed CORE-3320 - Some MERGE syntax can crash the server.
  • Made the UDR engine work correctly with the new plugins code.
  • Fixed recursive query with ORDER BY.
  • Various DSQL refactorings
V2.5 branch
  • Backported fix for CORE-3306 - Invariant sub-query is treated as variant thus causing multiple invokations of a nested stored procedure.
  • Backported fix for CORE-3320 - Some MERGE syntax can crash the server.
V2.1 branch
  • Backported fix for CORE-3320 - Some MERGE syntax can crash the server
December 2010

HEAD
  •  
  • Make statement evaluation faster, reworking line/column handling.
  • Make expression evaluation faster, using more inlining.
  • Use the impure space of string variable in a consistently (first or subsequent request execution) and optimized (no double allocation) way.
  • Fixed CORE-2204 - Constraints on SP output parameters are checked even when the SP returns zero rows.
  • Feature CORE-726 - Boolean data type.
  • Fixed the crash about NEXT VALUE FOR reported in fb-devel.
  • Various DSQL refactorings.
V2.5 branch
  • Fixed CORE-3277 - Wrong result for RIGHT(UTF8 varchar).
Adriano dos Santos Fernandes
Sao Paulo, Brazil