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
October 2011 to June 2012

June 2012

TRUNK
  • Improvements and correction to external routines.
  • Creating C++ framework for API Methods.
  • Fixed CORE-3874 - Computed column appears in non-existant rows of left join.
  • Started looking about UUID problems.
May 2012

TRUNK
  • Finished unifying DSQL/JRD sub-nodes.
  • Fixed old refactoring problems.
  • Fixed CORE-2697 again after refactoring problems.
  • Fixed the problem reported a while ago in fb-devel by Thomas Steinmaurer ("Fb 3 and RDB$MECHANISM values for SP/SF parameters").
  • Disable blr_stmt_expr (re-enabled with CORE-3812 changes) and implement blr conversion for DECODE.
  • Fixed problems with views WITH CHECK OPTION. Also change its triggers as asked for opinions in fb-devel.
  • Improvements and correction to external routines.
V.2.5 branch
  • Backported fix for CORE-3611 - Wrong data while retrieving from CTEs (or derived tables) with same column names.
April 2012

TRUNK
  • Refactored nod_select_expr, nod_with and nod_list (union).
  • Refactored nod_rows.
  • Refactored nod_order.
  • Getting rid of dsql_nod.
  • Added sed script to set btyacc.
  • Started unifying DSQL/JRD sub-nodes.
March 2012

TRUNK
  • Simplify CastNode. There was no need for a format there.
  • Refactor DDL nodes removing references to non-value/-rse dsql_nod.
  • Refactored nod_field_name, nod_var_name, nod_array and nod_collate.
  • Make column_select a SubQueryNode instead of nod_select_expr directly.
V2.5 branch
  • Fixed CORE-3802 - Firebird runs out of memory while restoring database backup.
February 2012

TRUNK
  • Refactor COMMIT, ROLLBACK and SET TRANSACTION commands.
  • Refactor SELECT.
  • Refactor GRANT / REVOKE.
  • Checking fix for CORE-1347 for the 2.0.7 release
  • Remove legacy statements residuals.
  • Parser (request types).
V2.5 branch
  • Backported fix for CORE-1997 - Broken foreign key handling for multi-segmented index using multi-level collations.
  • Backported fix for CORE-2457 - UNICODE_CI internal gds software consistency check.
January  2012

TRUNK
  • Improvement CORE-3343 - RETURNING clause is not supported in positioned (WHERE CURRENT OF) UPDATE and DELETE statements.
  • Fixed CORE-1997 - Broken foreign key handling for multi-segmented index using multi-level collations.
  • Fixed CORE-2457 - UNICODE_CI internal gds software consistency check.
  • Fixed CORE-3737 - EXECUTE BLOCK parameters definitions are not respected and may cause wrong behavior related to character sets.
  • Fixed problem with default collation.
  • Removed READ/WRITE BLOB sql commands. / Refactored request operations to fix server crashes.
December  2011

TRUNK
  • Fixed the problem with windowed functions in recursive CTEs, reported by Frank Ingermann in fb-devel.
  • Fixed CORE-3683 - Recursive query with GROUP BY in root part: wrong results if no index exists for fields that are grouped.
  • Fixed CORE-3545 - Inconsistent domain's constraint validation in PSQL.
  • Fixed CORE-3382 - Incomplete description of POSITION() function.
  • Fixed CORE-3694 - internal Firebird consistency check in query with grouping by subquery+stored procedure+aggregate.
  • Fixed CORE-3238 - Makes GEN_UUID return a compliant RFC-4122 binary UUID and introduce CHAR_TO_UUID2 and UUID_TO_CHAR2 to convert UUIDs from/to string also complying with the RFC.
V2.5 branch
  • Backported fix for CORE-3601 - Incorrect TEXT BLOB charset transliteration on VIEW with trigger.
  • Backported fix for CORE-3238 - Makes GEN_UUID return a compliant RFC-4122 binary UUID and introduce CHAR_TO_UUID2 and UUID_TO_CHAR2 to convert UUIDs from/to string also complying with the RFC.
November  2011

TRUNK
  • Fixed CORE-3650 - Recreation of collation leads to FB "death".
  • Refactored legacy (UDF) function creation.
  • Extend ISQL' SHOW FUNCTION to take packages and parameter's datatype of non-legacy functions into account.
  • Apply CORE-3114 patch (Attempt to drop non-existing generator produces bad error) with some modifications.
  • Cleanup RECREATE commands and routine method names.
  • Feature CORE-3018 - RECREATE SEQUENCE/GENERATOR.
  • Refactor DDL commands: DROP INDEX, DROP FILTER, DROP SHADOW, CREATE/DROP ROLE and DROP USER.
  • Refactor DDL commands: ALTER EXTERNAL FUNCTION, ALTER INDEX, SET STATISTICS, CREATE SHADOW, ALTER ROLE, CREATE/ALTER DATABASE.
  • Fixed backup/restore of BOOLEAN columns.
October  2011

TRUNK
  • Finished CORE-1288 - Subprocedures in PSQL and EXECUTE BLOCK.
  • Feature CORE-3626 - Subfunctions in PSQL and EXECUTE BLOCK.
  • Improvement CORE-3639 - Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification.
  • Feature CORE-3619 - Windows function FIRST_VALUE.
  • Feature CORE-3620 - Window function LAST_VALUE.
  • Feature CORE-3621 - Window function NTH_VALUE.
  • Fixed CORE-3611 - Wrong data while retrieving from CTEs (or derived tables) with same column names.
  • Fixed CORE-3611 - Wrong data while retrieving from CTEs (or derived tables) with same column names.
  • Fixed ACL checking.
  • Avoid waste some bytes per record and procedure streams.
  • Avoid thrown exceptions in normal operation when loading non-existent ICU versions and in successful attachments. This was a pain in the debugger.
Adriano dos Santos Fernandes
Sao Paulo, Brazil
October 2011 to June 2012

June 2012

TRUNK
  • Improvements and correction to external routines.
  • Creating C++ framework for API Methods.
  • Fixed CORE-3874 - Computed column appears in non-existant rows of left join.
  • Started looking about UUID problems.
May 2012

TRUNK
  • Finished unifying DSQL/JRD sub-nodes.
  • Fixed old refactoring problems.
  • Fixed CORE-2697 again after refactoring problems.
  • Fixed the problem reported a while ago in fb-devel by Thomas Steinmaurer ("Fb 3 and RDB$MECHANISM values for SP/SF parameters").
  • Disable blr_stmt_expr (re-enabled with CORE-3812 changes) and implement blr conversion for DECODE.
  • Fixed problems with views WITH CHECK OPTION. Also change its triggers as asked for opinions in fb-devel.
  • Improvements and correction to external routines.
V.2.5 branch
  • Backported fix for CORE-3611 - Wrong data while retrieving from CTEs (or derived tables) with same column names.
April 2012

TRUNK
  • Refactored nod_select_expr, nod_with and nod_list (union).
  • Refactored nod_rows.
  • Refactored nod_order.
  • Getting rid of dsql_nod.
  • Added sed script to set btyacc.
  • Started unifying DSQL/JRD sub-nodes.
March 2012

TRUNK
  • Simplify CastNode. There was no need for a format there.
  • Refactor DDL nodes removing references to non-value/-rse dsql_nod.
  • Refactored nod_field_name, nod_var_name, nod_array and nod_collate.
  • Make column_select a SubQueryNode instead of nod_select_expr directly.
V2.5 branch
  • Fixed CORE-3802 - Firebird runs out of memory while restoring database backup.
February 2012

TRUNK
  • Refactor COMMIT, ROLLBACK and SET TRANSACTION commands.
  • Refactor SELECT.
  • Refactor GRANT / REVOKE.
  • Checking fix for CORE-1347 for the 2.0.7 release
  • Remove legacy statements residuals.
  • Parser (request types).
V2.5 branch
  • Backported fix for CORE-1997 - Broken foreign key handling for multi-segmented index using multi-level collations.
  • Backported fix for CORE-2457 - UNICODE_CI internal gds software consistency check.
January  2012

TRUNK
  • Improvement CORE-3343 - RETURNING clause is not supported in positioned (WHERE CURRENT OF) UPDATE and DELETE statements.
  • Fixed CORE-1997 - Broken foreign key handling for multi-segmented index using multi-level collations.
  • Fixed CORE-2457 - UNICODE_CI internal gds software consistency check.
  • Fixed CORE-3737 - EXECUTE BLOCK parameters definitions are not respected and may cause wrong behavior related to character sets.
  • Fixed problem with default collation.
  • Removed READ/WRITE BLOB sql commands. / Refactored request operations to fix server crashes.
December  2011

TRUNK
  • Fixed the problem with windowed functions in recursive CTEs, reported by Frank Ingermann in fb-devel.
  • Fixed CORE-3683 - Recursive query with GROUP BY in root part: wrong results if no index exists for fields that are grouped.
  • Fixed CORE-3545 - Inconsistent domain's constraint validation in PSQL.
  • Fixed CORE-3382 - Incomplete description of POSITION() function.
  • Fixed CORE-3694 - internal Firebird consistency check in query with grouping by subquery+stored procedure+aggregate.
  • Fixed CORE-3238 - Makes GEN_UUID return a compliant RFC-4122 binary UUID and introduce CHAR_TO_UUID2 and UUID_TO_CHAR2 to convert UUIDs from/to string also complying with the RFC.
V2.5 branch
  • Backported fix for CORE-3601 - Incorrect TEXT BLOB charset transliteration on VIEW with trigger.
  • Backported fix for CORE-3238 - Makes GEN_UUID return a compliant RFC-4122 binary UUID and introduce CHAR_TO_UUID2 and UUID_TO_CHAR2 to convert UUIDs from/to string also complying with the RFC.
November  2011

TRUNK
  • Fixed CORE-3650 - Recreation of collation leads to FB "death".
  • Refactored legacy (UDF) function creation.
  • Extend ISQL' SHOW FUNCTION to take packages and parameter's datatype of non-legacy functions into account.
  • Apply CORE-3114 patch (Attempt to drop non-existing generator produces bad error) with some modifications.
  • Cleanup RECREATE commands and routine method names.
  • Feature CORE-3018 - RECREATE SEQUENCE/GENERATOR.
  • Refactor DDL commands: DROP INDEX, DROP FILTER, DROP SHADOW, CREATE/DROP ROLE and DROP USER.
  • Refactor DDL commands: ALTER EXTERNAL FUNCTION, ALTER INDEX, SET STATISTICS, CREATE SHADOW, ALTER ROLE, CREATE/ALTER DATABASE.
  • Fixed backup/restore of BOOLEAN columns.
October  2011

TRUNK
  • Finished CORE-1288 - Subprocedures in PSQL and EXECUTE BLOCK.
  • Feature CORE-3626 - Subfunctions in PSQL and EXECUTE BLOCK.
  • Improvement CORE-3639 - Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification.
  • Feature CORE-3619 - Windows function FIRST_VALUE.
  • Feature CORE-3620 - Window function LAST_VALUE.
  • Feature CORE-3621 - Window function NTH_VALUE.
  • Fixed CORE-3611 - Wrong data while retrieving from CTEs (or derived tables) with same column names.
  • Fixed CORE-3611 - Wrong data while retrieving from CTEs (or derived tables) with same column names.
  • Fixed ACL checking.
  • Avoid waste some bytes per record and procedure streams.
  • Avoid thrown exceptions in normal operation when loading non-existent ICU versions and in successful attachments. This was a pain in the debugger.
Adriano dos Santos Fernandes
Sao Paulo, Brazil