October 2011 to June 2012

June 2012

New development

• Major refactoring of the lock management
• Improved error reporting for constraint violations and some DFW (at commit) errors

Bugfixing

• CORE-3873: Server crashes while switching to the shadow if the disk I/O fault happens while flushing the cache
• CORE-3853 and CORE-3675 (related regressions)

Miscellaneous

• Preparation for v2.5.2 release

May 2012

Bugfixing

• CORE-3557: AV in engine when preparing query against dropping table (new regressions resolved)
• Unregistered regression after fixing CORE-3777

Miscellaneous

• Preparation for v2.1.5 release

April 2012

New development

• Added some missing code for PSQL functions

Bugfixing

• CORE-3834: Usage of a NATURAL JOIN with a derived table crashes the server
• CORE-3807: Error "Invalid expression in the select list" can be unexpectedly raised if a string literal is used inside a GROUP BY clause in a multi-byte connection
• CORE-3686: Incorrect (zero) values are reported for "acquire blocks" and "mutex wait" counters in the fb_lock_print output
• CORE-3806: Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause
• Unregistered case of wrong error diagnostics that could cause to a database corruption

March 2012

New development

• ODS: made the jump nodes unconditional and integrated the jumping information natively into the index bucket

Bugfixing

• CORE-3791: Performance degrades when actively working with databases bigger than the available RAM amount
• CORE-1992: bad BLR -- invalid stream for union select
• CORE-3092: ROW_COUNT is not cleared before the singleton INSERT statement
• CORE-3625: MON$IO_STATS doesn't report page writes performed asynchronously (at the AST level)
• CORE-3569: CHAR(32767) present in XSQLVAR with length 32765
• CORE-2286: Selecting from MON$CALL_STACK within a Trigger or SP sometimes return 0 rows
• CORE-3777: Conversion error from string when using GROUP BY
• CORE-3798: Server dies when carry out the LEFT + INNER JOIN
• Backported CORE-3553, CORE-3457, CORE-3697, CORE-2422

February 2012

New development

• Improved the lock table validation logic

Bugfixing

• CORE-3761: Conversion error when using a blob as an argument for the EXCEPTION statement
• CORE-3753: The trigger together with the operator MERGE if in a condition of connection ON contains new isn't compiled

January 2012

New development

• Removed support for the remote protocol versions prior to v10
• Restricted ALTER/DROP permissions to the object owners only. Now this applies to domains, charsets, collations, generators and exceptions.
• Opened the gates to implement the standard USAGE privilege (CORE-2884)
• Refactored CREATE/ALTER USER code
• Refactored the low-level index nodes handling code
• Refactoring and bugfixing in the XDR protocol
• Added a few indices on system tables to avoid full table scans
• Disallowed deletions from RDB$DATABASE

Bugfixing

• CORE-3730: isc_dsql_exec_immed2() loses input parameter value with RETURNING clause
• CORE-3722: IS NOT DISTINCT FROM NULL doesn't use index

Miscellaneous

• Preparation for v2.0.7 release

December 2011

New development

• A number of fixes regarding the new authentication logic in Windows builds
• Removed LockGrantOrder in favor of unconditionally fair order
• Improved the lock manager to better support the shared cache

Bug Fixing

• CORE-3697: String truncation error when selecting from a VIEW with UNION inside
• CORE-3683: Wrong results if the recursive query contains an embedded GROUP BY clause
• CORE-3692: Cannot drop a NOT NULL constraint on a field participating in the UNIQUE constraint
• CORE-927: Grants don't work for procedures used inside views
• CORE-3490: Concurrency problem when using named cursors

November 2011

New development

• Small optimizations in the mover/converter code
• Fixed the races leading to server crashes

Miscellaneous

• Firebird conference in Luxembourg

October 2011

New development

• Refactored the database shutdown logic
• CORE-927: Grants don't work for procedures used inside views
• Refactored the thread initialization, especially in AST and BG threads.
• Replaced active request count with an explicit list of active requests

Dmitry Yemanov
Penza, Russia