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: DSQL/INTL Development
February to May 2020

May 2020

trunk
  • Finished fix for CORE-6271 - Bind time with time zone to legacy produces wrong values.
  • Added tzdata directory to MacOS package.
  • Fixed x86 Linux build in x64 OS.
  • Fixed Travis (Ubuntu Xenial) build
  • Improvement CORE-6308 - Make it possible to update list of time zones (names and ids) without source code recompilation.
  • Fixed CORE-6310 - Varchar length limit is not enforced when assigning string with trailing spaces in MBCS.
  • Fixed CORE-6314 - Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit.
  • Fixed CORE-6318 - CAST('NOW' as TIME) raises exception.
3.0 branch
  • Backport fix for Travis (Ubuntu Xenial) build.
  • Backported fix for CORE-6310 - Varchar length limit is not enforced when assigning string with trailing spaces in MBCS.
  • Backported fix for CORE-6314 - Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit.
  • Fixed CORE-6317 - Server is crashing on long GRANT statement.

April

trunk
  • Fixed CORE-6281 - Invalid timestamp errors with RDB$TIME_ZONE_UTIL.TRANSITIONS. 
  • Fixed CORE-6282 - Change type of MON$ATTACHMENTS.MON$IDLE_TIMER and MON$STATEMENTS.MON$STATEMENT_TIMER to TIMESTAMP WITH TIME ZONE.
  • Fixed CORE-6280 - MERGE statement loses parameters in WHEN (NOT) MATCHED clause that will never be matched, crashes server in some situations.
  • Started fix for CORE-6271 - Bind time with time zone to legacy produces wrong values.
  • Fixed CORE-6289 - Put RDB$ prefix in RDB$TIME_ZONE_UTIL.TRANSITIONS input/output parameters.
  • Added tzdata directory to Linux package and build option to configure its static location.
3.0 branch
  • Improvement CORE-6274 - Increase parse speed of long queries.
  • Backported fix for CORE-6280 - MERGE statement loses parameters in WHEN (NOT) MATCHED clause that will never be matched, crashes server in some situations.
  • Fixed CORE-6290 - Hex number used at end of statement (for exame with CREATE DOMAIN ... DEFAULT) may read invalid memory and produce wrong values or exceptions.

March

trunk
  • Investigating CORE-6133 - Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field with COLLATION.
  • Reviewing and testing PR #243 about CORE-5972 - Fix working external triggers with computed fields.
  • Fixed CORE-6262 - SHOW DOMAIN/TABLE does not display character set of system objects.
  • Frontported fix for CORE-6246 - Problem with too many number of columns in resultset.
3.0 branch
  • Shrink MacOS pkg size not including three copies of each ICU library.
  • Backported fix for CORE-6233 - Wrong dependencies of stored function on view after backup and restore.
  • Fixed CORE-6246 - Problem with too many number of columns in resultset.

February

trunk
  • Improvement CORE-6239 - Procedures and EXECUTE BLOCK without RETURNS should not be allowed to use SUSPEND.
  • Fixed CORE-6241 - Values greater than number of days between 01.01.0001 and 31.12.9999 (=3652058) can be added or subtracted from DATE.
  • Fixed CORE-6243 - Regression: v4 Beta 1 rejects POSITION element of v2.5 defined SQL2003 CREATE TRIGGER syntax. Unzip tzdata with unzip utility in Windows.
  • Investigating CORE-6240.
  • Reviewing branch none_gmt_fallback.
  • Fixed regression with conversion from hex literal in string to number.
3.0 branch
  • Started work on CORE-6246 - Problem with too many number of columns in resultset.
  • Fixed CORE-6250 - Signature mismatch when creating package body on identical packaged procedure header.
  • Fixed CORE-6251 - Regression: crash when built-in function LEFT() or RIGHT() missed 2nd argument (number of characters to be taken).
  • Shrink MacOS pkg size not including three copies of each ICU library.
Adriano dos Santos Fernandes
Sao Paulo, Brazil
February to May 2020

May 2020

trunk
  • Finished fix for CORE-6271 - Bind time with time zone to legacy produces wrong values.
  • Added tzdata directory to MacOS package.
  • Fixed x86 Linux build in x64 OS.
  • Fixed Travis (Ubuntu Xenial) build
  • Improvement CORE-6308 - Make it possible to update list of time zones (names and ids) without source code recompilation.
  • Fixed CORE-6310 - Varchar length limit is not enforced when assigning string with trailing spaces in MBCS.
  • Fixed CORE-6314 - Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit.
  • Fixed CORE-6318 - CAST('NOW' as TIME) raises exception.
3.0 branch
  • Backport fix for Travis (Ubuntu Xenial) build.
  • Backported fix for CORE-6310 - Varchar length limit is not enforced when assigning string with trailing spaces in MBCS.
  • Backported fix for CORE-6314 - Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit.
  • Fixed CORE-6317 - Server is crashing on long GRANT statement.

April

trunk
  • Fixed CORE-6281 - Invalid timestamp errors with RDB$TIME_ZONE_UTIL.TRANSITIONS. 
  • Fixed CORE-6282 - Change type of MON$ATTACHMENTS.MON$IDLE_TIMER and MON$STATEMENTS.MON$STATEMENT_TIMER to TIMESTAMP WITH TIME ZONE.
  • Fixed CORE-6280 - MERGE statement loses parameters in WHEN (NOT) MATCHED clause that will never be matched, crashes server in some situations.
  • Started fix for CORE-6271 - Bind time with time zone to legacy produces wrong values.
  • Fixed CORE-6289 - Put RDB$ prefix in RDB$TIME_ZONE_UTIL.TRANSITIONS input/output parameters.
  • Added tzdata directory to Linux package and build option to configure its static location.
3.0 branch
  • Improvement CORE-6274 - Increase parse speed of long queries.
  • Backported fix for CORE-6280 - MERGE statement loses parameters in WHEN (NOT) MATCHED clause that will never be matched, crashes server in some situations.
  • Fixed CORE-6290 - Hex number used at end of statement (for exame with CREATE DOMAIN ... DEFAULT) may read invalid memory and produce wrong values or exceptions.

March

trunk
  • Investigating CORE-6133 - Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field with COLLATION.
  • Reviewing and testing PR #243 about CORE-5972 - Fix working external triggers with computed fields.
  • Fixed CORE-6262 - SHOW DOMAIN/TABLE does not display character set of system objects.
  • Frontported fix for CORE-6246 - Problem with too many number of columns in resultset.
3.0 branch
  • Shrink MacOS pkg size not including three copies of each ICU library.
  • Backported fix for CORE-6233 - Wrong dependencies of stored function on view after backup and restore.
  • Fixed CORE-6246 - Problem with too many number of columns in resultset.

February

trunk
  • Improvement CORE-6239 - Procedures and EXECUTE BLOCK without RETURNS should not be allowed to use SUSPEND.
  • Fixed CORE-6241 - Values greater than number of days between 01.01.0001 and 31.12.9999 (=3652058) can be added or subtracted from DATE.
  • Fixed CORE-6243 - Regression: v4 Beta 1 rejects POSITION element of v2.5 defined SQL2003 CREATE TRIGGER syntax. Unzip tzdata with unzip utility in Windows.
  • Investigating CORE-6240.
  • Reviewing branch none_gmt_fallback.
  • Fixed regression with conversion from hex literal in string to number.
3.0 branch
  • Started work on CORE-6246 - Problem with too many number of columns in resultset.
  • Fixed CORE-6250 - Signature mismatch when creating package body on identical packaged procedure header.
  • Fixed CORE-6251 - Regression: crash when built-in function LEFT() or RIGHT() missed 2nd argument (number of characters to be taken).
  • Shrink MacOS pkg size not including three copies of each ICU library.
Adriano dos Santos Fernandes
Sao Paulo, Brazil