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
July 2012 to January 2013

January 2013

TRUNK
  • Migrate external triggers to the new message-based style.
  • Fixed a problem with CREATE COLLATION.
  • Fixed truncated error message for wrong CREATE COLLATION.
  • Started work on converting the external engines API to the new style
    (IStatus, for example).
December 2012

TRUNK
  • Refactor dsql_fld, TypeClause and ParameterClause. Eliminate some
    warnings.
  • Get rid of g_field_name hack.
  • Fixed CORE-4006 - Using a result from a procedure in a substring
    expression leads to server crash.
  • Get rid of dsql_str and fix metadata strings.
November 2012

TRUNK
  • Finished Improvement CORE-3972 - Allow the selection of SQL_INT64,
    SQL_DATE and SQL_TIME in dialect 1.
  • Finished Fixed CORE-3964 - It is not possible to create a ddl-trigger
    with "any DDL statement" clause.
  •  Fixed CORE-3966 - Creating a stored procedure with an "update or
    insert" statement with MATCHING fails.
October 2012

TRUNK
  • Fixed CORE-3946 - UNICODE collations does not work with ICU 49.
  • Started Improvement CORE-3972 - Allow the selection of SQL_INT64,
    SQL_DATE and SQL_TIME in dialect 1.
  • Started Fixed CORE-3964 - It is not possible to create a ddl-trigger
    with "any DDL statement" clause.
V2.5 branch
  • Backport fix for CORE-3946 - UNICODE collations does not work with ICU 49.
September 2012

TRUNK
  • Fixed CORE-3754 - SIMILAR TO works wrongly.
  • Improvement CORE-3919 - Improve SIMILAR TO performance.
  • Fixed database default charset being ignored.
  • DSQL Cleanup.
  • Fixed CORE-3929 - Error "attempted update of read-only column" when
    trying select minvalue from list with more than 255 elements.
  • Fixed assert reported by Vlad more some related problem.
  • Fixed CORE-3941 - Memory alignment problem with unique expression index.
August  2012

TRUNK
  • Fix segfault while checking for trace of failed statement compilation.
    (happens with CORE-3794 testcase).
  • Fixed CORE-3596 - Client library cannot connect to the non-ASCII host
    name.
  • Fixed CORE-1188 - Select Starting with :Param (Empty string) doesn't
    work if using index with many fields.
  • Fixed CORE-3052 - Wrong resultset.
  • Fixed CORE-3239 - UTF8 UNICODE_CI collate can not be used in compound index.
  • Improvement CORE-3546 - Aliases for the RETURNING clause.
  • Feature CORE-3291 - New pseudocolumn to get number of transaction that created this record version
  • Fixed CORE-3638 - Introduce FR_CA_CI_AI collation and change FR_FR and
    FR_FR_CI_AI to be identical to FR_CA and FR_CA_CI_AI respectively.
V2.5 branch
  • Fixed CORE-3902 - Derived fields may not be optimized via an index.
July 2012

TRUNK
  • Frontport UUID fixes (CORE-3238 and CORE-3887).
  • Fixed CORE-3893 - Cannot restore tpcc database in FB 3.0.
  • Fixed CORE-3894 - Wrong numbers in error message for decreasing char/varchar columns.
  • Fixed CORE-3883 - Ambiguous field name in the trigger when it does a select from the table.
  • Fixed CORE-3820 - RDB$TYPES contain duplicate character sets.
  • Fixed CORE-3899 - row_number(), rank() and dense_rank() return BIGINT datatype in dialect 1.
  • Creating C++ framework for API Methods.
V2.5 branch
  • Rework on CORE-3238 - Makes GEN_UUID return a compliant RFC-4122
    binary UUID.
  • Fixed CORE-3887 - CHAR_TO_UUID and UUID_TO_CHAR works different in big
    endian architectures - problem similar to CORE-2898.
Adriano dos Santos Fernandes
Sao Paulo, Brazil
July 2012 to January 2013

January 2013

TRUNK
  • Migrate external triggers to the new message-based style.
  • Fixed a problem with CREATE COLLATION.
  • Fixed truncated error message for wrong CREATE COLLATION.
  • Started work on converting the external engines API to the new style
    (IStatus, for example).
December 2012

TRUNK
  • Refactor dsql_fld, TypeClause and ParameterClause. Eliminate some
    warnings.
  • Get rid of g_field_name hack.
  • Fixed CORE-4006 - Using a result from a procedure in a substring
    expression leads to server crash.
  • Get rid of dsql_str and fix metadata strings.
November 2012

TRUNK
  • Finished Improvement CORE-3972 - Allow the selection of SQL_INT64,
    SQL_DATE and SQL_TIME in dialect 1.
  • Finished Fixed CORE-3964 - It is not possible to create a ddl-trigger
    with "any DDL statement" clause.
  •  Fixed CORE-3966 - Creating a stored procedure with an "update or
    insert" statement with MATCHING fails.
October 2012

TRUNK
  • Fixed CORE-3946 - UNICODE collations does not work with ICU 49.
  • Started Improvement CORE-3972 - Allow the selection of SQL_INT64,
    SQL_DATE and SQL_TIME in dialect 1.
  • Started Fixed CORE-3964 - It is not possible to create a ddl-trigger
    with "any DDL statement" clause.
V2.5 branch
  • Backport fix for CORE-3946 - UNICODE collations does not work with ICU 49.
September 2012

TRUNK
  • Fixed CORE-3754 - SIMILAR TO works wrongly.
  • Improvement CORE-3919 - Improve SIMILAR TO performance.
  • Fixed database default charset being ignored.
  • DSQL Cleanup.
  • Fixed CORE-3929 - Error "attempted update of read-only column" when
    trying select minvalue from list with more than 255 elements.
  • Fixed assert reported by Vlad more some related problem.
  • Fixed CORE-3941 - Memory alignment problem with unique expression index.
August  2012

TRUNK
  • Fix segfault while checking for trace of failed statement compilation.
    (happens with CORE-3794 testcase).
  • Fixed CORE-3596 - Client library cannot connect to the non-ASCII host
    name.
  • Fixed CORE-1188 - Select Starting with :Param (Empty string) doesn't
    work if using index with many fields.
  • Fixed CORE-3052 - Wrong resultset.
  • Fixed CORE-3239 - UTF8 UNICODE_CI collate can not be used in compound index.
  • Improvement CORE-3546 - Aliases for the RETURNING clause.
  • Feature CORE-3291 - New pseudocolumn to get number of transaction that created this record version
  • Fixed CORE-3638 - Introduce FR_CA_CI_AI collation and change FR_FR and
    FR_FR_CI_AI to be identical to FR_CA and FR_CA_CI_AI respectively.
V2.5 branch
  • Fixed CORE-3902 - Derived fields may not be optimized via an index.
July 2012

TRUNK
  • Frontport UUID fixes (CORE-3238 and CORE-3887).
  • Fixed CORE-3893 - Cannot restore tpcc database in FB 3.0.
  • Fixed CORE-3894 - Wrong numbers in error message for decreasing char/varchar columns.
  • Fixed CORE-3883 - Ambiguous field name in the trigger when it does a select from the table.
  • Fixed CORE-3820 - RDB$TYPES contain duplicate character sets.
  • Fixed CORE-3899 - row_number(), rank() and dense_rank() return BIGINT datatype in dialect 1.
  • Creating C++ framework for API Methods.
V2.5 branch
  • Rework on CORE-3238 - Makes GEN_UUID return a compliant RFC-4122
    binary UUID.
  • Fixed CORE-3887 - CHAR_TO_UUID and UUID_TO_CHAR works different in big
    endian architectures - problem similar to CORE-2898.
Adriano dos Santos Fernandes
Sao Paulo, Brazil