c-treeACE V10.0 Release Notes

Index

Symbols & Numeric A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Symbols & Numeric

64-bit c-treeACE SQL ODBC Driver Corrections

Additional Diagnostic Logging of SQL Errors

Allow Automatic Recovery of Uncommitted TRANDEP Files

ALTER TABLE now Disables Transaction Support for Partition Files

Avoid c-treeACE SQL Exception on Modified Imported Tables

Complete Record Retrieval with Non-Contiguous Ranges on Partitioned Files

Conditional Index Expression Changes

Consistent Results Using '+' as String Concatenation Operator

Correct c-treeACE SQL PHP Handling for Queries Returning No Result Sets

Correct File Modes Applied to Partioned Files During ALTER TABLE

Correct Free of All Locks with Persistent Transaction Locks Mode

Correct Index Name Reported for Duplicate Key Errors on Partitioned File Global Unique Indexes

Correct Initialization of c-treeACE SQL Pointers

Correct Rebuild of Covering Indexes for Partitioned Files

Correct Replication Agent Exception Handling with Failed File Opens

Correct Resource Updates at EOF

Correct Results from Nested TOP Queries and ORDER BY Clause

Correct SQL OR Clause Handling with Outer Joins and Nullable Columns

Correct Transaction Log Encryption Incompatibility

Correct Transaction Logging of Partitioned File Serial Segment Entries

Correct Unhandled Exception When Accessing Partitioned File Before Partition Members Have Been Created

Corrected Ability to Kill Dynamic Dump Threads

Corrected Automatic Recovery of Files with TRANDEP Renames / Deletes

Corrected Client Hangs on Local Server Updates

Corrected c-treeACE SQL Conditional Expression Buffer Length Exception

Corrected c-treeACE SQL ISQL Script Handling Parameters

Corrected c-treeACE SQL Memory Leaks

Corrected c-treeACE SQL References in an ORDER BY Clause

Corrected CVAL_ERR on Partial Record Reads

Corrected Data Length of CTUSER() Custom Output Data

Corrected Display of LONG VARBINARY Fields in c-treeACE SQL Explorer

Corrected Dynamic Dump File Extensions for Non-TRANPROC Files

Corrected Hangs with Data Filter Callbacks

Corrected Inappropriate DAR RBUF_ERR on File Opens

Corrected Memory Leak with DH_REBUILD_SEL_CUTOFF

Corrected Record Return for Range Retrieval Expressions on Partitioned Files

Corrected Scale Value for c-treeACE SQL MONEY Types

Corrected Shared Memory Client Hang on Windows

Corrected Unhandled Exception in Execution Plan Output

Corrected Unhandled Exception in Partitioned File Search Routine

Corrected Unhandled Exception with c-treeACE SQL Connection Monitoring

Corrected VARCHAR String Handling for Empty Strings

Corrective Checkpoint Logic for Buffer/Cache Pages Missing from Update Lists

Critical Production Updates

c-treeACE Fixes

c-treeACE now Skips Duplicate SetNodeName Transaction Log Entries for Faster Performance

c-treeACE SQL ADO.NET ExecuteScalar() Altered to Close the Reader

c-treeACE SQL ADO.NET Provider Now Closes Thread for ThreadAbortException

c-treeACE SQL Default Value Usage Corrected for BIT Columns

c-treeACE SQL Fixes

c-treeACE SQL Java Runtime Engine Handling of Stored Procedure JAR

c-treeACE SQL OR Optimization Enhancement

c-treeACE SQL Query Timeout Now Resets to Zero

c-treeACE SQL TOP Sort Optimization

c-treeDB Internal Error Diagnostics

Deferred Transaction File Number Assignment

Delete all Partitions When Deleting the Partition Host File

Diagnostic Logging of PCRP_ERR (724) and KLNK_ERR (25) Errors

Drop of non-Partition Index Files for Partitioned Tables in c-treeACE SQL

Enhanced Windows Service Shutdown Operations

Ensure Proper Mutex Control When Adding Buffers to Commit List

Faster Server Shutdown with Large Memory Allocations

IF_EXIST Syntax Handling in c-treeACE SQL Explorer

Improved Checks on Security Calls for Index Members to Avoid WRITE_ERR

Improved c-treeACE SQL Index Choice for ANL or Sort Based on Cardinality

Improved Internal Error Checking on Partitioned File Opens

Improved LONG Column Support

Improved Partition Purging

Improved Query Times with Multiple Operator Support in ANL Joins

Improved Use of Thread Safe Calls

Improvements for Certain Long-Running Queries

Invalid String Error Resolved When Specifying Selectivity Option

Latest Java Version Requirement

Lock Restoration when Local Record Reads Fail

Mapping of c-treeACE SQL ADO.NET Data Provider Time Fields

Notable Compatibility Changes

NULL Handling in Filter Expressions

Optimize c-treeACE SQL Left Outer Joins to Inner Joins When Applicable

Partitioned File Fixes

Permit Shared Reopen After a Transaction Controlled Header is Updated

Persistent Transaction Lock State now Ignored for Unlock Requests Outside Transactions

Prevent c-treeACE SQL c-treeDB Internal Errors From Reused Partitioned Members

Prevent Overlapping Checkpoints

Prevent READ_ERR during Replication Log Reads

Prevent Tuple ID Not Found Messages for Valid Result Sets

PRIME_CACHE and PRIME_INDEX Configuration Options Parsing Corrected

Proper Authorization When Using Table Alias

Proper c-treeACE SQL User Defined Function Exception Handling

Proper View Column Names

Provide Connected User List for Partition Administration Exceptions

Query with Left Outer Join Returns Wrong Rows

Reduced c-treeACE SQL ADO.NET Buffer Allocations Avoid .NET LOH

Reinitialize Arrays to Prevent Unhandled Exceptions When Opening Partitions

Removed Savepoint COUNT Limitation

Replication Fixes

Resolved c-treeACE Unhandled Exception from Failed Filter Callback Library Loading

Resolved Filter Callback Function 160 Errors

Retain Purged Partitioned Member Information of Reused Partitions

Retrieval of LONG VARBINARY Fields with c-treeACE SQL ADO.NET Data Provider

Revised Integer Comparisons in Expression Parser

Rollback and Commit Support in c-treeACE ADO.NET Data Provider

SERVER_DIRECTORY Configuration Option Deprecated

Switch to Sbyte for TINYINT Signed Values in ADO.NET Data Provider

TCtDataSet Fields Property Type Has Changed in c-treeACE VCL

Tool Fixes

updates

Updates to ctunf1 File Format Conversion Utility Corrected Byte Reversal of Extended Headers

V10.0 Release Notes

V9.1 Client/Server Compatibility