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