Fix list for Informix Server 11.70.xC9W1

Informix Server provides periodic fixes for release 11.70. The following list is the most recent report of fixes for customer-reported defects in versions 11.70.xC9W1. 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

96393

UPDATE STATISTICS HIGH FOR A TABLE USING FRAGMENT LEVEL STATISTICS MAY CONSUME EXCESSIVE MEMORY

96557

ONMODE -C BLOCK ON RSS NODE CAN REPORT COMMAND HAS TIMED OUT (REGARDLESS OF TIMEOUT VALUE) IF THERE'S LOG ACTIVITY HAPPENING ON

IT03617

TRUNCATE TABLE FOR TABLE WITH SPATIAL DATA FAILS WITH -674 IF DISTRIBUTION EXISTS AND WAS CREATED BY ANOTHER USER

IT15877

VARIOUS ASSERTION FAILURES FOR QUERY WITH WHERE IN-CLAUSE

IT17086

SELECT WITH LIKE ON A NVARCHAR COLUMN IN A UTF8 DATABASE CAUSES WRONG RESULTS

IT17087

ERROR -5030 WHEN CONNECTING TO A SPWDCSM PASSWORD ENCRYPTED SERVER

IT18548

TRIGGER CALLING A STORED PROCEDURE USING SET PARAMETER CAUSES EXCEPTION IN INSONE_NEXT EXPRESSION EVALUATION

IT20880

HPL ONPLOAD LOAD JOB DOES NOT LOAD ALL ROWS INTO TABLE AND FAILS WITH ERROR HPL FAILPOINT 14100

IT21014

ONCHECK -CI REPORTS INDEX CORRUPTION ON INDEX AFTER ALTER TABLE ADD PRIMARY KEY CONSTRAINT COMMAND RUN

IT21280

WITH DELAY_APPLY SET WHEN PRIMARY IS RESTARTED AFTER THE LOGICAL LOG WRAP IT STOPS SENDING NEW LOGICAL LOGS TO RSS UNTIL DELAY_A

IT21374

EXECUTE FUNCTION EXECTASK('AUTO UPDATE STATISTICS EVALUATION') RETURNS ERROR -310

IT21503

SET EXPLAIN ON FAILS WITH -874 IN HAS_RTCONSTOP()

IT21878

768: INTERNAL ERROR IN ROUTINE OPJOIN() IN QUERY WITH MULTIPLE JOINS

IT21954

DURATION OF DEFINING A MASTER REPLICATE WOULD INCREASE EXPONENTIALLY WITH THE NUMBER OF FRAGMENTED TABLES IN ANY ONE DATABASE IN

IT22140

ASSERT WARNING: I/O BAD REQUEST CHUNK 73, PAGENUM 22967, PAGECNT 3 DURING LEVEL 0 BACKUP

IT22289

QUERY CHOOSING SKIP SCAN WOULD CRASH IN REMOTE_SCAN_CREATE() IF INVOLVING A REMOTE SUBQUERY

IT22534

CUSTOMER IS ABLE TO CONNECT TO INFORMIX SSL LISTENER WITH OPENSSL COMMAND USING -CIPHER "DES:3DES"

IT22536

ASSERT FAILURE MEMORY FREED TWICE IN FREELKCOUNT

514570

IDS_INSTALL TO CREATE RPMS FAILS BACKPORT

97458

ASSERT FAILED ROLLBACK ERROR 101 CAUSED BY TRYING TO ROLLBACK WORK ON A LOGGED TEMP TABLE THAT HAS BEEN ALLOWED TO BE DROPPED BY NON-OWNING SESSION

97423

IN A NON-LOGGING DATABASE LOCKS ON SYSPROCPLAN ARE HELD TOO LONG WHEN TRIGGER REFERENCES ARE USED AND A SPL CONTAINS A SELECT

97455

USING TEMP TABLES AND STORED PROCEDURES BY PREPARED STATEMENTS OR 4GL PCODE MAY LEAD TO SQL LAYER GETTING OUT OF SYNC WITH RSAM ON OPEN FILES

97459

MEMORY LEAK IN "GLOBAL" MEMORY POOL

97069

A QUERY IS NOT WORKING WITH A SPECIFIC VALUE

97141

DBSCHEMA DOES NOT SHOW THE NOT NULL CONSTRAINTS

96872

SWITCH PRIMARY ROLE TO SECONDARY CAUSES SERVER CRASH

96876

BTREE SEARCH OPERATIONS WITH INTENTION TO MODIFY MAY UPDATE MANY PAGES WITH POTENTIAL FOR PHSYICAL LOG OVERFLOW

97332

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

96879

ASSERT FAILED IN CLGETCOL() - QUERY WITH CONNECT BY PRIOR