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
May to August 2015
 
August  2015
 
trunk
  • Finished fix for CORE-4880 - Increase speed of creating package when number of its functions more than several hundreds.
  • Improvement CORE-4898 - Speed up function creation and loading whenthere are many functions in the database.
  • Verifying CORE-4892.
  • Fixed CORE-4884 - Crash on pasring of script containing `execute block` with lot of nested begin..end statements.
  • Verifying CORE-4587 - Compiling the packages is impossible - lock conflict on no wait transaction...
  • Fixed (again) CORE-3545 - Inconsistent domain's constraint validation in PSQL. Related to CORE-3947.
  • Fixed broken display of charset name with SQLDA_DISPLAY in ISQL
  • Fixed broken UTF-8 alignment in ISQL
  • Fixed CORE-4870 - SET COUNT ON: issuing UPDATE on view which was created WITH CHECK OPTION produces wrong number of affected rows (doubled ?).
  • Fixed blr print for blr_pid2.
  • Fixed possible similar problems to CORE-4497.
  • Fixed CORE-4917 - ALTER DOMAIN ... TO allows to specify matching to 'RDB$[[:DIGIT:]]*'.
  • Backported fix for CORE-4917 - ALTER DOMAIN ... TO allows to specify matching to 'RDB$[[:DIGIT:]]*'.
2.5 branch
  • Fixed CORE-4905 - Invalid internal BLR filter conversion.
July  2015

trunk
  • Finished fix for CORE-4848 - MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed.
  • Fixed CORE-4846 - Altering a trigger indicating other table than the original does not reflect the change.
  • Fixed CORE-4277 - Can create database with invalid character set.
  • Fixed CORE-4279 - Invalid error message: "CHARACTER SET OCTETS is not defined" on db creation with isc_dpb_lc_ctype = OCTETS.
  • Improvement CORE-4881 - Increase maximum string literal length to 64K (bytes) while setting a lower limit (of characters) for multibyte charsets based on their max char. length (UTF-8 literals will be limited to 16383 characters).
  • Fixed CORE-4882 - ISQL input command (or -i option) reads large (>64K) lines incorrectly.
  • Started fix for CORE-4880 - Increase speed of creating package when number of its functions more than several hundreds.
  • Restored sourceforge svn lost commits and fixed the github mirror.
  • Fixed CORE-4887 - AFTER CREATE/ALTER PACKAGE DDL triggers runs in incorrect moment.
2.5 branch
  • Fixed CORE-4276 - Error on create table with "CHARACTER SET DOS775" field.
June 2015
 
trunk
  • Finished code to print the parser/executable tree to XML for debugging purposes.
  • Integrate the github mirror with Travis CI.
  • Fixed CORE-4807 - Regression: List of aggregation is not checked properly.
  • Verifying bugs CORE-4829, CORE-4825, CORE-4843 and CORE-4844.
  • Postfix for CORE-4740 - SIMILAR TO with quantifier {n,} in the pattern: 1) fails on 2.5 ("Invalid pattern"), 2) strange result in 3.0.
  • Reviewing CORE-4177 comments.
  • Fixing the problem with examples build in Windows 64-bit.
  • Started fix for CORE-4848 - MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed.
May 2015
 
trunk
  • Copy new API include files to the Linux target directory.
  • Fixed CORE-4781 - Maximum string length (32765 bytes) is not validated.
  • Fixed CORE-4782 - Command `SHOW TABLE` fails when the table contains field with unicode collationin its DDL.
  • Verifying CORE-4787 - Index on field defined with "collate unicode_ci" is not used in GROUP BY on that field.
  • Fixed CORE-4735 - Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists).
  • Improvement CORE-4791 - Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions.
  • Investigating Pavel's comment in CORE-1366.
  • Fixed CORE-4740 - SIMILAR TO with quantifier {n,} in the pattern: 1) fails on 2.5 ("Invalid pattern"), 2) strange result in 3.0.
  • Investigating CORE-4803 - Accent-insensitive comparison of cyrillic 'И' (U+0418) and 'Й' (U+0419) should be the same as 'Е' (U+0415) and 'Ё' (U+0401).
  • Fixed CORE-4807 - Regression: List of aggregation is not checked properly.
  • Started code to print the parser/executable tree to XML for debugging purposes.
  • Fixed CORE-4819 - EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck.
2.5 branch
  • Fixed CORE-4789 - Prohibit ability to cast timestamps that out of valid range to varchar.
Adriano dos Santos Fernandes
Sao Paulo, Brazil
May to August 2015
 
August  2015
 
trunk
  • Finished fix for CORE-4880 - Increase speed of creating package when number of its functions more than several hundreds.
  • Improvement CORE-4898 - Speed up function creation and loading whenthere are many functions in the database.
  • Verifying CORE-4892.
  • Fixed CORE-4884 - Crash on pasring of script containing `execute block` with lot of nested begin..end statements.
  • Verifying CORE-4587 - Compiling the packages is impossible - lock conflict on no wait transaction...
  • Fixed (again) CORE-3545 - Inconsistent domain's constraint validation in PSQL. Related to CORE-3947.
  • Fixed broken display of charset name with SQLDA_DISPLAY in ISQL
  • Fixed broken UTF-8 alignment in ISQL
  • Fixed CORE-4870 - SET COUNT ON: issuing UPDATE on view which was created WITH CHECK OPTION produces wrong number of affected rows (doubled ?).
  • Fixed blr print for blr_pid2.
  • Fixed possible similar problems to CORE-4497.
  • Fixed CORE-4917 - ALTER DOMAIN ... TO allows to specify matching to 'RDB$[[:DIGIT:]]*'.
  • Backported fix for CORE-4917 - ALTER DOMAIN ... TO allows to specify matching to 'RDB$[[:DIGIT:]]*'.
2.5 branch
  • Fixed CORE-4905 - Invalid internal BLR filter conversion.
July  2015

trunk
  • Finished fix for CORE-4848 - MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed.
  • Fixed CORE-4846 - Altering a trigger indicating other table than the original does not reflect the change.
  • Fixed CORE-4277 - Can create database with invalid character set.
  • Fixed CORE-4279 - Invalid error message: "CHARACTER SET OCTETS is not defined" on db creation with isc_dpb_lc_ctype = OCTETS.
  • Improvement CORE-4881 - Increase maximum string literal length to 64K (bytes) while setting a lower limit (of characters) for multibyte charsets based on their max char. length (UTF-8 literals will be limited to 16383 characters).
  • Fixed CORE-4882 - ISQL input command (or -i option) reads large (>64K) lines incorrectly.
  • Started fix for CORE-4880 - Increase speed of creating package when number of its functions more than several hundreds.
  • Restored sourceforge svn lost commits and fixed the github mirror.
  • Fixed CORE-4887 - AFTER CREATE/ALTER PACKAGE DDL triggers runs in incorrect moment.
2.5 branch
  • Fixed CORE-4276 - Error on create table with "CHARACTER SET DOS775" field.
June 2015
 
trunk
  • Finished code to print the parser/executable tree to XML for debugging purposes.
  • Integrate the github mirror with Travis CI.
  • Fixed CORE-4807 - Regression: List of aggregation is not checked properly.
  • Verifying bugs CORE-4829, CORE-4825, CORE-4843 and CORE-4844.
  • Postfix for CORE-4740 - SIMILAR TO with quantifier {n,} in the pattern: 1) fails on 2.5 ("Invalid pattern"), 2) strange result in 3.0.
  • Reviewing CORE-4177 comments.
  • Fixing the problem with examples build in Windows 64-bit.
  • Started fix for CORE-4848 - MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed.
May 2015
 
trunk
  • Copy new API include files to the Linux target directory.
  • Fixed CORE-4781 - Maximum string length (32765 bytes) is not validated.
  • Fixed CORE-4782 - Command `SHOW TABLE` fails when the table contains field with unicode collationin its DDL.
  • Verifying CORE-4787 - Index on field defined with "collate unicode_ci" is not used in GROUP BY on that field.
  • Fixed CORE-4735 - Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists).
  • Improvement CORE-4791 - Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions.
  • Investigating Pavel's comment in CORE-1366.
  • Fixed CORE-4740 - SIMILAR TO with quantifier {n,} in the pattern: 1) fails on 2.5 ("Invalid pattern"), 2) strange result in 3.0.
  • Investigating CORE-4803 - Accent-insensitive comparison of cyrillic 'И' (U+0418) and 'Й' (U+0419) should be the same as 'Е' (U+0415) and 'Ё' (U+0401).
  • Fixed CORE-4807 - Regression: List of aggregation is not checked properly.
  • Started code to print the parser/executable tree to XML for debugging purposes.
  • Fixed CORE-4819 - EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck.
2.5 branch
  • Fixed CORE-4789 - Prohibit ability to cast timestamps that out of valid range to varchar.
Adriano dos Santos Fernandes
Sao Paulo, Brazil