Fix list for Informix Server 12.10.xC13

ID

DESCRIPTION

OPTIMIZER NEEDS A LOT OF SHARED MEMORY

BEHAVIOUR OF AN HDR PAIR AFTER A NETWORK FAILURE

EXECUTING QUERIES USING XML EXISTSNODE ROUTINE IN PARALLEL CAN ASSERT SERVER

ARCHECKER TABLE LEVEL RESTORE (TLR) OF TABLE WITH SMART BLOBS DOESN'T ALWAYS RESTORE ALL SLOBS FROM BACKUP

DBSCHEMA/DBEXPORT IS MISSING AN ALIAS FOR RESULT OF A FUNCTION FOR A COMPLEX VIEW

HASH JOIN BETWEEN TABLES WITH ADDITIONAL FILTER USING LIKE AND WILDCARDS USES MUCH MORE CPU USING EN_US.UTF8 COMPARED TO EN_US.819

AF IN RSBCLOSE ON UPDATABLE SECONDARY, AND "LEAK" OF SBSPACE TEMP BLOBS

POTENTIAL LARGE AMOUNTS OF MEMORY CORRUPTION/SERVER ABORT IF THE ROW LENGTH PORTION OF SORT OF VARIABLE LENGTH DATA IS CORRUPTED

IN DWA ENVIRONMENT, AF IN GETTYPEEXPR WRTEXPR CALLED BY DWA_OFFLOAD(). SUBSTR EXPR TREE DOESN'T HAVE OP_CONST RIGHT "RESULT TYPE" NODE

ARCHIVES CAN MISS SMART BLOB DATA WHEN CHUNK > 500GB ON 2K PAGE SYSTEM, OR ~268 MILLION PAGES IN SIZE

PREPARING LARGE STATEMENTS THAT CONSIST OF MANY SMALLER STATEMENTS CAN CAUSE SEGV IN STMT2CB WHILE PARSING

REGRESSION: OPTIMIZATION OF TRIGGER PROCEDURE NOT THREAD SAFE : TRIGGER/PROCEDURE FAILS WITH AF/MEM AND ERROR -9791 AFTER UPGRADE TO 12.10.FC12

INCORRECT NEXT EXECUTION FOR A NEW SCHAPI ADMIN TASK

BUILDSMI SCRIPT WOULD CORRUPT SYSMASTER (REMOVE ALL SMI PSEUDO TABLES) IF RAN WHILE OTHER SESSION HAS SYSMASTER DB OPEN

EXECUTING CONVERSION/REVERSION SCRIPTS CAN FAIL DUE TO BLANKS IN INFORMIXDIR

CAN'T CREATE OS FILE IN DIRECTORY ALLOWING WRITE ACCESS ONLY BY GROUP MEMBERSHIP, STARTING 12.10.XC12

PID.12.10.XC7W1 - LDBIGINT, RDATAVALBIGINT, GETINROW DOESN'T CHECK DATA LENGTHS IN INPUT BUFFER AND CAN ACCESS BEYOND END OF BUFFER.

IF LOW MEMORY MANAGER IS SET, ONLINE.LOG SHOWS THE SESSION MEMORY AS MB WHERE AS ACTUAL SESSION SIZE IS KB.

NOT WAITING ON A LOCK WITH COLLECTION SUBQUERY AND PARENT QUERY'S WHERE CLAUSE ALLOWING MULTIPLE VALUES

12097 ERROR POSSIBLE ON UPDATABLE SECONDARY IF TRANSACTION DELETES A ROW AND THEN RUNS QUERY WHICH COULD POTENTIALLY RETURN THAT ROW

ONMODE -- OUTPUT SHOWS THE WRONG USAGE SYNTAX FOR ONMODE -I

PHYSRECOVER THREAD CAN HANG RESTORING SMART BLOB DATA AFTER FIX FOR IT26556

WALMART: AFTER UPGRADE FROM 11.50 TO 12.10 QUERY USING ANSI JOIN SYNTAX TAKING QUERY PLAN THAT'S SLOWER AND CAUSES MORE BUFF READS

WHEN XYUNITS VALUE IN SPATIAL_REFERENCES TABLE GETS TOO LARGE, INDEXES ON SPATIAL COLUMNS MAY NOT GET USED WHEN DISTRIBUTIONS ARE BUILT ON THAT COLUMN

PRIMARY AND SECONDARY UNABLE TO RECONNECT AFTER NETWORK FAILURE

AFTER UPDATE STATISTICS EXECUTED SUCCESSFUL CAUSES ASSERT FAILURE ON 12.10.FC12AEE

SHRINKING A TABLE POTENTIALLY LEADING TO -101 'FILE IS NOT OPEN' FOR PREPARED STATEMENTS LAST USED BEFORE THE SHRINK

ON AN UPDATABLE SECONDARY, THE ROLLBACK OF A LARGER TRANSACTION CAN BE VERY SLOW

START_ONPLOAD PROCEDURE FACILITATES A SHELL ON THE DATABASE SERVER MACHINE

ONTAPE STDIO SEEMS TO IGNORE THE -ENCRYPT OPTION ON RESTORE

WHEN DBACCESS_COLUMNS IS SET TO 1000, THE COLUMN HEADINGS ARE NOT CORRECTLY SHOWN

SYSSESSIONS OCCASIONALLY NOT RETURNING CURRENT SESSION

BFCHECK BAD PAGE PG_FRPTR <SIZE> < SIZEOF(IFX_PAGE_T) 24 OR > SLOTBEG <SIZE> WHEN UPDATING PAGE WITH OUTSTANDING IN PLACE ALTERS

STORED PROCEDURE TO CREATE EXTERNAL TABLE FAILS WITH ERROR -26180

WITH VARIABLE ROW LENGTH AND MAX_FILL_DATA_PAGES PAGES MIGHT FOREVER OFFER ROOM THAT NEVER SATISFIES ANY NEW ROW, POTENTIALLY CAUSING LONG CHECKPOINT BLOCKS

HASH JOIN EXECUTION SHOULD BE AVOIDED IF EITHER BUILD OR PROBE SIDE ALREADY KNOWN TO BE EMPTY

SELECT INTO TEMP WITH NO LOG INVOLVING BYTE COLUMN FAILS TO COPY THE BYTE COLUMN

IT'S POSSIBLE TO SEGV CALLING LDDBLNULL FROM RDATAVALFLOAT WHEN MATERIALIZING VIEW WITH SUB QUERY

IF YOU SPECIFY HARD CODE DEFAULT RECORDEND "\N" WHEN CREATING EXTERNAL TABLE FOR UNLOAD, THE RESULTING DATA FILE DOES NOT SEEM TO HAVE AND EOL

LOADING BYTE DATA INTO REGULAR TABLE USING EXTERNAL TABLE CAN FAIL WITH FIELD_TOO_LONG IN REJECTFILE

BSON_UPDATE $SET OPERATOR CRASHING WITH EMPTY KEY

UTF8 REPLICATION CAN CRASH WITH INADVERTENT SCHEMA DIFF BEYOND ONLY CHAR LIKE COLUMNS

DEFINING LOOPBACK REPLICATE CAUSING "CDR GC: OPERATION OPEN ON TABLE <TABNAME> FAILED (ISAM ERROR -6)." ON OTHER ER NODES

EXTRACT() AND EXTACTVALUE() XML BLADE FUNCTION TRUNCATING RETURN VALUES CONTAINING MULTI-BYTE CHARACTERS

ONMODE -I 746 WILL NOT DETECT A RAISED EXCEPTION -746 INSIDE A SPL CALLED FROM A TRIGGER ACTION.

DEADLOCK (-143 / -622) ON SYSFRAGMENTS & SYSINDICES WHEN CONCURRENT TRUNCATE & SET INDEXES FOR WITH LOCK MODE WAIT & NO LOG DB

NEW SEMI-DETACHED INDEX FRAGMENT INCURRED DURING LOGICAL RECOVERY WILL CAUSE DEFERRED INDEX RECREATION OF WHOLE INDEX

MORE CDR COMMANDS FAILING WITH DELIMIDENT SET IN ENVIRONMENT

CRASHES POSSIBLE WITH QUERIES ON ATS/RIS RELATED SMI TABLES

CDR DEFINE REPLICATE --CLASSIC CAN TAKE A LONG TIME, VERY SIMILAR TO --MASTER REPLICATES

INFORMIX 12.10FC12X4 DOES NOT ALLOCATE MORE THAN 64GB FOR VIRTUAL SEGMENT ON AIX

ODD BEHAVIOUR WHEN USING CONCAT IN CASE STATEMENT IN SPL

DBACCESS TAKES A VERY LONG TIME BEFORE RETURNING ERROR CODE 25588

EXCESSIVE CALLING OF ALARM SCRIPT CAUSES COMPLETE RESOURCE CONSUMPTION.

SELECT WITHIN A STORED PROCEDURE MAY RETURN WRONG RESULT WHEN SKIP AND PARAMETER IS USED

FIRST AND ORDER BY ARE USED WITH INSERT STATEMENT , SHOULD GIVE ERROR INSTEAD OF WRONG RESULTS

WARNING MT_AIO_WAIT ERRNO == EINVAL IS MISSING TO PROVIDE DIAGNOSTIC INFORMATION

ASSERT FAILURE WHILE CREATING A PROCEDURE ON 12.10FC12W1

RSS SERVER DEFINITIONS MAY BE DELETED BY PRIMARY DURING MODE CHANGE FROM QUIESCENT TO ONLINE MODE

MANUAL PROMOTION OF HDR SERVER TO PRIMARY MAY BLOCK WHEN CONNECTION MANAGER AND SSL CONNECTIONS ARE CONFIGURED

GENBSON() UDR POTENTIALLY PRODUCING INVALID JSON STRINGS BECAUSE NOT ESCAPING SPECIAL CHARACTERS

ERROR 768 FOR UPDATE STATISTICS MEDIUM ON FRAGMENTED TABLE WITH FRAGMENTS HOLDING VERY FEW ROWS AND FRAGMENT LEVEL STATISTICS ON

REPLICATION OF COMPRESSED BLOBS MAY REPORT CDREXPANDROW MESSAGES

INSERT INTO RANGE FRAGMENTED TABLE BY EXTERNAL TABLES ALLOCATES AN VERY LARGE GLOBAL BLOCK POOL

SELECT IN AN SP CALLED FROM AN UPDATE TRIGGER USING THE SAME TABLE AS THE UPDATE WAS ISSUED IN RETURNS NOW ERROR 522

QUERY PLANS ON SP WITH TRIGGER REFERENCES DIFFER DEPENDING ON WHAT THE UPDATE STATISTICS WAS MADE

SELECT FROM TABLE EXPRESSION WITH CORRELATED SUBQ IN SELECT LIST RETURRN 9600 INSTEAD OF 284

DIRECT_IO FOR TEMP DBSPACES

CREATE TEMP TABLE IN AN XA AND ER ENVIRONMENT MAY ASSERT IN CDRPREDDLCALLBACK

UPDATE STATISTICS IN CONCURRENCY ON A TABLE WITH TRIGGER AND A DEPENDEND SP WITH TRIGGER REFS CAUSE AF IN DECOMPILE_PROC

12.10 OPTIMIZER CALCULATES THE SELECTIVITY OF A SUBQUERY DIFFERENTLY THAN IN 11.50

INSERT/UPDATE OPERATION ON TABLE WITH A HIGH NUMBER OF REF CONSTRAINTS CAUSE INH LIST MUTEX CONTENTION

PUSH DATA REPLICATES GETTING DELETED AFTER BOUNCING REMOTE ER SERVER

FOR REPLICATE DEFINED WITH TIMESTAMP CR RULE, ER FAIL TO APPLY REPLICATED DATA IF SMART TRIGGER DEFINED ON THE TABLE

SCHEDULER TASK AUTO_CRSD FAILS ON REMOVAL OF OUTSTANDING IN-PLACE ALTERS

LOADING BYTE DATA INTO REGULAR TABLE USING EXTERNAL TABLE CAN REPORT UNSUPPORTED_ROW_SIZE IN REJECTFILE

GENBSON UDR CREATING INVALID BSON FROM JSON, WITH EXTRA QUOTING AROUND NESTED JSON

INCORRECT BEHAVIOR FOR THE OLAP WINDOW EXPRESSION

SERVER NEEDS TO PREVENT AUTO REGISTRATION OF BLADES IN SYSMASTER DATABASE

DBACCESS MENU DATABASES -> SELECT ONLY DISPLAY'S 1024 DATABASE SO IF SERVER HAS MORE THEN THAT, NOT ALL ARE DISPLAYED

ONSNMP CRASHES ON STARTUP IN DEF_CV_TABLE

WALMART: FAILURES POSSIBLE WHEN CALLING VARIOUS HASH JOIN FUNCTIONALITY FROM COLLSUBQ_OPEN

CREATE SP INCLUDING A CREATE FUNCTOION STATEMENT FAILS IN GETVARTYPE INSTEAD OF RETURNING AN -201

SQ_SGKTUPLE DOESN'T CONTAIN THE CORRECT SERIAL VALUE FOR AN REMOTE INSERT INITIATED BY JDBC AND GETGENERATEDKEYS()

AUTO_REPREPARE CAN CAUSE SEGV IN SQ_REPREPARE OR GETRETTYPEINFO OF PREPARED INSERT CURSOR

WALMART: CUSTOMER REPORTED QUERY RUNS FASTER USING PLAN WITH A HIGHER COST VIA ORDERED DIRECTIVE THAN CHOSEN LOWER COST PLAN

IFX_DEF_TABLE_LOCKMODE PARAMETER IS IGNORED WHEN USING SELECT INTO RAW/STANDARD TABLE

MEMORY LEAK IN CONNECTION MANAGER WHEN USING DRDA CONNECTIVITY

MISSING ENTRIES IN SYSCONSTRAINTS AND SYSOBJSTATE AFTER CREATE TABLE ... AS SELECT OR SELECT INTO WITH AGGREGATE ON SERIAL COLUMN

PARSING QUERY WITH MANY UNION ALL ON DERIVED TABLES IN NESTED / RECURSIVE FASHION CAN PARSE STATEMENT FOR HOURS

SM_DISCON THREAD CAN ASSERT INVALID MUTEX TYPE CALLING SIGCLIENT_DEAD FROM NET_SM_DISCON_THREAD_FREE_STATINFO

ASSERT WARNING: GENERIC PAGE BUFFERS STILL HELD!

ERROR 768 SEEN IN SQOPTIM NO VALID QUERY PLAN GENERATED.

ENGINE CRASH IN MBLTRIM WHEN FILTER ON SUBQUERY OF DIFFERENT TYPE USING TRIM, SHOULD RETURN -880

ERRORS 25737 AND 937 WHEN GENERATING OUTPUT/UNLOAD

RUNNING A QUERY WITH MERGE FAILS WITH ERRORS -959/-172 AND CREATES AN ASSERTION

DELAY_APPLY IS SET TO A WRONG VALUE IN PRIMARY IF IT IS SET TO A VALUE HIGHER OF 9 HOURS IN RSS

RUNNING A SPL THAT INVOLVES THE USE OF ROW TYPE AND MULTISET COLLECTION VARIABLES FAILS WITH ERROR -9875

ONCHECK -PT INDEX USAGE INFO IS NOT UPDATE CORRECTLY

BROKEN SSL CONNECTION WHEN FETCHING A SIMPLE SELECT STATEMENT

ASSERT SEGV IN PROPENDB RUNNING SELECT AGAINST SYSMASTER:SYSOPENDB WHILE OTHER SESSIONS OPENING DATABASE

DBSCHEMA DOES NOT DISPLAY THE CORRECT COMMANDS FOR REPRODUCING THE PLOGSPACE

ISAM ERROR - 125 (ISAM ERROR: CAN'T USE NFS.) AND -88103: CANNOT OPEN CATALOG TABLE WHEN CREATING THE PSM CATALOG

EXTERNAL RESTORE WITH RENAME CREATES RESERVED PAGES WITH OLD PAGE FORMAT

INDEX ON DECIMAL CAN GIVE WRONG RESULTS FOR SELECT

CONNECTION MANAGER WILL RETURN A TRUNCATED IP AND CAUSE FRONT END TO HANG IF DRDA ALTERNATE SERVER IS USED.

CONNECTION MANAGER SSL CONNECTIONS REQUIRE THE CMNAME.KDB (KEYSTORE / TRUSTSTORE) TO USE A DEFAULT CERTIFICATE, WHICH IS A CONCEPT THAT HAS BEEN DEPRECATED IN GSKIT V8

AFTER MIGRATION TO 12.10.FC12 CUSTOMER GETS ERRORS TRYING TO WRITE TO AUDIT FILES CANNOT WRITE TO AUDIT FILE " AND " AUDIT TRAIL CREATION FAILED FOR "

SHOULD ISSUE A WARNING ASSERTION IF A NEW (POTENTIALLY SUB-OPTIMAL) QUERY PLAN IS USED BECAUSE OF A BAD INDEX

FIRST 1 AND ORDER BY CHOOSES AN UNFAVOURABLE QUERY PLAN

THE REPACK INDEX OF THE EMPTY TABLE RETURNS ERROR 172 IN ONLINE.LOG INSTEAD OF MEANINGFUL MESSAGE.

WRONG RESULTS POSSIBLE FOR SELF-JOIN IN A CORRELATED SUBQUERY WITH EXISTS AND ROWID

WRONG RESULT RETURNS BY QUERY WITH A JOIN AND USING ORDER BY WITH SUBSTRING OPERATOR

"DELAYED:DYNAMICALLY ALLOCATED.:" MESSAGE IN ONLINE.LOG NOT CORRECT

INFORMIX INSTALL FAIL IN CONCOLE MODE IF DISPLAY IS SET INCORRECTLY