Fix list for Informix Dynamic Server 11.50.xC3W2

Informix Dynamic Server provides periodic fixes for release 11.50. The following list is the most recent report of fixes for customer-reported defects in PID 11.50.xC3W2. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.

---

NOTE: some detail links below have been disabled as they are not available.

W1 APARs	Description
IC57613	DOCUMENTATION SHOULD INCLUDE A MORE PRECISE DISCUSSION ON DYNAMIC LOGS
IC57756	PDQ DOES NOT WORK WITH COLLECTION DERIVED TABLES IN THE FROM CLAUSE
IC57845	STORED PROCEDURE WITH SELECT FROM A COLLECTION DERIVED TABLE GIVES ASSERTION FAILURE AND -9791
IC58118	SYSMASTER TABLE FLAGS_TEXT, NO DESCRIPTION FOR ISOLATION COMMITTED READ LAST COMMITTED
IC58280	Table Level Restore fails to parse schema command files with some types of constraint expressions
IC58598	STORED PROCEDURE ON FRAGMENTED INDEX WITH SUBSTR EXPRESSION RETURN ERROR -346 / -111
IC58706	ERRORS -7470/-937 AND VARIOUS MEMORY CORRUPTIONS WHEN EXECUTING A TRIGGER CONTAINING A SPATIAL FUNCTION
IC58707	CDR SYNC ON TABLES WITH BLOB COLUMNS MAY ALLOCATE LARGE AMOUNTS OF MEMORY AND CRASH THE TARGET SERVER
IC58756	ERROR 640 QPLAN SANITY FAILURE EXECUTING A STORED PROCEDURE CONTAINING A VIEW AND UPDATE STATISTICS IS RUNNING SIMULATANEOUSLY
IC58825	ONSTAT -G OPN FAILS WITH CHANGING DATA STRUCTURE FORCED COMMAND TERMINATION
IC58840	CREATE INDEX USING BTS STATEMENT RETURNS A BTS90 ERROR AND ASSERT FAILURE
IC58898	BOTH THE OPTIMIZER COSTS AND NUMBER OF ROWS RETURNED FOR LEFT OUTER JOINS IS UNPREDICTABLE
IC58918	ANSI SIX-TABLE OUTER JOIN EXECUTES MUCH MORE SLOWLY THAN COMPARABLE INFORMIX OUTER JOIN
IC58929	VIEW USING ANSI JOINS AND UNION ALL RETURNS INCORRECT RESULTS WHEN IFX_FOLDVIEW IS SET
IC59023	CREATE INDEX FAILS WITH ERRORS 212/107 RECORD IS LOCKED EVEN IF THERE ARE NO OTHER SESSIONS CONNECTED TO THE DATABASE.
IC59150	ERROR 640 QPLAN SANITY FAILURE EXECUTING A STORED PROCEDURE CONTAINING A VIEW AND UPDATE STATISTICS IS RUNNING SIMULATANEOUSL
IC59159	ASSERT FAIL IN RANGE SEARCH WHEN USING BTS AND SPECIFYING AN INCOMPLETE RANGE
IC59170	AN INSERT TRIGGER CALLING A STORED PROCEDURE WITH TRIGGER REFERENCES RESULTS IN AN ASSERT FAILED AND ERROR -9791.
IC59171	SEQUENCE OBJECT RESTART WITH CACHE PLUS CURRENT VALUE THOUGH CACHE VALUE HAD NOT BEEN USED UP.
IC59206	LOGICAL LOGS FILL QUICKLY BECAUSE OF UNNECESSARY STORED PROCEDURE REOPTIMIZATION
IC59246	SYSTEM COMMAND IN STORED PROCEDURE TAKES SECONDS TO RUN
IC59271	ADDING A FRAGMENT USING THE BEFORE CLAUSE SCANS ALL FRAGMENTS
IC59289	NVL FUNCTION RETURNS EMPTY SPACE WHEN THE RETURN RESULT INVOLVES VARCHAR CONCATENATION
IC59291	ALTER FRAGMENT TO ADD A PARTITION THROWS -776 AND ISAM -111 ERRORS
IC59292	-211 ERROR ON SYSPROCPLAN
IC59293	DEFINE/LET COMBINATION IN SPL IMPLICITLY CASTS VARCHAR VARIABLES TO CHAR, CAUSING INCORRECT -9748 ERROR.
IC59294	WINDOWS: INSTALLATION OF 11.50.XC3 MIRRORS ROOTDBS AND SMARTBLOB SPACE WITHOUT PROMPTING
IC59296	ASSERT FAILURE WHEN USING MULTISETS IN A PROJECTION LIST OF A SELECT
W2 APARs	Description
IC57571	SCHAPI: ERROR -23197 DATABASE LOCALE INFORMATION MISMATCH ERROR IN ONLINE.LOG
IC58103	CREATE TEMP TABLE WITH UNIQUE SERIAL COLUMN AND NO LOG, RETURNS ERRORS 626/140 ON A HDR SECONDARY
IC58271	OPEN CURSOR WITH A USING CLAUSE IN A DYNAMIC SPL CAUSES A 1260 ERROR
IC58701	DBEXPORT PRODUCES A STATEMENT LONGER THAN IDS CAN HANDLE RESULTING IN A -460 ERROR ON DBIMPORT
IC59181	EXECUTING A FUNCTION WHOSE VALUES ARE BEING CONCATENATED, RETURNS ERROR -674
IC59272	DYNAMIC EXPLAIN DOES NOT WORK FOR DRDA CLIENTS
IC59291	ALTER FRAGMENT TO ADD A PARTITION THROWS -776 AND ISAM -111 ERRORS
IC59302	MI_REALLOC CAN CORRUPT RESULT SET IN GENXML/GENXMLCLOB
IC59326	BYTE COLUMN INSERT INTO VIEW RESULTS IN ERROR 618 AND 101
IC59348	BTS_CONTAINS DOES NOT RETURN CORRECT RESULT USING DEGREE OF SIMILARITY
IC59399	MQ DATABLADE DOES NOT SUPPORT LOCALLY DEFINED REMOTE QUEUES
IC59466	A QUERY RUNS FOREVER WITH FIRST_ROWS OPTIMIZATION AND OPTCOMPIND SET TO 0
IC59477	AN ALTER FRAGMENT ATTACH COMMAND IGNORES THE CHECK CONSTRAINT AND CAUSES A SEQUENTIAL SCAN
IC59478	"-208 MEMORY ALLOCATION FAILED DURING QUERY PROCESSING" RUNNING SQL USING THE REPLACE FUNCTION
IC59502	AN OPTIMIZER ERROR -874 WHEN RUNNING SQL THAT INCLUDES A ROW TYPE
IC59892	DBSCHEMA GIVES ERROR "-586 - CURSOR IS ALREADY OPEN."
IC59896	PERFORMANCE SLOWDOWN WHEN MANY NON-DBA USERS EXECUTE A STORED PROCEDURE
IC59898	BAD PERFORMANCE ON REMOTE CALLS WHEN USING LONG SQLHOSTS SERVER LIST