I.Customer-reported bugs fixed in CSDK 2.81 release

ESQL/C

132612
ELECTING A SINGLE SPACE INTO A HOST VARIABLE OF TYPE STRING RETURNS AN EMPTY STRING BUT MANUAL SAYS IT SHOULD RETURN SINGLE SPACE.

151008

SHARED LIBRARIES ARE BEING CREATED WITHOUT PASSING -LC TO THE LINKER IN CSDK2.70

154850

FETCH EMPTY SIMPLE BLOB CAN CRASH SERVER IN REMSBLOB OR HUNG SESSION IF FIX FOR 132712, 134024 IS INCLUDED

154994

TP/XA: CLIENT SDK (ESQL/C) MUST PROVIDE A DIFFERENT MECHANISM TO KNOW THAT IDS SERVER HAS FIX FOR PTS-B#80686 THUS AVOIDING RE-PREPARE OF STATEMENTS

155329

MACHINE NOTES DON'T MENTION THE NETTYPE TO BE USED ON A GIVEN PLATFORM

155408

CLIENT SHOULD SEND SQ_CMD INSTEAD OF SQ_ID EVEN FOR THE FIRST OPEN CURSOR THAT IS DECLARED FOR A PREPARED STMT IN XA ENVIRONMENT

155447

SQL 604 ERROR USING ESQL/C "ARRAY FETCH" WHEN DEFINING ARRAY SIZE TO BE 1 OR 2. THIS ALSO CAUSES CLIENT TO HANG INDEFINITELY.

155603

FEA: CUSTOMER WANTS SUPPORT FOR ESQL/C WITH C++

155695

RUNNING AN ESQL/C THREAD SAFE COMPILED PROGRAM MAY CAUSE GARBAGE TTY OUTPUT IN SERVER ONSTAT -G SES WHEN STDERR IS REDIRECTED

155717

IF ENGINE IS BROUGHT DOWN WHILE ESQL/C PROGRAM IS EXECUTING A STORED PROCEDURE ACROSS TCP/IP THE ESQL/C PROGRAM CORE DUMPS.

155895

XA CLIENT LEAKS MEMORY, IN CASE YOU DO A PREPARE, EXECUTE, FREE IN A LOOP AND A NEW TRASACTION IS DONE EVERYTIME
156116
IF PREPARE HAS RETURNED AN ERROR, DOING AN EXECUTE OF THIS STATEMENT GIVES A CORE DUMP IN XA ENV.
156193

IF YOU DO A PREPARE, EXECUTE, FREE FOR A SAME XID, YOU WILL SEE THAT CLIENT SENDS AN SQ_PREPARE/FREE FOR EVERY ITERATION EXCEPT FIRST

156219

USING XA - AFTER CLOSING GLOBAL TX AND SWITCHING TO LOCAL TX, CURSORS DECLARED PREVIOUSLY IN LOCAL TX ARE NOT AVAILABLE ANYMORE

156562

SQLI CODE CHANGE FOR HANDLING VARCHAR DATA FOR 9X SERVER IS CORRUPTING DATA IN IFX_CURSOR_T STRUCTURE CAUSING ISQL BUG #156363

157118

NEED TO SUPPORT LVARCHAR UPTO 32KB
157275
SQLID BUG OUTPUT IS INCOMPLETE, SQLIPRINT YIELDS BAD DATA OR POSSIBLY SEGVS IN PRINTFIELDS WHEN DESCRIBING STATEMENTS W/ OVER 108 HOST VARIABLES
157498

INSERT CURSOR WITH VARCHAR FIELDS AND FET_BUF_SIZE SET TO >4K CAUSES THE BUFFER SIZE TO SCALE DOWN (1K) -CONTRARY EFFECT- PERFORMANCE PROBLEM

157499

MONEY TO CHAR CONVERSION NOT TRIMMING ALL THE TRAILING CHARACTERS

157502

THE ACC COMPILER ON HP-UX IS NOT EXPLICITLY USED IN THE ESQL SCRIPT

157564

USING A TYPEDEF FOR AN ESQL/C DATETIME HOST VARIABLE WILL GENERATE INCORRECT C CODE, CAUSING WRONG RESULTS TO BE RETURNED

157692

FORM FIELD WITH ATTRIBUTES INCLUDE AND FORMAT, GIVE ERROR "THIS VALUE IS NOT AMONG THE VALID POSSIBILITIES" FOR COMMA SEPARATED VALUE > 999

158322

UNSATISFIED SYMBOLS COMPILING STATICALLY ON HP 11

158362

_FGISLCT FUNCTION RETURNS INCORRECT DATA FOR VALUES FOLLOWED BY VARCHAR FIELD IN BIND PARAMETER CAUSING BUG #157517 IN 4GL RDS PRODUCT

158376

EXDIV FUNCTION OF GENLIB DOES NOT LOOK AT SUBSTRINGS THERE BY RETURING INCORRECT DATA FOR DECIMAL TYPE WHERE AS RVALCVAR GIVES CORRECT RESULT

158981

FEA - ADD THE ABILITY TO USE 'CROSS JOIN' IN SQL SYNTAX SO THAT USERS WHO WANT ANSI 92 FUNCTIONALITY WILL BE ABLE TO USE IT FOR CARTESIAN PRODUCTS.

158990

SEGMENTATION FAULT USING 2.80.FC1 SDK AND AIX 5L AGAINST VARCHAR DATATYPES

159488

ERRONEOUS WARNING -33085 INTRODUCED IN CSDK 2.80 -- MUST BE REMOVED

159623

RETURNS WRONG ROW NUMBER WHILE INSERTING ROWS INTO TABLE WITH A VARCHAR COLUMN IN IT.

159786

TP/XA WE DONT FREE STATEMENT RELATED MEMORY IN A ROLLBACK ( XA_END/TM_FAIL) CASE

159892

IGNORE BLANK_STRINGS_NOT_NULL 1 WHEN USING GET DISCRIPTOR

159898

DECCVDBL() DOES NOT WORK CORRECTLY (OVERFLOW)

160357

MEMORY CORRUPTION ERRORS RUNNING ONMODE -Z

160728

MEMORY ERRORS DURING 'MI' CALLS IN PURIFIED PROGRAM

160788

RFMTDOUBLE() FUNCTION RETURNS WRONG RESULT

160859
PURIFY WARN UMR FMR ON APPLICATION COMPILED BY CSDK

160491

ABNORMAL TERMINATION OF AN XA PROGRAM USING TRANSACTION MANAGER
DOES NOT LEAD TO SESSION BEING TERMINATED.
151008
SHARED LIBRARIES ARE BEING CREATED WITHOUT PASSING -LC TO THE LINKER IN
CSDK2.70
160603
WE SHOULD MENTION THE COMPILER VERSIONS USED TO BUILD LIBRARIES IN MACHINE
NOTES
160831
TP/XA CLIENT CAUSES AN IDS SESSION MEMORY LEAK WHEN PERFORMING CURSOR
OPERATION WITH PREPARED STATEMENT IN A LOOP WITHIN A GLOBAL TX
161137
ERROR "INIT FUNCTION IS MISSING IN ISPWS07A.DLL LIBRARY" SETTING ODBC/ILOGIN
IF PASSWORD ENCRYPTION IS ENABLED
161668
SHARED MEMORY CONNECTIONS HANG ON AIX POWER4 SYSTEMS
161747
XA CLIENT CAUSES A SESSION MEMORY LEAK (SQLID'S INCREASING) WHEN EXECUTING
A PREPARED STATEMENT IN A LOCAL TX WHICH WAS PREPARED IN A GLOBAL TX BEFORE
161757
PASSING ENVIRONMENT VARIABLES BETWEEN API LAYORS CAN BE DANGEROUS IN
A IIS ENVIRONMENT
161852
EXEC SQL PREPARE P_R FROM "ROLLBACK WORK" CODE, COMPILE USING ESQL WITH
LOCAL OPTION. GENERATED WRONG .C CODE WITH "ROLLBACK WORKRK\" STRING
161985
CLIENT API LEAKS MEMORY WHEN QUERY RETURNS INTEGERS OR FLOATS
162067
ESQL/C SQLI WILL ACCESS ALREADY FREE'ED MEMORY IN SQLI_CURS_FREE_TCB()
162101
APPLICATION USING FETARRSIZE MIGHT CRASH DURING FETCH IN HAS_BLOBS()
WHEN USING DATETIME, DECIMAL, MONEY OR INTERVAL DATATYPE
162361
ESQLC    (RED HAT 9) DISPLAYS "INCORRECTLY BUILT BINARY"
 

SETNET

SETNET32 - CANNOT TAB OUT OF THE SERVER INFORMATION PANEL IF NO
SERVER DEFINED

ODBC

160752
FEA: NEED A SEPARATE DIALOG FOR ASK PASSWORD AT RUN-TIME
160806

-11067 FUNCTION SEQUENCE ERROR USING MTS ON A POOLED CONNECTION THAT PREVIOUSLY WAS USED WITH THE DTC AND A TRANSACTION THAT WAS PREPARED.

161015

ERROR 416 WHEN USING LOTOFILE THRU ODBC IN WINDOWS; USING DBACCESS NO ERROR

161104

CREATE A DSN USING RDO RDOREGISTERDATASOURCE FAILS

161175

MEMORY LEAK STARTING/COMMITING XA TRANSACTIONS

161266

IF ODBC PARSER IDENTIFIES SYNTAX ERROR IN A QUERY WHICH IS ACTUALLY CORRECT, IT DOESN'T HAVE A CORRECT COUNT ON NUMBER OF PARAMS IN THE QUERY

161400

ODBC XA RECONNECT BEHAVES DIFFERENTLY THAN ESQL XA

161639

USING 'UPDATE..CURRENT OF' STATEMENT IN ODBC CALL CAUSES ERROR -11358 WHEN COLUMN FOR CURSOR IS NULL.

161663

IN CASE THE SERVER HAS ROLLED BACK A TRANSACTION IN A MULTIPROCESS ENV, ODBC LIBRARY WILL STILL USE THE SAME TRANSACTION ID FOR A NEW XA_START

161691

IIS /W ASP USING ODBC, CAN CONNECT TO THE WRONG SERVER OR RECIEVE -952 ERRORS.

161785

INSERT/UPDATE TEXT COLUMNS WITH A QUESTION MARK IN THE TEXT STRING PRODUCES ERROR

161787

RETURN FROM MALLOC NOT CHECKED CAUSING A SEGV AT CUSTOMER SITE WHEN THE CUSTOMER RUNS OUT OF MEMORY.

161900

TYPE NAME RETURNED INCORRECT IN SQLCOLUMN FUNCTION FOR DATETIME QUALIFIERS IF COLUMN DEFINED WITH NOT NULL CONSTRAING

162089

SQLSTATISTICS CALLS UPDATE STATISTICS WHEN SQL_ENSURE IS SET. THIS CAN LEAD TO ERRORS AND PERFORMACE PROBLEMS.

OLEDB

161268
IF OLEDB PARSER IDENTIFIES SYNTAX ERROR IN A QUERY WHICH IS ACTUALLY CORRECT, IT DOESN'T HAVE A CORRECT COUNT ON NUMBER OF PARAMS IN THE QUERY
161685

PERFORMING UPDATE ON TEXT COLUMN RESULTS IN MULTI-STEP OPERATION ERROR IN MICROSOFT CURSOR ENGINE

161726

OLEDB RETURNS ERROR -11060 IN POOLING SITUATION WHEN TEMP TABLE ALREADY EXISTS INSTEAD OF THE -958 ERROR MESSAGE

161759

OLEDB PROVIDER DOES NOT RETURN INFORMATION FOR SYSMASTER DATABASE ABOUT DATABASE NAMES WITH THE DATABASE ENGINE

162031

OLEDB DOES NOT RETURN ERROR 244 BUT OTHERS LIKE 201

SDK

108512
FEA: XALIB AND ASYNCHRONOUS CALLS
154673

A -206 ERROR OCCURS USING THE I-CONNECT PORTION OF THE DBPING UTILITY AGAINST AN ANSI DATABASE

155667

CUSTOMER USES SEMICOLONS (;) IN HIS PASSWORDS ON WIN 2000. USING ODBC DATASOURCES IN CONTROL PANAL, GIVES AN ERROR WHEN USING SEMICOLON.

155832

USING CLIENT SDK ON WINDOWS XP AND POWERBUILDER WHEN APPLICATION EXITS A MEMORY ACCESS VIOLATION ERROR IS GENERATED

155907

STAT SYSTEM CALL IS UNDEFINED WHEN USING DYNAMIC LIBRARIES IN ESQL/C ON LINUX

156207

USING XA - AFTER CLOSING GLOBAL TX AND SWITCHING TO LOCAL TX, CURSORS DECLARED PREVIOUSLY IN LOCAL TX ARE NOT AVAILABLE ANYMORE

156556

IN CORRECT FIELD LENGTH RETURNED FOR VARCHAR COLUMN WHEN PREPARING A STATEMENT FOR A CURSOR WITH 9.3 SERVER. CAUSING BUG #156374 IN 4GL-RDS

159023

UNABLE TO ADD INFORMIX CLIENT-SDK.MSI TO A GROUP POLICY->SOFTWARE DISTRIBUTION WITH IN AN ACTIVE DIRECTORY.

159597

DECCVASC() DOES NOT WORK CORRECTLY (WHEN COMMA IS CONTAINED)

160162

PRIMARY KEY INFORMATION NOT RETURNED WHEN USING OLEDB AND .NET

LIBC++

134604
THE C++ API DOES NOT RETURN THE FULL ERROR WHEN A DATABASE DOESN'T EXIST, ONLY THE ISAM ERROR.
144384

C++ API ERROR HANDLER INVOCATIONS FOR ERRORS AND WARNINGS ARE NOT CLEARED FROM ONE ERROR TO THE NEXT AND ERRORS ARE REPORTED TWICE FOR WARNINGS & ERR

145151

ATTEMPTING AN INSERT INTO A CHAR COLUMN DEFINED AS CHAR(N) WHERE N>1 USING A PREPARED STATEMENT ONLY INSERTS THE FIRST CHARACTER

156773

ITDATETIME::FROMDATE METHOD RETURNS FALSE FOR VALID INPUT PARAMETERS

156774

ITDATETIME::FROMTIME METHOD RETURNS FALSE FOR VALID INPUT PARAMETERS

156862

MASSIVE USE OF THE EXEC METHOD ON AN INSTANCE OF ITSTATEMENT FOR AN INSERT STATEMENT LEAKS

161554

LIBC++ PREPARED INSERT OF NCHAR GETS TRUNCATED

LIBDMI

156923
MI_TYPESTRING_TO_TYPEDESC RETURNS INVALID QUALIFIER VALUE FOR DATETIME DATA TYPE.
157009

NULL VALUES ARE NOT PICKED UP WHEN PASSED VIA MI_ROUTINE_EXEC FROM A CLIENT LIBMI APPLICATION USING MI_FP_SETARGISNULL

II Known Issues with CSDK 2.81 release

ESQL/C

155195
ESQL/C GENERATES CODE WHICH IS NOT CONST CORRECT - PROBLEMS WITH PROTOTYPES IN SQLHDR.H AND SO ON

155695

RUNNING AN ESQL/C THREAD SAFE COMPILED PROGRAM MAY CAUSE GARBAGE TTY OUTPUT IN SERVER ONSTAT -G SES WHEN STDERR IS

REDIRECTED

158133

APPLICATION RECIEVES A SIGNAL SIGPIPE, BROKEN PIPE ON HP PLATFORMS, SIGPIPE IS NOT HANDLED AND APPLICATION EXITS.

ODBC

145043
ODBC DRIVER DOES NOT SUPPORT ADO FIELD OBJECT'S UNDERLYINGVALUE PROPERTY IN VISUAL BASIC
155898

FEA-WE NEED XA TRACING IN ODBC

157604

USING MS ACCESS TO IMPORT AN IDS 731 DATABASE SYNONYM WHICH POINTS TO IDS 9.2X TABLE GIVES RESERVED ERROR(-7730); THERE IS NO MESSAGE FOR THIS ERROR.

157833

FEA: WANT TO BE ABLE TO DEFINE READ-ONLY DATA SOURCES

162079

-11025: 22003 : [INFORMIX][INFORMIX ODBC DRIVER]NUMERIC VALUE OUT OF RANGE.

162124

WHEN CONNECTING TO XPS ENGINE USING ODBC DATASOURCE, GETTING -11071 ERROR. WHEN TABLE NAME SHORTENED FROM 21 TO 18 CHARACTERS, IT WORKS.

OLEDB

129137

FEA REQUEST FOR INFORMIX OLE DB TO SUPPORT ASYNCHRONOUS CALLS USING THE ADO MODEL.

145040

OLE-DB CLIENT PROVIDER MISSING FUNCTIONALITY TO SUPPORT ADO FIELD OBJECT'S UNDERLYINGVALUE PROPERTY

161677

OLEDB PERFORMANCE SLOW COMPARED TO ODBC