c-treeACE V10.0 Release Notes

V10.0 Release Notes Critical Production Updates Corrective Checkpoint Logic for Buffer/Cache Pages Missing from Update Lists Ensure Proper Mutex Control When Adding Buffers to Commit List Prevent Overlapping Checkpoints Corrected Dynamic Dump File Extensions for Non-TRANPROC Files Correct Initialization of c-treeACE SQL Pointers Corrected c-treeACE SQL References in an ORDER BY Clause Corrected c-treeACE SQL Conditional Expression Buffer Length Exception Notable Compatibility Changes Latest Java Version Requirement SERVER_DIRECTORY Configuration Option Deprecated Switch to Sbyte for TINYINT Signed Values in ADO.NET Data Provider Mapping of c-treeACE SQL ADO.NET Data Provider Time Fields Conditional Index Expression Changes Revised Integer Comparisons in Expression Parser Corrected CVAL_ERR on Partial Record Reads NULL Handling in Filter Expressions TCtDataSet Fields Property Type Has Changed in c-treeACE VCL V9.1 Client/Server Compatibility Rollback and Commit Support in c-treeACE ADO.NET Data Provider c-treeACE Fixes Corrected Inappropriate DAR RBUF_ERR on File Opens Faster Server Shutdown with Large Memory Allocations Enhanced Windows Service Shutdown Operations Corrected Ability to Kill Dynamic Dump Threads Deferred Transaction File Number Assignment c-treeACE now Skips Duplicate SetNodeName Transaction Log Entries for Faster Performance Permit Shared Reopen After a Transaction Controlled Header is Updated Allow Automatic Recovery of Uncommitted TRANDEP Files Correct Transaction Log Encryption Incompatibility PRIME_CACHE and PRIME_INDEX Configuration Options Parsing Corrected Resolved Filter Callback Function 160 Errors Corrected Hangs with Data Filter Callbacks Resolved c-treeACE Unhandled Exception from Failed Filter Callback Library Loading Persistent Transaction Lock State now Ignored for Unlock Requests Outside Transactions Correct Free of All Locks with Persistent Transaction Locks Mode Removed Savepoint COUNT Limitation Improved Use of Thread Safe Calls Corrected Data Length of CTUSER() Custom Output Data Correct Resource Updates at EOF Corrected Shared Memory Client Hang on Windows Corrected Automatic Recovery of Files with TRANDEP Renames / Deletes Partitioned File Fixes Reinitialize Arrays to Prevent Unhandled Exceptions When Opening Partitions ALTER TABLE now Disables Transaction Support for Partition Files Delete all Partitions When Deleting the Partition Host File Improved Internal Error Checking on Partitioned File Opens Drop of non-Partition Index Files for Partitioned Tables in c-treeACE SQL Corrected Record Return for Range Retrieval Expressions on Partitioned Files Correct File Modes Applied to Partioned Files During ALTER TABLE Complete Record Retrieval with Non-Contiguous Ranges on Partitioned Files Provide Connected User List for Partition Administration Exceptions Correct Index Name Reported for Duplicate Key Errors on Partitioned File Global Unique Indexes Correct Rebuild of Covering Indexes for Partitioned Files Correct Transaction Logging of Partitioned File Serial Segment Entries Corrected Unhandled Exception in Partitioned File Search Routine Diagnostic Logging of PCRP_ERR (724) and KLNK_ERR (25) Errors Improved Partition Purging Prevent c-treeACE SQL c-treeDB Internal Errors From Reused Partitioned Members Retain Purged Partitioned Member Information of Reused Partitions Improved c-treeACE SQL Index Choice for ANL or Sort Based on Cardinality Correct Unhandled Exception When Accessing Partitioned File Before Partition Members Have Been Created c-treeACE SQL Fixes 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 Replication Fixes Correct Replication Agent Exception Handling with Failed File Opens Lock Restoration when Local Record Reads Fail Corrected Client Hangs on Local Server Updates Prevent READ_ERR during Replication Log Reads Tool Fixes Corrected Display of LONG VARBINARY Fields in c-treeACE SQL Explorer IF_EXIST Syntax Handling in c-treeACE SQL Explorer Corrected c-treeACE SQL ISQL Script Handling Parameters Updates to ctunf1 File Format Conversion Utility Corrected Byte Reversal of Extended Headers Copyright Notice Index