Contents

Copyright Notice c-treeACE V9.0 Release Notes FairCom Typographical Conventions c-treeACE SQL Critical Issues c-treeSQL Server Buffer Overruns Corrected Checkpoint Error 7054 Corrected with the c-treeSQL Server c-treeSQL Server Panic Corrected Resolved c-treeSQL Server Panic when using Parameters in a Predicate Clause c-treeSQL Client Connections no Longer Hang when the Server Connection Limit is Reached c-treeSQL Server Daemon:accept error Corrected on Solaris and SCO Operating Systems Improved Argument Handling With c-treeSQL Stored Procedures c-treeSQL Server Commits During Cost Calculations Serious Issues Improved c-treeSQL Server Query Stability First Row of LONG VARCHAR Fields Correctly Updated Automatic Recovery Error L64 Corrected LOCAL_DIRECTORY Server Keyword Behavior Corrected Proper Handling of SQL SYNONYMs RECBYT Index for First Index of Table Qualified User Defined Functions Fixed Proper Handling of Maximum Number of Connected Clients Microsoft Access Credentials with c-treeSQL ODBC Correct Queries with Scalar Function and Parameters in a WHERE Clause Correct Query Results with Self Join and Column Aliases Corrected LEFT OUTER JOIN Optimization when Used as a Predicate Clause Correct Handling of non-US ASCII Characters in Stored Procedure Java Strings Proper Joins with c-treeSQL LONGVAR Fields Improved TCP/IP Handling of accept() Call Failures c-treeSQL BIGINT Byte Order Change on HIGH_LOW Architectures Eliminated DLOK_ERR (42) During c-treeSQL INSERT Other Issues LONG VARCHAR Fields Properly Updated CT_BOOL Correctly Maps to SQL_BIT with SQL Table Import UPPER() Function Syntax Corrected c-treeSQL Log File no Longer Prevents Client Connection Correct Linking of Tables in MS Access Dropping a Constraint Executed by a User Other than the Constraint Creator Correct Query Results Returned When Using an OR Conjunction c-treeSQL ODBC SQLStatistics() Returns Correct Information Correct Number of Affected Rows Returned with SQLGetDiagField() Proper Return of LVARCHAR Data With SQLExecDirect() Removed Required DSN Connection Strings for the Direct Link ODBC Driver Correct Array Handling with Prepared Statements in JDBC More than 2000 Bytes Allowed with JDBC LVARCHAR Retrievals Proper Batch Resizing with the JDBC Driver Proper Batch Additions with VARBINARY Fields Correct JDBC Exception now Thrown when User Limit is Exceeded c-treeSQL Date Field Range Correct Join Handling in Queries Proper Cursor Close with Stored Procedure Resultsets c-treeSQL Server System Signal Handling Retrieval of LVARCHAR Fields Using the c-treeSQL ODBC Driver and ADO .NET Improved JDBC and ODBC Driver Handling of Empty Resultsets with Long Fields Proper Semicolon Syntax with ISQL Eliminated Overflow/Underflow Errors Involving Joins Corrected SELECT COUNT(*) from a Variable Length Table Without an Index Corrected JDBC -21043 Error Proper LVC Update with the c-treeSQL JDBC Driver in Autocommit Mode Improved c-treeSQL JDBC Performance when Resizing the SQLDA Object Physical File Name Changed with c-treeSQL RENAME TABLE Statement Increased Number of Network Backlog Users Allowed Deferred Key Add Operations For Update Of Transaction-Controlled Unique Index c-treeACE Server Critical Issues c-tree Server Hang Corrected Improved Shared Library Support on Linux Fatal Log Write no Longer Hangs Server at Shutdown CTSTATUS_SIZE and DIAGNOSTICS LOWL_FILE_IO Configuration Options no Longer Hang Server MEMORY_MONITOR Option no Longer Crashes Server on Windows 2000 Server no Longer Crashes when Passed a datno from BlockingISAMRead Maximum Connected Client Limit no Longer Terminates the c-tree Server "Abort node error" When Closing PREIMG files Serious Issues WRITE_ERR Notification Correct Path References with the Novell NLM Record Conversion Buffer Overflow Fixed Improved Dynamic Dump of HUGE files for c-tree Servers on Linux Dynamic Dump Includes Matching Filenames with Wildcards and LOCAL_DIRECTORY Configuration Keyword Proper Server Shutdown with the ADMIN_ENCRYPT Configuration Keyword Compacting HUGE Files with the c-tree Server Properly Returns all Records Corrected Connection Memory Leak Other Issues c-tree Server Timeout Feature on Shutdown File System Cache Now Flushed Before Physical Close Dynamic Dump Detects Incorrect Header Values for non-HUGE Files Update of Internal Unique File ID Corrected Correct Key Transformations with the Unicode Enabled Server VIRTUAL Open of Segmented File Corrected "Improper Shutdown Detected" Dialog Suppressed Proper Handling of Log Template Rename Failures SNAPSHOT Negative Statistics Output Corrected Correct Zero Timeout Handling with ctSysQueueRead Correct Return Values of System Queue Functions Update when a SCHSEG key Segment is Defined on a Unicode Field Automatic Switch to O_SYNC in Case of Direct I/O Error Correct SIGNAL_READY Syntax with Long Paths Invalid Space Management Index Root After Recovery TMPNAME_PATH for Rebuild Sort Work Files now Operates as Expected with the c-tree Server Correct GTEKEY Retrieval with 64-bit Memory File Key Values Read-Only Dynamic Dump Script Files Correct Index Recovery After a Checkpoint Splits a Transaction Commit SEQ8_ERR Added to System Message Management File Additional Errors Added to Server Shutdown Exclusions c-treeACE Defunct Process Cleanup with SIGNAL_READY Handling on Unix Systems c-treeACE for .NET New Dispose() Method for c-tree Plus for .NET Resolved Conflict Between ctNUMBER and CTNumber class Correct Return Types for GetFieldAsFloat() c-treeDB Critical Issues Memory Leak in ctdbFreeRecord Disappearing Records with ALTER_TABLE Resolved Serious Issues Dictionary Operations Now Properly Keeps All Locks ctdbBegin no Longer Fails When CTKEEP_MODE is Active Incorrect Index File Extension with Alter Table Corrected Proper AtlerTable() of non-HUGE Files c-treeDB Path Prefix Now Properly Constructed ctdbWriteRecord no Longer Fails when Unicode Segment is Defined c-treeDB Header and IFIL Modes now Match After Alter Table Table Open with CTOPEN_READONLY Disallows Record Add and Update Other Issues c-treeDB now Removes .FCZ Files After Alter Table Operation c-treeDB Index Name can now be Changed c-treeDB Now Returns Specific Errors for Duplicated Index Names Import of CT_DATE Field with Index Segment Mode of SGNSEG ctdbGetRecordBuffer() Buffer Return Corrected File Extension Detection Logic Now Working Correctly for Empty Extensions when Importing Files with ctsqlimp ctdbGetFieldNumber Does not Properly set the Error Owner Name Case Handling Corrected in c-treeDB Existing Databases Properly Checked when calling ctdbAddDatabase Correct Alter Table With a CT_FSTRING Field Length of 256 CT_CURRENCY now Valid for SNGSEG Segment Mode Proper Connect to a Database Created Inside a Transaction c-treeDB now Correctly Converts String to CTMONEY Corrected CTNumber Declarations Corrected Handling of Empty Variable Length Fields with c-treeDB Properly Built c-treeDB Target Keys with Conditional Indexes CTDBRET_NOSEGMENT Returned on Alter Table and Create Table ctdbFindRecord() with CTFIND_EQ mode and Indexes Allows Duplicates c-treeACE Serious Issues FPUTFGET Locking Issues Microsoft Hotfix for Windows Vista Locking Behaviors c-tree Plus FPUTFGET Locking with HUGE files on Windows Vista Testing Windows Vista Locking with c-tree Plus FPUTFGET FPUTFGET c-tree Library Modifications for Consistent Locking Proper Reference of Unused File Numbers with CLSFIL ISRL_ERR (554) with SCHSRL During Rebuild Corrected MACOSX - XCODE Syntax Error terr(8989) Under FPUTFGET Corrected Calling GetSymbolicNames() Now Returns Correct File Name Complete Update of File Sync List from Notification EQLKEY Now Checks for Invalid keyno Unused Debugging Code Removed in Hugefile Support ctLOCLIB with ctCLIENT Redirection Solved LOCLIB Memory Overwrite Fixed ctSysQueueRead Hang on Empty Queue Corrected Access Violation on c-tree Superfile Member Create or Open Extended Create Block Function Corrected Correct File Open with a Unicode Key Segment on an Index Member Correct Fileword Corruption in OPNRFILX Other Issues Current ISAM Positions after Batch Insertions Records on LOW_HIGH Platforms Record Offsets of Zero for Physical Order Batch Reads Supported Support System Queue Functions in LOCLIB mode Correct Return Values of System Queue Functions VDLK_ERR During RETVREC Call in Single User Mode Proper Deny Open of a Mirrored Pair of Segmented Files Transaction Control of Conditional Index Expressions Corrected FreeRange (FRERNG) Header File Fix Assignment of updateIFIL Now Preserves Previous IFIL Setting Old fileIDs Properly Properly Removed During Rebuild Corrected Serial Segment Test BLKIREC Properly Finds all Matching Records LTEREC Rroperly Returns Record with Key Value Equal to Target vtclose no Longer Fails in FPUTFGET Mode c-tree Status Log Write Failure Causes Process to Exit Support Range Functions when Huge File Support is Disabled Compiling the Standalone Model Without c-tree Superfile Support Correct Open of File with Unicode Key Segment Transaction Commit no Longer Fails with SEEK_ERR (35) Improved Sensitivity of ESTKEY Routine ISAM Context Data Properly Updated During Index Create or Delete Correct 8-byte Serial Number Usage REDIREC() no Longer Fails in Multi-User Multi-Threaded Mode Rebuild Now Correctly Purges Records with Duplicate Keys when c-tree is Initialized with USERPRF_PTHTMP Stable Index Sizes after Automatic Recovery ctCAMO support for c-tree Client Compiles Rebuild Callback with LOCLIB Mode Correct NTIM_ERR Returned by SYSMON() when a Time-out Occurs Correct Byte Ordering of nul Padded CT_STRINGs with the c-tree Plus ODBC Driver in Heterogeneous Environments Corrected Lock Dump Output Properly Initialized CMPIFIL() Callback Variables Improved Handling of Header Values Prevents KDUP_ERR with SRLSEG Keys c-treeACE Utilities Successful Rebuild of Segmented Files With no File ID Correct Restore of a Segmented Dynamic Dump File Avoid Unnecessary XCRE_ERR Error During Rebuild with Missing Indices c-tree Restore Utility Opens all ctTRNLOG files Restored from Dump IFIL-Based Rebuild Utility Correct Functions with Both -purge and -updifil Flush Standard Output Before ctclntrn and cthghtrn Utilities Exit dbload Memory Overwrite Corrected c-treeSQL dbdump Crash Corrected Correct Monitoring of a Large Number of Clients with the c-tree Statistics Utility ctstat Utility Returns Exit Code 101 sa_admin now adds New User Accounts to Specified Group ctstop Utility now Exits with a Non-Zero Return Code Dump Index Utility Support for Huge Files c-tree Configuration Settings Utility no Longer Requires Write Permissions Correct Mirrored File Handling with the Superfile Prepass Utility Correct Usage Output for IFIL-Based Rebuild Utility Index