In This Chapter Corrected c-treeACE SQL Memory Leaks Additional Diagnostic Logging of SQL Errors Correct Results from Nested TOP Queries and ORDER BY Clause Consistent Results Using '+' as String Concatenation Operator Proper View Column Names c-treeACE SQL Java Runtime Engine Handling of Stored Procedure JAR Proper c-treeACE SQL User Defined Function Exception Handling Improved Checks on Security Calls for Index Members to Avoid WRITE_ERR Correct c-treeACE SQL PHP Handling for Queries Returning No Result Sets Corrected Scale Value for c-treeACE SQL MONEY Types Avoid c-treeACE SQL Exception on Modified Imported Tables c-treeACE SQL Default Value Usage Corrected for BIT Columns Retrieval of LONG VARBINARY Fields with c-treeACE SQL ADO.NET Data Provider Reduced c-treeACE SQL ADO.NET Buffer Allocations Avoid .NET LOH Improved LONG Column Support Query with Left Outer Join Returns Wrong Rows Correct SQL OR Clause Handling with Outer Joins and Nullable Columns Corrected VARCHAR String Handling for Empty Strings Proper Authorization When Using Table Alias 64-bit c-treeACE SQL ODBC Driver Corrections c-treeACE SQL TOP Sort Optimization Improved Query Times with Multiple Operator Support in ANL Joins c-treeACE SQL Query Timeout Now Resets to Zero c-treeACE SQL ADO.NET Provider Now Closes Thread for ThreadAbortException c-treeACE SQL ADO.NET ExecuteScalar() Altered to Close the Reader c-treeDB Internal Error Diagnostics c-treeACE SQL OR Optimization Enhancement Prevent Tuple ID Not Found Messages for Valid Result Sets Corrected Unhandled Exception in Execution Plan Output Corrected Unhandled Exception with c-treeACE SQL Connection Monitoring Corrected Memory Leak with DH_REBUILD_SEL_CUTOFF Improvements for Certain Long-Running Queries Invalid String Error Resolved When Specifying Selectivity Option Optimize c-treeACE SQL Left Outer Joins to Inner Joins When Applicable |