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