|
In This Chapter Resolved c-treeSQL Panic with WHERE Clause Subqueries Prevent c-treeACE SQL crash with OR-ed subquery Resolved Unhandled Exceptions When Executing an Explain Plan with c-treeACE Corrected c-treeACE SQL Panic Condition Relating to Internal Dictionary Caches Corrected c-treeACE SQL Memory Exception when Copying Databases Resolved c-treeACE SQL Server Crash on Unix Systems Improved Join Query Performance c-treeACE SQL Query Performance Improvements c-treeACE SQL Query Performance Improvements Improved Query Performance with Optimized Join Orders Faster Queries Through a Distinct Key Count c-treeACE SQL ON Clause Join Order Optimizations Improved JOIN Optimizations when Predicates are Included Correct c-treeACE SQL EXTRACT Scalar Function Ranges Corrected TOP ... ORDER BY ... c-treeSQL Query Results Correct LEFT OUTER JOINS Containing OR Conjunctions in an ON Clause Correct c-treeACE SQL Query Returns With BETWEEN Conditions Correct String Comparisons Within Case Insensitive Databases Prevent Re-use of Prepared c-treeACE SQL Statement Execution Errors Resolved DADV_ERR After c-treeSQL Transaction Isolation Level Change Correct Handling of c-treeSQL CONTAINS Clauses Larger than 127 Bytes Corrected Error 17101 During a DELETE Statement Corrected Error 17466 on Index Creation Avoid Unnecessary E69 Errors in CTSTATUS.FCS Correct Propagation of Errors in c-treeSQL Avoid c-treeACE JVM Error Messages when the JVM Environment is not Present Allow Deletion of Self Referential Foreign Keys in c-treeACE SQL Configurable c-treeACE SQL PRESERVE CURSOR Option SNAPSHOT Statistics for c-treeACE SQL Statement Cache Counters Updated Version Information in c-treeACE SQL Installation Built-in Stored Procedure to Switch Transaction Mode Improved Compile Options for the c-treeACE SQL Direct Link ODBC Driver Signal Batch Clean-up on Client Side Enhanced Batch Communication with the c-tree Server Improved CTUSERX() Functionality for Custom Server Operations Prevent Potential Rebuilt Data Corruption Improved File Block API Calls Disable Reuse of Deleted Space in Variable Length Transaction Controlled Memory Files Corrected LONGVARCHAR Field Handling with Fetch Ahead Logic Configuration of Server SQLDA Structure Size for Reduced Memory Usage with c-treeSQL Reduced Memory Usage in Fetch Ahead Buffers with c-treeSQL Reduced Memory Usage in Communications Buffers with c-treeSQL Reduced Static Array Usage for Memory Efficiency in c-treeSQL Corrected Memory Leakage in c-treeSQL ODBC Driver Memory Leaked Fixed in the c-treeSQL ODBC PRESERVE CURSOR Feature Avoid SKIP_MISSING_FILES with Transaction Dependent Files Detection of Missing Transaction Dependent Files During Automatic Recovery Correct CTSTATUS.FCS Location with CTSTATUS_SIZE Configuration Option Passing "NULL" as a JDBC Prepared Statement Parameter Proper Handling of LONG VARCHAR Fields on HIGH-LOW Architectures Improved Key Estimation from Partitioned Indexes Improved Partitioned File Creation Synchronization Improved Launching of SIGNAL_READY and SIGNAL_DOWN Processes "Transaction Persistent" Lock Support Permit Shared Reopen After a Transaction Controlled Header is Updated Improved Handling of Header Updates During Server Shutdown Two-Phase Transaction Support c-tree Data Record Filter Callback Dynamic Library Support |
