c-treeACE V11.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

!CLNIDXX Script Option no Longer Crashes ctrdmp Restore Utility on 64-bit Systems

“Add Unique Keys First” Feature Applied to ctADD2END Files

“Change DIAGNOSTICS” Menu Option Restored for ctadmn Administrator Utility

ADO.NET Provider - Changed TINYINT Handling from byte to sbyte

ADO.NET Provider - Charset Option in Connection String Is not Longer Ignored

ADO.NET Provider - Corrected -20123 Error When Updating Rows with LONG Fields

ADO.NET Provider - Corrected LVARCHAR Empty String Handling

ADO.NET Provider - Corrected TimeStamp Values Returned

ADO.NET Provider - CtreeSqlDataReader Close() No Longer Aborts Automatic Transactions

ADO.NET Provider - FcSQLException Constructor Now Thread-Safe Preventing Initialization Errors

ADO.NET Provider - Improved Connection Pooling

ADO.NET Provider - Improved Exception Handling

ADO.NET Provider - Improved Handling of FLOAT, DOUBLE, and REAL Data Types

ADO.NET Provider - Improved Handling of NUMERIC Type

ADO.NET Provider - Last Byte Now Returned from LONG Columns with Length Less than Three

ADO.NET Provider - OUT Stored Procedures Parameters Now Correctly Set

ADO.NET Provider - OUT/INOUT SP parameters not set to NULL

ADO.NET Provider - Prevent Mixing Transaction Contexts

ADO.NET Provider - Prevent Reusing a Disposed CtreeSqlConnection

ADO.NET Provider - Removed Unexpected Assert Exceptions

ADO.NET Provider - SqlDataReader.GetSchemaTable() Now Returns Correct Information

ADO.NET Provider Exception Classes Made Serializable

AIX Clients No Longer Drop Inactive Shared Memory Connections

Allow a Single Byte or SByte to be passed as a BINARY Value in ADO.NET

Allow Connection Termination Requests to Interrupt Batch Operations

Allow Start of Unix-Based c-treeACE Server When Shared Memory Key Files Are Deleted

ALTER TABLE Now Checks REFERENCES Permissions When Adding Foreign Key Constraints

Automatic c-treeDB Batch Buffer Resize

Automatic Recovery Issues Corrected with Aborted Index Operations Introduced in V10.4

Auto-Numbering Replication Defaults Changed

Avoid Connection Errors If First COMM_PROTOCOL Module Fails to Initialize

Avoid Crash When Database Name Exceeds Maximum Length

Avoid CTDBRET_CANTCHKUID Error During ctdbConnect()

Avoid Error 4108 on Compressed Files During Batch Find

Avoid FairCom Server Termination with Internal Error 8987 When Using UNBUFFERED_IO Configuration Option

Avoid ICUR_ERR When Using Replication Agent Administrator

Avoid Infinite Parsing Recursion

Avoid Replication Agent Halt if Target Connection is Lost During Checkpoint Processing

Avoid Server Shutdown When Finding Outdated Transaction Log

Batch Update Now Correctly Recognizes BAT_RET_BLK Record Format

BATSETX no Longer Fails on First Call with a Buffer too Small

Blocking Record Read Improvements

Case-Insensitive CONTAINS Now Properly Matches Uppercase Data

Checkpoint Inconsistency Error Prevented with Deferred OPNTRAN Feature with Superfiles

Client Library Exception Corrected When ctWNGV is NULL

Client TFRMKEY API No Longer Writes Non-Zero High Word Record Offsets into Key Value

COMMIT_DELAY Configuration Now Defaults to 1 ms on Linux Systems

Communications Layer Fixes

Compact and Rebuild Utilities Now Correctly Update IFIL Resource When -updifil Option is Specified

Core Engine Updates and Corrections

Core System Updates

Correct Data File Counts Now Maintained After Resource Update Rollback

Correct Error Messages Now Returned by fc_create_user Procedure

Correct File Block Behavior with Unix File Access

Correct Handling of Recursive Subquery Clauses

Correct Key Value Now Updated with Physical Order Read and ISAM Key Buffers Disabled

Correct Length Now Always Set for CT_2STRING With setFieldAsBlob and setFieldAsString

Correct Results Now Returned When Subquery Contains SKIP

Correct Return of LVARCHAR Data When Using CT_STRING Data Type

Correct VARCHAR Data Now Returned in Complex Queries

Corrected Buffer Overruns When Using Direct SQL Interface

Corrected ctReplSetPosByTime Error 76

Corrected ctVERIFYidx Reports For Non-ctPREIMG Files With Key Marks

Corrected DH_REBUILD_SEL_CUTOFF Handling

Corrected Direct SQL Update of LONG Fields

Corrected Error Handling for ctVERIFYidx and ctVerifyFile APIs

Corrected Errors When Changing a Temporary Index Condition

Corrected GRANT of Column Permissions for non-DBA Users with Table Grant Permissions

Corrected Index Creation for Selected Imported Tables

Corrected Infinite Parser Loop

Corrected Memory Leak When Error Occurs Creating Table with IDENTITY Field

Corrected Prime Cache Thread Unhandled Exception When Opening File Pending Delete

Corrected Query Results with Literals Over 2048 Characters

Corrected Read and Write Errors after Connection Termination

Corrected Result Sets Returned with LEFT OUTER JOIN and TOP and SKIP Conditions

Corrected Rounding of Sub-Query Numeric Values

Corrected TRUNCATE Scalar Function Result

Corrected Unexpected FairCom Server Internal Error 7495 Crash

Corrected Unhandled Exception When File Password Included in Open File Call

Crashes and Hangs Corrected if an SQL Query Contains Many INNER JOINS Based on Equality

Create Table Now Updates sysindexes in Server DLL Model

Critical Production Updates

ctcv67 Now Includes Support for Partial Key Distinct Counts

ctdbAlterTable Now Retains Row-Level Security Information

ctdbFreeRecord Memory Leak Corrected When Record Set is Active

ctdbRenameTable Now Correctly Renames Index With Same Name as Table

ctdbRenameTable Now Renames Tables When Working Within SESSION_CTREE Mode

ctfdmp, ctldmp, and ctrdmp Utilities Now Display Version Information on Startup

ctGetFileUsers() Now Returns Correct User File Number for Multiple File Open Instances of a Single Connection

ctinfo Now Reports Mismatch Between Data and Index Filemode When Data File Has No Indexes

ctquiet Utility Now Accepts Passwords Over 16 Bytes

ctrdmp Stabilized During Recovery Phase

c-tree Server Name and Port Displayed in Windows System Tray Balloon

c-treeACE JDBC Java 1.5 Compatible Driver Availability

c-treeACE Memory Allocation Limit Disabled

c-treeACE Professional SDK Build Improvements

c-treeACE SQL APIs

c-treeACE SQL JDBC Socket Timeout Defaults to 0

c-treeACE SQL SETENV limit raised to 8192

c-treeACE SQL Stored Procedure Server-side Debugging Options

c-treeACE SQL Updates and Corrections

c-treeDB API Fixes

ctsqlcdb Now Returns Non-zero on Error

ctsqlutl Column Rename Improved

ctstap - Single-Threaded Version of Multi-Threaded Test

ctstat -filelocks and -userlocks Options Now Show Lock Information When a Large Number of Locks Are Held

cttrnmod No Longer Terminates with Unhandled Exception When Data File Uses Extension Other Than .dat

Deadlock Corrected in Data Cache Retrieval Function

Delete Node Queue Messages Now Suppressed by Default

Direct SQL - Corrected ctsqlNumericToString and ctsqlStringToNumeric Unicode Handling

Direct SQL - ctsqlSetParameter Memory Corruption Corrected

DLOK_ERR (42) Corrected for Memory File Add or Update Failures

DMAP_ERR (957) Corrected On Overlapping ISAM File Open/Close Calls

DSQL - ctsqlExecute() Unhandled Exception Corrected

Dynamic Dump and Restore Updates

Dynamic Dump Error now Returned to ctdump with !BLOCK_RETURN Option

Dynamic Dump Stream Files No Longer Segment by Default

Empty Column Names No Longer Returned When Column Length Is 64-characters

Ensure Correct Log Update for Very Large Transactions

Ensure SQL Database Creation at Server Startup Completes Before Allowing ISAM Connections and Server Shutdown

Error 133 and Long Connect Times Now Avoided During Many TCP/IP Disconnects

Error -20133 No Longer Improperly Returned When Setting UID in DEFAULT Clause

Error -20134 No Longer Returned When Setting LONG Fields to NULL

Error -20142 No Longer Returned with UDF Execution After Table Import

Error IAIX_ERR (608) Corrected When Compacting or Rebuilding Files Containing SRLSEG or SCHSEG Segment Modes

Errors 128, 150, and Possible Hangs Corrected With Batch Inserts or Updates Containing IDENTITY Fields and TCP/IP Connections

Errors Ignored When IP Address Return for Host System Fails

FairCom Server - Change defaults for V11 release

FairCom Typographical Conventions

Field Callbacks Added for CHAR and VARCHAR Fields

File Transfer with Unix Shared Memory No Longer Generates Client Exception

Fixed Memory Leak When Closing File without Freeing Range

Fixed Memory Leak When Creating Superfile Member with TRANPROC Support Disabled

Fixed Memory Leak When OPNIFIL Fails with Error 124

Flush ctdump Utility Filesystem Output Before Exiting

Flush ctstat Statistics Utility Output Before Pausing

FNOP_ERR (12) Corrected When Reopening Deferred Closed File with Alternate Path

GETIFIL No Longer Fails Due to Alignment Adjustments

Identify Legacy c-treeDB Segment Error More Clearly

Identity Field Now Properly Processed in ctdbInsertBatch

Identity Field Support Now Available in LOCLIB model with Single-User TRANPROC

IERR_COD (923) Corrected When Compacting VARLEN TRNLOG Data and COMPATIBILITY LOCK_EXCL_TRAN is in Use

IKRS_ERR (109) Corrected When Client Library Supports Fewer Key Segments Than Index Definition

Improved Error Handling for Replication Agent HTRN_ERR (520)

Improved Handling of Encryption Attributes During File Compact and Rebuild

Improved Replication Agent Handling of Compressed Records

Improved Server Stability When Using VSS For Backup

Improved Variable-Length Data File Space Management

Inconsistent FPUTFGET Header Locking for Non-HUGE Index Files and Variable-Length Data Files

Incorrect IICT Behaviors Corrected

Incorrect Index Member Key Counts Corrected When Using KEEPOPEN_LIST

Index Member Key Counts Now Properly Updated During Automatic Recovery

Interim Build Modifications

Introduction

ITIM_ERR (160) Corrected When CT_STRING UNCSEG Segment Is Not Null Terminated

Java Stored Procedure Runtime Classes no Longer Require ctreedbs in Path

JDBC - Allow Disabling Socket Timeout

JDBC - Character Set Can Now Be Specified in the Connection URL

JDBC - Corrected Error -26049 (Invalid column number) During SELECT ... FOR UPDATE Query

JDBC - Corrected Exception When Character Set Not Provided In URL Connection String

JDBC - DatabaseMetaData.getTable Now Conforms to JDBC Standards

JDBC - Driver.connect Method Now Compliant with Incorrect URL Handling

JDBC - Improved Type Conversion Error Message

JDBC - LVARCHAR Empty String Now Correctly Returned

JDBCjava.sql.Connection.isValid Now Returns Correct State

License File Handling Improvements

Linux File System Performance and Safety

LONG Type Stability Improvements

LONG VARBINARY Support Added for ORDER BY Clauses

Maintain Replication Agent Connection During Dynamic Dump of Target Server

MAX Scalar Function on Field With Descending Index No Longer Returns MIN Value

Maximum Index Members per File (MAXMEMB)

Maximum LIST_MEMORY Setting Increased to 10MB

Maximum Number of Indexes per Data File (MAX_DAT_KEY) Default Increased to 64

Maximum Number of Open Files per User (MAX_FILES_PER_USER) Default Increased to 32767

Memory Index Node Resources Now Properly Freed

Memory Leak in ISAM Unix Shared Memory Protocol Corrected

Memory Usage Stabilization

MHDR_ERR (549) Corrected With Mirrored File Opens

Modified Rebuild Callback Event Handling

Multiple “Internal Error” Conditions Corrected

Named User Counts Now Correctly Applied at Group Level

New Extended Data Types Support

Non c-tree Files Now Back Up to Correct Directory

Non-HUGE Reads Past 4GB Now Correctly Return Error

Notable Compatibility Changes

ODBC - Infinite Loop Corrected in Client Driver

ODBC - SQL_C_DEFAULT Now Correctly Maps BIGINT to 64-bit Integer

ODBC - SQL_ROWSET_SIZE Attribute Now Returns Correct Number of Rows

ODBC - SQLBindCol with NULL Indicator and ROWSET Size > 1 No Longer Crashes Client

ODBC - SQLExecDirect with Parameters Set to SQL_DATA_AT_EXEC No Longer Generates Client Crash or Syntax Error

ODBC - SQLGetData Memory Overwrite Corrected

ODBC - SQLGetInfo Returns Corrected Information

ODBC - SQLGetTypeInfo Returns Corrected Information

ODBC - SQLNativeSql Now Returns Correct Statement Length

ODBC - SQLSetCursorName Corrected Buffer Addressing

Optimizer Improvements for Field Type Constraints

Optional c-treeACE READ_ERR Diagnostic Logging

Partial Sort Table Scan No Longer Eliminates Potentially Significant Records

Path Separator Now Automatically Appended to TMPNAME_PATH Directory

Permit Failed FairCom Server ctThrdInit() Calls to Return to Caller Instead of Exiting Process

PHP - Components Now Match non-Thread-Safe Defaults for Windows IIS PHP Installations

PHP - Integer Values Now Correctly Handled

Physical read of variable-length transaction controlled file skips records added by a third-party transaction not yet committed

Prevent Crash During Outer Join Optimization

Prevent Crash From ODBC SQLCursor() Call With NULL

Prevent Crash When Creating Dynamic Indexes

Prevent Crash With ON Clauses Containing Sub-Queries

Prevent c-tree Server Unhandled Exception During Update of Compressed Record

Prevent c-treeACE SQL Termination When Accessing LONG Types

Prevent FairCom Server WRITE_ERR Termination with Open Transactions Aborted by Quiesce

Prevent Large Number of IN Values Causing a Server Crash

Prevent LEOF_ERR Errors After Forward Roll

Prevent MM Subsystem Crash

Prevent Potential Crash While Reading LONG VARCHAR Data

Prevent Replication Agent Termination Related to Locked State Record on Target Server

Prevent SQL PANIC Condition with Selected Queries

Prevent TNON_ERR (71) From ctdbRemoveTable

Prevent Unhandled Exception for SQL Insert Statements Involving ROWID

Prevent Unhandled Exception When a Single Connection Opens a File More than 1024 Times

Proper Dynamic Dump Subdirectory Creation on Unix

Proper Errors Now Returned by ctdbGetIndexByUID

Proper NULL Values Now Returned for LVARCHAR Columns When Sorting for ORDER BY

Proper positioning of ctdbSeekRecord with active record sets

Query Speed Improved From Dynamic Index Usage

Relaxed COMPATIBILITY FORCE_WRITETHRU Defaults

RENF_ERR (67) Corrected During File Compact

Replication Agent Stability Improvements

Replication Agent Updates

REVOKE GRANT OPTION Now Correctly Removes Column Permissions

RRED_ERR (407) Corrected When Rebuilding VARLEN FPUTFGET Indexes

Server Engine Updates

Server process exit code more informative

SESSION_TIMEOUT Improvements

Shutting Down with Connected Clients on Unix Now Frees Shared Memory Resources

Sort Error 484 Corrected During Sort File Create With Large Number of Keys

Specify Shared Memory Keys on Unix

SQL - BINARY fields not padded with 0x00

SQL - Changed error message for error -20139

Support Partial Record Rewrite in Local/Master Synchronous Replication

Suppress Logging "file is opened without mirror" When MIRRORS NO is Specified

Suppress SSL Library Loading Error Messages on Server Start Up

SUSER_NAME and USER_NAME Scalar Functions Improved

SYSDATE Default Field Values Now Allowed With ALTER TABLE

Transaction Control and Recovery Strengthened

Unhandled Exception Fixed for Transaction-Controlled Index File Under Heavy Update Activity in V10.4

Unhandled Exception Fixed When Shutting Down FairCom Server DLL on System That Does Not Support Memory Tracking

Unhandled Exception When Accessing Pruned Memory Index Node

UNIFRMAT Builds Now Able to Open V9 Created Files

Unix Client Shared Memory Connections No Longer Leak Memory

Useful Updates

Utility Improvements

Windows Servers Now Statically Linked with ZLIB Compression Libraries