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
March to July 2010

July 2010

HEAD
  • Refactor CREATE/ALTER/DROP DOMAIN
  • Constify RecordSource methods - these classes are shared pieces of a (shared) statement
  • Refactor CREATE/ALTER/CREATE OR ALTER/RECREATE/DROP EXCEPTION commands
  • Refactor CREATE/ALTER/DROP/RECREATE TABLE and DROP VIEW commands
  • Create system constraints for better error reporting
  • CREATE VIEW refactor
  • Improvement CORE-3085 - Add clause ALTER DOMAIN [NOT] NULL
  • Fixed CORE-3091 - Built-in function POWER(X, Y) does not work when the X argument is negative and the Y value is scaled numeric but integral.
June 2010

HEAD
  • Finished Improvement CORE-3020 - Add clause RETURNING ... INTO ... to MERGE statement
  • Fixed the CMP debug code
  • Created class BlrWriter and reorganization (move BLR generation from statement to scratch)
  • Fixed CORE-3055 - Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
  • Fixed CORE-3056 - Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
  • Fixed CORE-3047 - Wrong logic is used to resolve EXECUTE BLOCK parameters collations
  • Improvement CORE-3057 - Allow the usage of blobs in COMPUTED BY expressions. Refactor DSQL "blocks"
  • Refactor CREATE/DROP COLLATION
  • Small METD cleanup
  • MSVC10 support.
2.5 Branch
  • Backport solution to a derived table problem
  • Fixed CORE-3038 - The insert failed because a column definition includes validation
  • Backported fix for CORE-2985 - The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
  • Backported fix for CORE-2893 - Expression in a subquery may be treated as invariant and produce incorrect results
  • Fixed CORE-2900 - "AV - The code attempted to access a virtual address without privilege to do so" using aggregate distinct
  • Fixed problem seen by Vlad where crash happens when our older ICU is found.
2.1 Branch
  • Backported fix for CORE-2900 - "AV - The code attempted to access a virtual address without privilege to do so" using aggregate distinct
2.0 Branch
  • Backported fix for CORE-2900 - "AV - The code attempted to access a virtual address without privilege to do so" using aggregate distinct
Other
  • Ongoing work to make the SVN repository usable
May 2010

HEAD
  • Fixed the UDR engine config file
  • Continued the work in subprocedures
  • Fixed CORE-2826 - Join condition fails for UTF-8 databases
  • Fixed CORE-2929 - 'Invalid ESCAPE sequence' when connecting to the database
  • Started Improvement CORE-3020 - Add clause RETURNING ... INTO ... to MERGE statement
  • Started working on fix for CORE-3056 - Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
V2.5 branch
  • Fixed crashes in Ubuntu 10.04
  • Subtask CORE-2996 - Fix error code incompatibility introduced in fix for CORE-2552
  • Backported fix for CORE-2826 - Join condition fails for UTF-8 databases
V2.1 branch
  • Backported fix for CORE-2826 - Join condition fails for UTF-8 databases
Miscellaneous
  • Started work on making the SVN repository usable
April 2010

HEAD
  • Fixed the problem of the system transaction storing pointer to random or already deallocated attachment
  • Fixed some TCS tests
  • Refactor user and system functions nodes
  • Fixed problem of ExprNodes in joins - "no current record" error
  • Cleanup - switch from pointer arithmetics to sane way to get impure places
  • Cleanup and thread safety fix in aggregate handling
  • Cleanup ­ request impure area and rpbs
  • Refactor jrd_req into JrdStatement (shared part) and jrd_req (execution of a statement). Fixed some bugs found on the way
  • Use AutoCacheRequest in all cacheable system requests. Fixes some request leakages
  • Fixed CORE-2971 - Invalid UPDATE OR INSERT usage may lead to successive "request depth exceeded. (Recursive definition?)" errors
  • Usage of AutoRequest
  • Start work in subprocedures
March 2010

HEAD
  • Fixed the bug reported by Ivan Prenosil (FB3 - problem with inactive triggers). It was the SortMap::flags not initialized
  • Fixed the DDL problem reported by Ivan Prenosil
  • Added a third optional (default is NULL) parameter to LAG and LEAD, that is the value returned when moving out of the partition
  • Fixed CORE-2910 - PK index is not used for derived tables
  • Fixed CORE-2913 - COLLATE expressions are applied incorrectly. Fixed CORE-2922 - Character set used in constants is not registered as dependency
  • Simplified the pattern matcher templates
  • Fixed CORE-2923 - Problem with dependencies between a procedure and a view using that procedure
  • Fixed the parameter handling in SUBSTRING(SIMILAR)
  • Fixed CORE-2932 ­ Wrong field position after ALTER POSITION
  • Improvement CORE-2005 - Support SQL 2008 syntax for MERGE statement with DELETE extension
V2.5 branch
  • Fixed CORE-2898 - CHAR_TO_UUID and UUID_TO_CHAR worked differently in big/little endian architectures
  • Fixed CORE-2923 - Problem with dependencies between a procedure and a view using that procedure
  • Fixed CORE-2930 - DROP VIEW drops output parameters of used stored procedures.
Adriano dos Santos Fernandes
Sao Paulo, Brazil
March to July 2010

July 2010

HEAD
  • Refactor CREATE/ALTER/DROP DOMAIN
  • Constify RecordSource methods - these classes are shared pieces of a (shared) statement
  • Refactor CREATE/ALTER/CREATE OR ALTER/RECREATE/DROP EXCEPTION commands
  • Refactor CREATE/ALTER/DROP/RECREATE TABLE and DROP VIEW commands
  • Create system constraints for better error reporting
  • CREATE VIEW refactor
  • Improvement CORE-3085 - Add clause ALTER DOMAIN [NOT] NULL
  • Fixed CORE-3091 - Built-in function POWER(X, Y) does not work when the X argument is negative and the Y value is scaled numeric but integral.
June 2010

HEAD
  • Finished Improvement CORE-3020 - Add clause RETURNING ... INTO ... to MERGE statement
  • Fixed the CMP debug code
  • Created class BlrWriter and reorganization (move BLR generation from statement to scratch)
  • Fixed CORE-3055 - Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
  • Fixed CORE-3056 - Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
  • Fixed CORE-3047 - Wrong logic is used to resolve EXECUTE BLOCK parameters collations
  • Improvement CORE-3057 - Allow the usage of blobs in COMPUTED BY expressions. Refactor DSQL "blocks"
  • Refactor CREATE/DROP COLLATION
  • Small METD cleanup
  • MSVC10 support.
2.5 Branch
  • Backport solution to a derived table problem
  • Fixed CORE-3038 - The insert failed because a column definition includes validation
  • Backported fix for CORE-2985 - The new 2.5 feature to alter COMPUTED columns doesn't handle dependencies well
  • Backported fix for CORE-2893 - Expression in a subquery may be treated as invariant and produce incorrect results
  • Fixed CORE-2900 - "AV - The code attempted to access a virtual address without privilege to do so" using aggregate distinct
  • Fixed problem seen by Vlad where crash happens when our older ICU is found.
2.1 Branch
  • Backported fix for CORE-2900 - "AV - The code attempted to access a virtual address without privilege to do so" using aggregate distinct
2.0 Branch
  • Backported fix for CORE-2900 - "AV - The code attempted to access a virtual address without privilege to do so" using aggregate distinct
Other
  • Ongoing work to make the SVN repository usable
May 2010

HEAD
  • Fixed the UDR engine config file
  • Continued the work in subprocedures
  • Fixed CORE-2826 - Join condition fails for UTF-8 databases
  • Fixed CORE-2929 - 'Invalid ESCAPE sequence' when connecting to the database
  • Started Improvement CORE-3020 - Add clause RETURNING ... INTO ... to MERGE statement
  • Started working on fix for CORE-3056 - Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
V2.5 branch
  • Fixed crashes in Ubuntu 10.04
  • Subtask CORE-2996 - Fix error code incompatibility introduced in fix for CORE-2552
  • Backported fix for CORE-2826 - Join condition fails for UTF-8 databases
V2.1 branch
  • Backported fix for CORE-2826 - Join condition fails for UTF-8 databases
Miscellaneous
  • Started work on making the SVN repository usable
April 2010

HEAD
  • Fixed the problem of the system transaction storing pointer to random or already deallocated attachment
  • Fixed some TCS tests
  • Refactor user and system functions nodes
  • Fixed problem of ExprNodes in joins - "no current record" error
  • Cleanup - switch from pointer arithmetics to sane way to get impure places
  • Cleanup and thread safety fix in aggregate handling
  • Cleanup ­ request impure area and rpbs
  • Refactor jrd_req into JrdStatement (shared part) and jrd_req (execution of a statement). Fixed some bugs found on the way
  • Use AutoCacheRequest in all cacheable system requests. Fixes some request leakages
  • Fixed CORE-2971 - Invalid UPDATE OR INSERT usage may lead to successive "request depth exceeded. (Recursive definition?)" errors
  • Usage of AutoRequest
  • Start work in subprocedures
March 2010

HEAD
  • Fixed the bug reported by Ivan Prenosil (FB3 - problem with inactive triggers). It was the SortMap::flags not initialized
  • Fixed the DDL problem reported by Ivan Prenosil
  • Added a third optional (default is NULL) parameter to LAG and LEAD, that is the value returned when moving out of the partition
  • Fixed CORE-2910 - PK index is not used for derived tables
  • Fixed CORE-2913 - COLLATE expressions are applied incorrectly. Fixed CORE-2922 - Character set used in constants is not registered as dependency
  • Simplified the pattern matcher templates
  • Fixed CORE-2923 - Problem with dependencies between a procedure and a view using that procedure
  • Fixed the parameter handling in SUBSTRING(SIMILAR)
  • Fixed CORE-2932 ­ Wrong field position after ALTER POSITION
  • Improvement CORE-2005 - Support SQL 2008 syntax for MERGE statement with DELETE extension
V2.5 branch
  • Fixed CORE-2898 - CHAR_TO_UUID and UUID_TO_CHAR worked differently in big/little endian architectures
  • Fixed CORE-2923 - Problem with dependencies between a procedure and a view using that procedure
  • Fixed CORE-2930 - DROP VIEW drops output parameters of used stored procedures.
Adriano dos Santos Fernandes
Sao Paulo, Brazil