Product Documentation

c-treeACE V10.0 Release Notes

Previous Topic

Next Topic

c-treeACE SQL Fixes

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

TOCIndex