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
February to May 2013

May 2013
 
trunk
  • Fixed CORE-4083 - Full outer join in derived table with coalesce (iif).
  • Fixed crash with CORE-3694 test-case.
  • Added PSQL functions syntax to package documentation.
  • Misc documentation.
  • Document CORE-2006 - Regular expression SUBSTRING.
  • Document CORE-832 - Add support for parameterized exceptions.
  • Fixed crash when calling unimplemented packaged procedures.
  • Changed package routines syntax to not need (nor accept) a semi-colon after "END".
  • Document subroutines (CORE-1288 and CORE-3626).
  • Fixed problem with LEAVE and CONTINUE syntaxes.
  • Document CORE-1209 - CONTINUE statement.
  • Added ALTER GENERATOR (as ALTER SEQUENCE) for consistency with the other SEQUENCE/GENERATOR commands.
  • Document CORE-3018 - RECREATE, ALTER and CREATE OR ALTER
  • SEQUENCE/GENERATOR statements.
  • Improve external triggers messages to work by field name (instead of field order).
  • Make the master interface available in UDR.
  • RAII usage in UdrCpp example.
  • Release Notes review.
2.5 branch
  • Backported fix for CORE-4083 - Full outer join in derived table with coalesce (iif).
 
April 2013
 
trunk
  • Revert external routines to request-based code, but now using a totally different internal approach.
  • Fixed CORE-4073 - Constant columns getting empty value with subselect from procedure.
  • Apply patch by Treeve Jelbert to build against ICU 5.11.
  • Fixed CORE-4081 - Built-in functions and subselect no longer supported in "update or insert" value list.
  • Cleanup related to blr_stmt_expr.
  • Verifying new ICU versions for future Windows-build upgrade.
  • Document CORE-726 - Boolean data type.
  • Fixed CORE-4084 - GROUP BY fails if subselect-column is involved.
  • Document Window Functions.
  • Added FROM FIRST/LAST clause to NTH_VALUE (CORE-3621).
  • Fixed CORE-4083 - Full outer join in derived table with coalesce (iif).
  • Document CORE-1180 and CORE-3085 (ALTER ... NOT NULL).
  • Started a "Node printer" debug code.
March 2013
 
trunk
  • Fixing FB_MESSAGE macro and external functions and procedures.
  • Work in progress fixing external triggers.
  • Make line numbers of processed y-file matches parser.y lines.
  • Cleanups.
  • Fixed CORE-4061 - isql does not insert boolean values correctly, always shown as False.
  • Fixed CORE-4068 - create package fails on creating header as soon as there is at least 1 procedure name.
  • Fixed CORE-4067 - Problem with "CREATE DATABASE ... COLLATION ..." and 1 dialect.
  • Fixed problem reported in fb-devel: FB3 vs FB2.5: Different result for SUBSTRING('test' FROM 1 FOR NULL).
  • Fixed problem reported in fb-devel: FB3 and SQL_NULL.
  • Fixed CORE-4070 - NOT-NULL-column can be used as primary key and filled with NULL-values.
  • Fixed CORE-4071 - external function declaration with "returns parameter" crashes the server.
  • Revert external routines to request-based code, but now using a totally different internal approach.
  • Analysis of CORE-4060
  •  
February 2013
 
trunk
 
  • Working on converting the external engines API to the new style (IStatus, for example).
  • Parse BLR messages using BlrReader (and without duplicate code) to avoid segfaults with truncated or invalid data.
  • Fix SELECT FOR UPDATE problem related to r57615 change.
  • DSQL misc.
  • Fixing message header and UDR after Alex changes.
  • Replaced ICoerceMetadata with IMetadataBuilder and add a builder creator method in IMaster.
  • Working on IStatus.
  • Change message buffers type to void*.
  • Remove FbMessage struct from the API.
  • Fixing FB_MESSAGE macro and external functions and procedures.
2.5 branch
  • Improvement CORE-4047 - Increase number of input parameters for External Functions (UDFs) to 15.

Adriano dos Santos Fernandes
Sao Paulo, Brazil
February to May 2013

May 2013
 
trunk
  • Fixed CORE-4083 - Full outer join in derived table with coalesce (iif).
  • Fixed crash with CORE-3694 test-case.
  • Added PSQL functions syntax to package documentation.
  • Misc documentation.
  • Document CORE-2006 - Regular expression SUBSTRING.
  • Document CORE-832 - Add support for parameterized exceptions.
  • Fixed crash when calling unimplemented packaged procedures.
  • Changed package routines syntax to not need (nor accept) a semi-colon after "END".
  • Document subroutines (CORE-1288 and CORE-3626).
  • Fixed problem with LEAVE and CONTINUE syntaxes.
  • Document CORE-1209 - CONTINUE statement.
  • Added ALTER GENERATOR (as ALTER SEQUENCE) for consistency with the other SEQUENCE/GENERATOR commands.
  • Document CORE-3018 - RECREATE, ALTER and CREATE OR ALTER
  • SEQUENCE/GENERATOR statements.
  • Improve external triggers messages to work by field name (instead of field order).
  • Make the master interface available in UDR.
  • RAII usage in UdrCpp example.
  • Release Notes review.
2.5 branch
  • Backported fix for CORE-4083 - Full outer join in derived table with coalesce (iif).
 
April 2013
 
trunk
  • Revert external routines to request-based code, but now using a totally different internal approach.
  • Fixed CORE-4073 - Constant columns getting empty value with subselect from procedure.
  • Apply patch by Treeve Jelbert to build against ICU 5.11.
  • Fixed CORE-4081 - Built-in functions and subselect no longer supported in "update or insert" value list.
  • Cleanup related to blr_stmt_expr.
  • Verifying new ICU versions for future Windows-build upgrade.
  • Document CORE-726 - Boolean data type.
  • Fixed CORE-4084 - GROUP BY fails if subselect-column is involved.
  • Document Window Functions.
  • Added FROM FIRST/LAST clause to NTH_VALUE (CORE-3621).
  • Fixed CORE-4083 - Full outer join in derived table with coalesce (iif).
  • Document CORE-1180 and CORE-3085 (ALTER ... NOT NULL).
  • Started a "Node printer" debug code.
March 2013
 
trunk
  • Fixing FB_MESSAGE macro and external functions and procedures.
  • Work in progress fixing external triggers.
  • Make line numbers of processed y-file matches parser.y lines.
  • Cleanups.
  • Fixed CORE-4061 - isql does not insert boolean values correctly, always shown as False.
  • Fixed CORE-4068 - create package fails on creating header as soon as there is at least 1 procedure name.
  • Fixed CORE-4067 - Problem with "CREATE DATABASE ... COLLATION ..." and 1 dialect.
  • Fixed problem reported in fb-devel: FB3 vs FB2.5: Different result for SUBSTRING('test' FROM 1 FOR NULL).
  • Fixed problem reported in fb-devel: FB3 and SQL_NULL.
  • Fixed CORE-4070 - NOT-NULL-column can be used as primary key and filled with NULL-values.
  • Fixed CORE-4071 - external function declaration with "returns parameter" crashes the server.
  • Revert external routines to request-based code, but now using a totally different internal approach.
  • Analysis of CORE-4060
  •  
February 2013
 
trunk
 
  • Working on converting the external engines API to the new style (IStatus, for example).
  • Parse BLR messages using BlrReader (and without duplicate code) to avoid segfaults with truncated or invalid data.
  • Fix SELECT FOR UPDATE problem related to r57615 change.
  • DSQL misc.
  • Fixing message header and UDR after Alex changes.
  • Replaced ICoerceMetadata with IMetadataBuilder and add a builder creator method in IMaster.
  • Working on IStatus.
  • Change message buffers type to void*.
  • Remove FbMessage struct from the API.
  • Fixing FB_MESSAGE macro and external functions and procedures.
2.5 branch
  • Improvement CORE-4047 - Increase number of input parameters for External Functions (UDFs) to 15.

Adriano dos Santos Fernandes
Sao Paulo, Brazil