V11.5 Release Notes

Index

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

Adding index to a compressed file could fail with READ_ERR (36)

ADDREC DELFLG_ERR (31) following recovery

Administrative Utilities

ADO.NET

ADO.NET client-side crash fixed

ADO.NET connection pooling

ADO.NET EF6 provider support for V11 servers

ADO.NET Entity Framework provider issues with DDL generation

ADO.NET error when reading non-Unicode varchar fields from Unicode FairCom Server

ADO.NET Provider may inappropriately retain SQL cursors for ExecuteNonQuery statements

ADO.NET returned wrong number of decimals

Alter Table on table with identity field failed with error -17749

Alter Table VARBINARY default error

Auto Restore Point quiesce no longer causes threads to remain blocked after quiesce fails with error 843

Automatic directory create option not working for TRNLOG transaction-dependent file creates

Automatic Recovery - "ctfsize failed" message in CTSTATUS.FCS

Automatic recovery crash when redoing PRMIIDX operation for data file with compressed records

Automatic recovery failed with error 12

Automatic recovery failed with L69 error

Avoid infinite loop on a corrupted index file

Batch Processing

Caching

Client may hang after failed call to ctTempDir() when using TCP/IP protocol

Communication fixes and modifications

Communications Layer

Compacting file with Extended field types

COMPATIBILITY RENAME_OVERWRITE ignored on Windows

Connection hangs when reading records due to abandoned commit write locks

Core Engine

Corrected checkpoint processing to persist required transaction logs for recovery

Corrected SQL database upgrade conversions

Crash after error opening file with conditional index

Crash in REDVREC following fileblock

CreateFilesetHost: Resource copy failed

CREIFILX8 failed to create non-existent directory on Unix when ctAUTOMKDIR was specified

ctdbCreateMRTTable behavior change

ctdbDeleteTable on missing table failed with INOT_ERR instead of CTDBRET_NOSUCHTABLE

ctdbEndBatch() call sometimes freed record locks even with CTBATCH_LOCK_KEEP option

ctdbGetRecordCount sometimes returned incorrect count

ctdbInsertBatch may cause heap corruption

ctdbRenameTable did not properly rename indexes containing full path

ctdbRenameTable may not rename index having the same name of the table

ctdbStringTo* functions fail with 4029 (invalid date)

ctdump may truncate dump stream file if DAVL_ERR (442) occurred

ctidmp utility FTYP_ERR(53)

ctquiet - Add ctQTfailAfterTimeout mode

ctrdmp - Dump restore failed with error 12

ctrdmp BIDX_ERR (527)

ctrdmp terminated with unhandled exception during recovery phase

c-treeACE ISAM

c-treeACE JDBC

c-treeACE JDBC ResultSet.isAfterLast incorrectly returned true with the isAfterLast() positioning method

c-treeACE PHP

c-treeACE SQL Server

Introduction

c-treeACE SQL Server crash following failed Java initialization on AIX

c-treeACE SQL Server Critical Fixes

Introduction

c-treeACE SQL Server exception when building a key for a Unicode key segment

c-treeACE SQL Server ignored "preserve cursor" client request

c-treeACE SQL Server race condition fixed

c-treeACE SQL Server Unicode crash

c-treeDB “NAV” API

ctscmp failed with error 608 during index rebuild

ctsqlimp - Correct SQL column widths for imported CT_MONEY columns in ctslqimp

ctsqlimp imports indexes with ISAM null key check causing wrong query result

ctstat -i X

ctstat -isam - Improved accuracy of ISAM counters

cttrnmod UNQK_ERR (775)

ctVerifyFile() sometimes failed with error 160 on a 64-bit memory file or error 123 on a huge file

DECODE scalar function did not properly set the scale of its result

DISK_FULL_ACTION environment variables fix

Dropping a column sometimes caused problems with the IDENTITY field

DSQL - Server crash when calling ctsqlGetBlob on a field with any data type other than a long

Dynamic Dump and Backup/Restore

Dynamic dump restore terminated with internal error when restoring segmented files

Dynamic Dump with !PROTECT option sometimes caused FairCom Server to hang

Embedded SQL function dh_conv_data() causes client crash

Error 133 connecting to FairCom Server using shared memory when server was busy

Error 14 when opening index with additional members that was copied after quiesce with flush

Error 160 after automatic recovery or forward roll on huge TRNLOG fixed-length data file

Error 519 or wrong index key counts after automatic recovery (if member updated; host not)

Error 894 (NKEY_ERR) - Deleting record failed if index used null key feature and key was null

Exception in client-side library when ALCRNG() is called with an out of range index file number

Exception when identity field references out-of-range field number

Exception when undoing transaction-dependent file create

Failed call to ctDeferredIndexControl() could hang c-tree Server connections

Failed ctdbCreateTable could leave files on disk

FairCom Low-Level

FairCom Server

Introduction

FairCom Server controlled shutdown CHKP_ERR (529)

FairCom Server Critical Fixes

Introduction

FairCom Server displays correct file descriptor requirement value

FairCom Server ISAM counter values on Linux

FairCom Server keeps all transaction logs when deferred index thread starts with nonexistent log 1

FairCom Server no longer logs TLOG_ERR with trantyp of 0x4e

FairCom Server now writes automatic restore points at the specified interval

File compact or index rebuild sometimes failed with FULL_ERR (39) or KLOD_ERR (58)

File copy function call may fail with error 965 (BCOD_ERR)

File Management

Fixed crash running query with Order By and a sub-query with Group By on multiple columns

Fixed memory leak on each SQL connection

Fixed-length record update or delete in IICT failed with error 114 if the outer transaction added the record

Fixes for Extended Features

Forward Roll failed for TRANDEP creates

FPUTFGET - Corrected variable-length record add duplicate key error on SRLSEG index

FPUTFGET header updates result in errors

FPUTFGET now treats read lock requests as write lock requests

FRSREC() failed with error INOT_ERR (101)

High-Velocity c-treeACE APIs

IERR_COD (923) compacting a transaction-controlled data file

Improved detection of invalid server configuration option values

Incorrect key counts after dynamic dump restore

Incorrect parameter specified in SETFLTR() and SETFLTRN()

Incremental forward roll reported successful termination when restore point not found

Indexing

Internal SQL error on REPEATABLE READ query

Introduction

ISAM-level client call returned error 128

ITIM_ERR (160) or wrong record on Next Record with ISAM key buffers disabled

ITIM_ERR (160) reading a record that used Unicode ctKSEG_STYP_PROVIDED key segment

ITIM_ERR (160) Reading records another connection is deleting

JDBC catalog handling in DatabaseMetaData was not compliant with JDBC standard

JDBC Connection to set warnings instead of failing with exception on method returning a resultset

Linux Unicode server failed to enable SQL TCP-IP socket

Locale support added to dbdump, dbload, dbschema

Mac OS X server exception when shutting down fails

Memory Management

Multi-threaded FPUTFGET compile error with Embarcadero

Multi-threaded FPUTFGET on Unix - Incorrect lock release with recursive lock support

Multi-User Standalone (FPUTFGET)

Next Record fix using co-files

Node split in transaction-controlled index file could cause error

Notable Compatibility Changes

Introduction

Notable Compatibility Changes

ODBC

ODBC driver allowed "%" as catalog in ODBC SQLTables and SQLColumns calls

ODBC SQLTables call failed with syntax error

One-time memory leak in background file flush threads

Parameterized query failed if one parameter was a 8192-char string

PartitionAdmin() returns RSYN_ERR (747)

PHP driver improvements

Physical order batch retrieval with record filter returned too few records

PLOW_ERR (712) on record Add over multi-segment partition key

Possible buffer overflow generating temporary file names on Windows

Possible exception or infinite loop in co-file support

Possible Server exception with CTSTATUS_SIZE option

PREIMG file create fail with DOTX_ERR (955) during dynamic dump

Preventing Possible Data Loss with Compact & Rebuild Operations

PRIME_CACHE and PRIME_INDEX caused only data or index file to be read into cache

PRMIIDX/RBLIIDX QTOC_ERR (953) with auto restore points

Protection for internal server threads still running at end of server shutdown

PUTHDR mode ctSUSSRLSEGhdr ignored on client side

Query with predicate "X OR EXISTS(Y)" yielded incorrect results

Rare occurrence of "Retried Hdr I/O failed" Messages in High Concurrent FPUTFGET Environments now Eliminated

Rebuild failed with error 775 on replicated file if a connection had the file open

Rebuild or compact failed with error 608 on file with SCHSRL key segment

Rebuild or compact failed with FUSE_ERR (46)

Rebuild/compact with errorOnCorruptIFILoption enabled causes VLENGTH files to fail with DCPT_ERR (1107)

Record update callback function could unexpectedly change the current record offset

Record update callback function file open

Record update failed with NKEY_ERR (894) when using null key

RECOVER_MEMLOG option could cause automatic recovery to fail with errors 55, 96, etc.

REDREC() reads wrong last 4 bytes of uncompressed fixed-length record in compressed file

Reduce file descriptor usage

Relational c-treeACE SQL

RenameIfil() possible file loss on Unix/Linux fixed

Replication

Replication Agent failed to start with error -1

Replication Agent LOPN_ERR (96)

Replication Agent terminated with error 938 decompressing a record image

Replication Agent Unique Index improved

Save space in variable-length files created by c-treeDB/SQL

Select c-treeDB functions improperly allowed fields larger than 65535 bytes

Selecting from a view that referred to a Select statement with right outer join gave wrong results

Sequence Create error

Server - Exception at shutdown when DISK_FULL_ACTION active

Server - Exception when Replication Agent read past end of transaction log

Server Crash - Failed memory allocation on startup could crash server

Server crash due to invalid license

Server crash due to orphaned cache page when out of disk space

Server crash when field starting in fixed portion and ending in variable portion

Server crash with self-referencing constraints on table with long field

Server deadlock in record update callback

Server deadlock involving aged cache page flush

Server Exception - Correct unhandled exception in compression logic

Server Exception or read incorrect ending of compressed record

Server handles failed startup with SNAPSHOT_SHUTDOWN

Server hang while dynamic dump waited for quiet transaction state

Server memory counters reported incorrect values

Server shutdown failed with error 452

Server terminated abnormally when ctQUIET() was called after a quiesce previously failed to reopen a file

Server unhandled exception when r-tree report's c-tree initialization fails

Server unhandled exception when two connections rebuild a compressed data record file at the same time

Server unhandled exception when using ctstat -funcfile file

Shared memory connection attempt hanged on Solaris 9 and earlier systems

Shared memory error 128 on AIX when multithreaded process used single-threaded library

Socket timeout TRSP_ERR (809)

SQL

SQL - DEFAULT NUMERIC, BIGINT values

SQL Bit String conversion fix

SQL connect failed with error -17749 using LDAP

SQL cursor position not properly maintained

SQL database conversion for Unicode databases

SQL DECODE scalar function

SQL handling of binary literals larger than field size

SQL IPv6 support fixes

SQL parser consumed all system memory and crashed the server

SQL parser crash fixed

SQL queries never returned when synonym pointed to non-existing table

SQL query that generates dynamic index corrected

SQL query with left outer join and parameters now parses correctly

SQL query with Left Outer Join fixed

SQL STORAGE_ATTRIBUTES parsing issue

SQL subquery in case clause crash

SQL table open error 4120 (or -21120)

SQL yielded wrong query result

Successive BLKIREC() calls caused memory leak

Superfile member error 14 after being restored from Dynamic Dump

Time handling in expressions

Transaction commit improvements

Unable to connect to SQL on Windows Server 2003 or XP

Unexpected Deleted Data with low-level calls in client/server model

Unexpected JDBC 26046 (closed resultset) exception calling getWarning()

Unhandled exception in Blocking Locks: BLKIREC()

Unhandled exception when a second callback is added to a file

Unhandled exception when assembling key value if index definition specified a negative segment length

Unicode conversion failed with VBSZ_ERR (153)

Unknown indexes identified because CreateFilesetHost renamed templates' internal indexes

UQID_ERR (463) on file open

V11 client may lose connection to FairCom Server when pstack was run on server

V11 COMMIT_DELAY on Windows change

V11.2 unhandled exception on first update to member index, or error 14 on member index after automatic recovery

VRLN_ERR (149) in RWTVREC()