Contents

Copyright Notice Version V9.1.1 Release Notes FairCom Typographical Conventions Critical Production Updates Potential c-tree Server Automatic Recovery Failures with the LOGIDX Feature Correct Handling of Segmented Files During Automatic Recovery Prevent Server Termination of c-treeACE from Data and/or Index LRU Cache Miss Limitations Resolved 2GB c-tree File Limitations on Linux Fresh Additions Core c-treeACE SQL Performance Enhancements Distinct Key Count for Improved c-treeACE SQL Query Efficiency Dynamic Dump Options For Enhanced Performance Improved Transaction Log Template Copies CPU Affinity Check for IBM AIX Operating Systems Improved File Compaction Behavior for 6-Byte Transaction Enabled Files Added Platforms and Environments Notable Resolved Issues Windows Resource Error (1450) Configurable Retry Logic Improved Thread Safety of System Time Calls Correct Conditional Index Results with Zero-Length String Literals Allow c-treeACE V9 Conditional Expression Parser Field Names to Match Data Type Names Improved Performance of Delete Node Queue Management PreImage Memory Files are no Longer Promoted to TRANLOG files During a Dynamic Dump LOG_ENCRYPT Option Now Correctly Supported with Advanced Encryption Features and Fixes 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 ctfiltercbLoadLib() ctfiltercbUnloadLib() Filter Callback Errors c-treeACE SQL Enhancements Internal Stored Procedure Added to Verify Transaction Mode of SQL Tables Improved Shutdown Stability of the c-treeACE SQL Database Engine Faster Performance for Multi-Component Indices with Parameterized Queries New CodeGear 2009 Support for c-treeACE SQL DBX Built-in Stored Procedure Added to Return Server Thread ID Corrected c-treeACE SQL PANIC Resolved Resolved Server Crash in c-treeACE SQL Server Exception with Preserved Cursor Logic Corrected Prevent Potential Server Exception Viewing c-treeACE SQLExecution Plans Prevent c-treeACE SQL Shutdown Fault Avoid Communications Buffer Overrun JDBC OutOfMemory Exception Resolved Improved Query Performance Transforming LEFT OUTER JOINS to INNER JOINS Where Appropriate Improved Query Performance with Constant Predicate Values Avoid Duplicate Constraint Name Error Automatic Transaction Rollback Upon Deadlock Error Now Default Behavior for c-treeACE SQL Enhanced Prevention of Locking Deadlocks in c-treeACE SQL Improved Byte Order Handling Between c-treeACE SQL Client/Server Architectures Improved c-treeACE SQL Memory Efficiencies Correct Result Sets with Subquery Predicates in an ON Subquery Improved c-treeACE SQL Referential Integrity Checks LONGVARCHAR AND LONGVARBINARY Support Added to c-treeACE SQL PHP Corrected Pre-pended Owner Naming Convention in c-treeACE SQL ISO 8859-1 Support for c-treeACE SQL ADO.NET Data Provider Better Optimization of Outer Join Transformations Corrected Direct SQL BLOB Handling Reduced Logging of Unnecessary c-treeACE SQL Panic Messages Corrected Duplicate Rows Returned with JDBC Query Improved JDBC Updates of LONG VARCHAR Fields When no Matching Rows Improved Direct ODBC Driver Linking on Solaris Operating Systems Improved Long Binary Handling with c-treeACE SQL Improved Unicode Handling in CodeGear 2009 c-treeACE SQL dbX Components c-treeACE Enhancements Improved Parallel Performance with Distributed Cache Synchronization Controls Reduced Service Control Manager Messages in CTSTATUS.FCS with c-treeACE Running as a Windows Service c-treeACE API Function to Set Distinct Key Attribute Configurable Disk I/O Sizes on Windows OS I/O Block Sizes With Windows Systems Avoid Invalid Error Returns with Maximum I/O Size Disk Operations Mask Routine Dynamic Dump Messages in CTSTATUS.FCS CPU Count Included in cttest Output Elimination of Strict Serialization Warning Correct ctunf1 File Reformat Utility Byte Alignment on HP-UX Corrected Syntax Error When Compiling Standalone Models Change Response to FUNK_ERR(13) During Automatic Recovery Corrected LEOF_ERR After Automatic Recovery Improved Automatic Recovery in Single-User TRANRPROC Mode Resolved KLNK_ERR During Index Rebuild Corrected Build of c-treeACE .NET Client Assembly Option to Disable Auto TRNLOG Messages in CTSTATUS.FCS c-treeDB Enhancements Distinct Keys Index Feature in c-treeDB Unsigned 64 bit Integer Support Added Correct Key Transformations with c-treeDB ctdbWriteRecord Now Ignores Unlocking New Records Prevent c-treeDB Alter Table ISLN _ERR (115) Errors with Index Segment Changes Retain non-Mandatory Batch Modes with the c-treeDB Set Batch Function c-treeACE VCL Enhancements New VCL Node Name Support New CodeGear 2009 Support Index