Fix list for Informix Server 12.10.xC13

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

ID

DESCRIPTION

IT15627

OPTIMIZER NEEDS A LOT OF SHARED MEMORY

IT26216

BEHAVIOUR OF AN HDR PAIR AFTER A NETWORK FAILURE

IT26222

EXECUTING QUERIES USING XML EXISTSNODE ROUTINE IN PARALLEL CAN ASSERT SERVER

IT26272

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

IT26321

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

IT26368

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

IT26437

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

IT26441

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

IT26528

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

IT26556

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

IT26655

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

IT26745

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

IT26852

INCORRECT NEXT EXECUTION FOR A NEW SCHAPI ADMIN TASK

IT27022

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

IT27027

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

IT27070

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

IT27091

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

IT27098

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

IT27165

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

IT27259

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

IT27262

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

IT27283

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

IT27310

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

IT27689

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

IT27709

PRIMARY AND SECONDARY UNABLE TO RECONNECT AFTER NETWORK FAILURE

IT27756

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

IT27851

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

IT27884

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

IT27890

START_ONPLOAD PROCEDURE FACILITATES A SHELL ON THE DATABASE SERVER MACHINE

IT27893

ONTAPE STDIO SEEMS TO IGNORE THE -ENCRYPT OPTION ON RESTORE

IT27930

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

IT27956

SYSSESSIONS OCCASIONALLY NOT RETURNING CURRENT SESSION

IT27997

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

IT28015

STORED PROCEDURE TO CREATE EXTERNAL TABLE FAILS WITH ERROR -26180

IT28075

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

IT28161

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

IT28181

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

IT28237

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

IT28256

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

IT28273

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

IT28275

BSON_UPDATE $SET OPERATOR CRASHING WITH EMPTY KEY

IT28278

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

IT28280

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

IT28296

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

IT28301

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

IT28305

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

IT28321

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

IT28327

MORE CDR COMMANDS FAILING WITH DELIMIDENT SET IN ENVIRONMENT

IT28329

CRASHES POSSIBLE WITH QUERIES ON ATS/RIS RELATED SMI TABLES

IT28330

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

IT28339

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

IT28341

ODD BEHAVIOUR WHEN USING CONCAT IN CASE STATEMENT IN SPL

IT28352

DBACCESS TAKES A VERY LONG TIME BEFORE RETURNING ERROR CODE 25588

IT28357

EXCESSIVE CALLING OF ALARM SCRIPT CAUSES COMPLETE RESOURCE CONSUMPTION.

IT28359

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

IT28384

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

IT28386

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

IT28387

ASSERT FAILURE WHILE CREATING A PROCEDURE ON 12.10FC12W1

IT28406

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

IT28407

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

IT28448

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

IT28466

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

IT28475

REPLICATION OF COMPRESSED BLOBS MAY REPORT CDREXPANDROW MESSAGES

IT28477

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

IT28478

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

IT28479

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

IT28480

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

IT28481

DIRECT_IO FOR TEMP DBSPACES

IT28482

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

IT28483

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

IT28485

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

IT28486

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

IT28501

PUSH DATA REPLICATES GETTING DELETED AFTER BOUNCING REMOTE ER SERVER

IT28516

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

IT28529

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

IT28535

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

IT28575

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

IT28595

INCORRECT BEHAVIOR FOR THE OLAP WINDOW EXPRESSION

IT28604

SERVER NEEDS TO PREVENT AUTO REGISTRATION OF BLADES IN SYSMASTER DATABASE

IT28702

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

IT28703

ONSNMP CRASHES ON STARTUP IN DEF_CV_TABLE

IT28718

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

IT28752

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

IT28754

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

IT28803

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

IT28836

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

IT28857

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

IT28896

MEMORY LEAK IN CONNECTION MANAGER WHEN USING DRDA CONNECTIVITY

IT28933

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

IT28942

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

IT28944

SM_DISCON THREAD CAN ASSERT INVALID MUTEX TYPE CALLING SIGCLIENT_DEAD FROM NET_SM_DISCON_THREAD_FREE_STATINFO

IT28949

ASSERT WARNING: GENERIC PAGE BUFFERS STILL HELD!

IT28950

ERROR 768 SEEN IN SQOPTIM NO VALID QUERY PLAN GENERATED.

IT28962

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

IT28978

ERRORS 25737 AND 937 WHEN GENERATING OUTPUT/UNLOAD

IT29116

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

IT29117

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

IT29119

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

IT29124

ONCHECK -PT INDEX USAGE INFO IS NOT UPDATE CORRECTLY

IT29138

BROKEN SSL CONNECTION WHEN FETCHING A SIMPLE SELECT STATEMENT

IT29144

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

IT29147

DBSCHEMA DOES NOT DISPLAY THE CORRECT COMMANDS FOR REPRODUCING THE PLOGSPACE

IT29149

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

IT29150

EXTERNAL RESTORE WITH RENAME CREATES RESERVED PAGES WITH OLD PAGE FORMAT

IT29151

INDEX ON DECIMAL CAN GIVE WRONG RESULTS FOR SELECT

IT29172

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

IT29173

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

IT29215

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 "

IT00296

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

IT08893

FIRST 1 AND ORDER BY CHOOSES AN UNFAVOURABLE QUERY PLAN

IT10304

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

IT10307

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

IT12048

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

IT13300

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

IT19163

INFORMIX INSTALL FAIL IN CONCOLE MODE IF DISPLAY IS SET INCORRECTLY