Product Documentation
Abstract
Informix Server provides periodic fixes for release 11.70. The following list is the most recent report of fixes for customer-reported defects in Version 11.70.xC5 and 11.70.xC5W1. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.
Content
| Fix release date: 20 July 2012 Last modified: 02 May 2016 Status: Recommended  Download information | |
W1 APARs | Description |
| IC78544 | ONSTAT -G NTU / NTT DO NOT REPORT CORRECT INFORMATION FOR DBSCHEDULER THREADS |
| IC79310 | CREATING AN INDEX ON A FRAGMENTED TEMP TABLE THROWS -212/-113 AS DOES CREATING A FRAGMENTED INDEX ON A TEMP TABLE |
| IC80634 | DB_LOCALE MAY BE SET INCORRECTLY IN INIT_SQSCB FOR THE SESSION WITH MULTIPLE REMOTE QUERIES |
| IC80652 | THE PRINT FILE INFO ARGUMENT WITH THE TASK() FUNCTION DOES NOT WORK. |
| IC82084 | SELECT FROM SYSENVSES CAN LEAD TO AN ASSERTION FAILURE IN PRENVSESVAR |
| IC82171 | INSTANCE ABORT POSSIBLE WHEN INDEX KEY DESCRIPTOR ON PARTITION PAGE IS CORRUPTED |
| IC82240 | DBSPACE IS FULL ALARM EVENT 44 IS NOT FIRED WHEN ERROR 264/131 RETURNED TO THE SESSION |
| IC82645 | SKIP SCAN CAN BADLY SUFFER FROM LIGHT SCANS |
| IC82658 | UNABLE TO GET LOCALIZED ERROR MESSAGES FROM A DRDA CLIENT |
| IC82659 | ENGINE DROPS ASSERT WARNING: NET_SEND_LOCAL_ON FOUND NON-NULL SCB->PLSCB ON TASK() CALL |
| IC82784 | QUERY WITH CORRELATED SUBQUERY USING BOTH IS NULL AND IS NOT NULL ORED CONDITIONS FOR THE SAME COLUMN CAN BE VERY SLOW |
| IC82990 | FUNCTIONAL INDEX SCAN OF REMOTE TABLE MIGHT NOT WORK CORRECTLY IN A CROSS-DATABASE QUERY |
| IC82992 | DRDA: SERVER MIGHT TERMINATE WHEN A STORED PROCEDURE WHICH IS EXECUTED IN A TRANSACTION FAILS WITH ERROR -535 |
| IC83016 | STARTUP OF DWA FAILS WITH ASSERTION STR.TELLG > 0 FAILED WHEN SEND_QUEUE_SIZE IS NOT EXPLICITLY SPECIFIED IN THE NODE CONFIG |
| IC83018 | CDRSCN_<> THREAD COULD ASSERT FAIL IF A CDR STOP REPL COMMAND IS USED TO STOP THE REPLICATE WHILE THE CDR SYNC REPLICATE IS RUN |
| IC83075 | -768 SQL ERROR: INTERNAL ERROR IN ROUTINE READRIDS(): SC_NONSEQ MODE NOT SUPPORTED. |
| IC83253 | FOR A SELECT INVOLVING A FILTER WITH SUBQUERY A MORE EXPENSIVE QUERY PLAN MIGHT BE CHOSEN WHEN DISTRIBUTIONS EXIST |
| IC83254 | POSSIBLE SQLEXEC THREAD ASSERT FAILS IN SEQ_PUTROW WITH BATCHREAD_TABLE ENABLED |
| IC83255 | CRASH SEGV IN FUNCTION RA_PAGE_ALREADY_READ ON READAHEAD (READAHEAD) THREAD WHEN MEMORY IS LOW |
| IC83332 | SQL ERROR 240 ISAM ERROR 103 WHEN TRYING TO DELETE FROM A TABLE WITH A FIX OF ATTACHED AND DETACHED INDEXES AND DELETE USES KEY |
| IC83388 | LONG TRANSACTION ROLLBACK HANG POSSIBLE WHEN USING REMOTE DATABASE QUERIES IF REMOTE CONNECTION ATTEMPT HANGS |
| IC83390 | ONMODE -P -1 JVP CRASHES THE DATABASE SERVER |
| IC83410 | CM PRINTS A WARNING MESSAGE WHICH REFERENCES CLUSTER NAME AND INFORMIX ALIAS IN WRONG ORDER |
| IC83411 | CREATE PROCEDURE STATEMENT ABEND IDS SERVER IN OP_JOIN(). |
| IC83412 | CONCAT() FUNCTION DOES NOT WORK CORRECTLY FOR AN LVARCHAR TYPE WHICH IS CASTED FROM AN HTML TYPE |
| IC83539 | ONRESTOREPT REPORTS ERROR FAILED TO PROCESS THE RESERVE PAGES IF $ONCONFIG IS NOT SET IN ENV. |
| IC83541 | UPDATE STATISTICS FOR PROCEDURE AFTER MIGRATION SHOULD NOT RETURN -721 BUT -26060 |
| IC83542 | CDC ERROR -83800 CAUSED BY LOG PAGE READER READING A POSITION IS CLOSE TO THE WRITE POSITION |
| IC83757 | EXECUTING A REMOTE PROCEDURE DOES NOT WORK VIA DRDA |
| IC83760 | INTERMITTENT PERFORMANCE PROBLEM USING RSAM BATCH SEQUENTIAL SCANS DUE TO EXCESSIVE LOCK CHECKING ACTIVITY |
| IC83765 | ASSERT FAILED: SLOT ALLOCATION ERROR IN ONLINE.LOG; AF FILE SHOWS ALLOCSLOT: ATTEMPTING TO ALLOCATE SLOT ON OLD (0) VERSION PAGE |
| IC83780 | EXECUTING STORED PROCEDURES WHILE UPDATING STATISTICS ON THE PROCEDURES FAILS WITH LOCKING ERRORS 211/144 312 211/107 |
| IC83886 | ERRORS 25572 AND 8 WHEN BRINGING THE SERVER ONLINE USING TLITCP AND AN IP ADDRESS IN THE SQLHOSTS FILE |
| IC83921 | ONSTAT -U ERRONEOUSLY SHOWS THREADS WAITING ON BUFFERS |
| IC83930 | SELECT * FROM SYSSQEXPLAIN RETURNS SQX_ISCURRENT N WHERE THE VALUE WAS Y ON 11.50 |
| IC83941 | EXECUTION OF TASK() FOR DBSPACE CREATION RETURNS WRONG ERROR WHEN DBSPACE_NAME PARAMETER CONTAINS EXTRA SPACE |
| IC83942 | MISSING SPACE DBSPACE_NAME ADDED. MESSAGE IN THE ONLINE.LOG AFTER TASK() FUNCTION EXECUTION FOR DBSPACE CREATION |
| IC83948 | DECRYPT_CHAR() FAILS WITH ERROR 26012: THE INTERNAL BASE64 DECODING FUNCTION FAILED |
| IC83967 | CDC RESTART MAY CAUSE LOSS OF REPLICATED DATA |
| IC83969 | AFTER TRYING TO START CM TWICE AND THEN STOP CM WHERE ARBITRATOR IS ACTIVE, ARBITRATOR IS LOST |
| IC84065 | CM REPORTS ATTEMPT OF CHANGING PRIMARY ON STARTUP BUT THE MESSAGE IS ESSENTIALLY ABOUT ONE PRIMARY INSTANCE |
| IC84094 | SKIP SCAN ACCESS TO A COMPRESSED TABLE CAN RETURN BAD RESULTS, GENERATE (TPOS >= START) ASSERT WARNING OR AN AF IN PTMAP |
| IC84229 | ASSERTIONS MAY OCCUR WHEN COLLECTION VARIABLES ARE USED AS GLOBAL VARIABLES |
| IC84408 | DRDA: SQLCA.SQLERRD2 CONTAINS NUMBER OF ROWS FROM PREVIOUS STATEMENT |
| IC84421 | EXECUTING STORED PROCEDURES WHILE UPDATING STATISTICS ON THE PROCEDURES FAILS WITH ERROR 312 ON SYSPROCPLAN |
| IC84723 | FATAL ASSERTION CRASH (SEGV) IN FUNCTION TABINEXPR WHEN LEFT JOIN USED |
| IC84804 | UPDATE STATISTICS BEHAVIOR IS INCONSISTENT RIGHT AFTER UPGRADE TO 11.70 USING DEFAULT SETTINGS OF AUTO_STAT_MODE AND STATCHANGE |
| IC84847 | WITH BATCHREAD_INDEX USING A PREPARED STATEMENT, IF LOCK ERRORS ARE ENCOUNTERED, IT CAN CAUSE READ_RECORD: DELETED ROWID ASSERTION FAILURES |
| IC85043 | UDR CACHE IN NEED OF URGENT PERFORMANCE IMPROVEMENTS - IN PARTICULAR FOR SPLS WITH GLOBALS |
xC5 APARS | Description |
| IC77892 | RSS SECONDARY IS NOT ALWAYS MARKED AS DISCONNECTED ON MACH11 PRIMARY IN CASE OF NETWORK FAILURE |
| IC78377 | IF STATEMENT JOINS MANY DERIVED TABLES, IT CAUSES SQLEXEC THREAD TO LOOP INFINITELY |
| IC78546 | ONCONFIG PARAMETER BATCHEDREAD_KEYONLY IS NOT DOCUMENTED |
| IC78556 | CONVERSION GUARD CORRUPTS OUTPUT FOR ONCHECK -CR & -PR AFTER ONRESTOREPT HAS BEEN RUN |
| IC78670 | HOSTNAME EASILY CHANGED IN AUDIT LOGS |
| IC78762 | FINDERR 460 INDICATES INCORRECT MAXIMUM STATEMENT LENGTH 32K |
| IC78810 | SELECT FIRST/LIMIT INTO EXTERNAL TABLES RETRIEVES INCORRECT NUMBER OF ROWS |
| IC78847 | SERVER CRASH IN MKATTNODE WHEN READING SYNONYM TABLES DATA DICTIONARY INFORMATION USING DIRTY READ WITH CONCURRENT ALTER TABLE |
| IC78848 | CONCURRENT DELETE WITH BATCHEDREAD_INDEX SET ISSUES SPORADIC DEADLOCK ERRORS |
| IC78881 | QUERY RUN AS A USER WHO HAS BEEN GRANTED A ROLE AGAINST UPDATABLE (SDS) GIVES ERROR -272. WORKS FINE ON PRIMARY. |
| IC78924 | ERROR -285 INVALID CURSOR RECEIVED BY SQLEXEC IF SCROLL CURSOR AND REGULAR CURSOR WITH SAME SQL STATEMENT AND STMT_CACHE IS SET |
| IC78939 | UPGRADE TO IDS 11.70.XC3 FAILS WITH SQLCODE = -591 IF DEFINED PROCEDURE HAS REFERENCE TO A TABLE COLUMN WITH A DEFAULT VALUE |
| IC78963 | DESCRIBE OF PREPARED STATEMENT CALLING SPL RETURNS WRONG SIZE FOR SECOND INPUT PARAMETER |
| IC78965 | LARGE QUERY JOINING MANY PERMANENT AND TEMPORARY TABLES TAKES LONGER TO OPTIMIZE ON 11.70.XC3 THAN IT DID ON 11.70.XC2 |
| IC79133 | ONSTAT -G AFR DOES NOT SHOW FILE NAME FOR RDAHEAD MEMORY BLOCK |
| IC79194 | DBACCESS DIES WITH A MEMORY FAULT (COREDUMP) MESSAGE WHEN YOU HAVE A STORED PROC WITH 200+ PARMS |
| IC79256 | CLOSING FRAGMENTED TABLES WITH ONLY ONE FRAGMENT LEAKS MEMORY |
| IC79258 | UNABLE TO INSTALL PATCH PRODUCT OVER THE EXISTING 11.70.XC3 INSTALL |
| IC79263 | VARCHAR PARAMETER VALUES IN STORED PROCEDURES CORRUPTING MEMORY IF USED IN EXCEPTION |
| IC79304 | TIMESERIES: DELRANGE()/DELTRIM() HAS EXCESSIVE BUFREAD |
| IC79306 | WRONG SETTING OF SQLIDEBUG WILL LEAD TO ERROR TRYING TO START DBACCESS AND ONSTAT |
| IC79307 | ONMODE -D STANDARD AS WELL AS ONMODE -D MAKE PRIMARY HANG TURNING RSS INTO STANDARD SERVER |
| IC79308 | USERS GET -27002 IF LOG_STAGING_DIR IS SET AND LOG LAG AFTER ENGINE RESTART REGARDLESS OF CDR_LOG_LAG_ACTION SETTING |
| IC79316 | TSBINLOADPUT GIVES ASSERT FAILURE WHEN LOADING FROM CORRUPTED DATA FILE |
| IC79317 | SNAPSHOT-CLONE: IFXCLONE FAILS TO WORK ON INFORMIX EDITIONS WHICH HAVE PARALLEL OPTION DISABLED, GROWTH EDITION FOR EXAMPLE |
| IC79320 | A QUERY WITH OUTER JOINS ENTERS AN INFINITE LOOP ALLOCATING MEMORY |
| IC79323 | CDCAPI.EC INCLUDED IN DOC WILL NOT WORK ON AIX |
| IC79376 | IN OUT OF MEMORY CONDITION SQLEXEC THREAD CAN CRASH IN SQ_EXFPROUTINE DUE TO NULL SQTCB->CURRSDB |
| IC79377 | CDR SYNC SELECTS ALL ROWS IN SOURCE TABLE WHEN TARGET TABLE IS EMPTY RESULTING IN UNNECESSARY STARTUP TIME |
| IC79378 | SYSTEM ABEND WHEN ATTEMPTING TO CREATE FOREST OF TREES (FOT) FUNCTIONAL INDEX |
| IC79433 | TIMESERIES FAST LOADER WILL SET CAL_OFFSET TO -1 WHEN DATE PRECEDES ORIGIN DATE OR FALLS BETWEEN CALENDAR BOUNDARIES |
| IC79434 | EXCESSIVE MEMORY USE OF EXE. POOLS WHEN CALLING TIME SERIES UDRS INSIDE SPL PROCEDURE |
| IC79455 | NOT ABLE TO INSTALL A SPECIAL BUILD RELEASE ON TOP OF ANOTHER SPECIAL BUILD RELEASE |
| IC79477 | ERROR -647 RAISED IN CALC_SEEK_COST() WITHIN LOG FUNCTION ON SOLARIS |
| IC79488 | HINSERT LOG RECORD INCORRECTLY BEING SWITCHED INTO AN HUPDAFT RECORD |
| IC79557 | RANGE OF VALUES DESCRIPTION FOR UPDATABLE_SECONDARY IS INCORRECT |
| IC79561 | DELRANGE REPORTING (UTSCJ) - PAGE 5 IN CONTAINER CO_VEE_INT_001 IS CORRUPT WHEN END DATE BETWEEN ORIGIN AND FIRST ELEMENT DATES |
| IC79569 | FOREST OF TREES (FOT) INDEX ACCESS DOES NOT WORK FOR OR INDEX PATH |
| IC79657 | ERROR -285 INVALID CURSOR RECEIVED BY SQLEXEC IF SCROLL CURSOR AND REGULAR CURSOR WITH SAME SQL STATEMENT AND STMT_CACHE IS SET |
| IC79660 | FATAL ERROR: STATUS FILE CREATION FAILED. WHEN $INFORMIXDIR/TMP NOT WRITABLE |
| IC79716 | ALTER TABLE ADD PRIMARY KEY ON AN EXISTING UNIQUE INDEX RUNS SLOW |
| IC79796 | REVERTING FROM 11.70.XC3 OR XC4 FAILS WHEN THERE ARE OUTSTANDING IN PLACE ALTERS |
| IC79798 | UPDATABLE SECONDARY REMAINS IN UPDATES BLOCKED STATE AFTER TEMPORARY NETWORK DISCONNECT |
| IC79806 | SELECT FROM SYSPTNBIT PSEUDO TABLE CAN LEAD TO ASSERTION FAILURE |
| IC79808 | PERFORMANCE DEGRADATION OF DATA TRANSMISSION VIA SSL ENCRYPTED CONNECTION COMPARED TO STANDARD SOCKET CONNECTION. |
| IC79841 | CSM (ENCRYPTION) VPS CAN HANG IN TIGHT LOOP |
| IC79864 | QUERY ON A VIEW WITH MANY TABLES AND MANY OUTER TABLES IS MUCH SLOWER AFTER MIGRATION FROM 11.50.FC3 TO 11.70.FC3. |
| IC79892 | SELECT ON SYSSQLSTAT CRASHES IDS ON WINDOWS 2008 |
| IC79894 | SH_OVLMAXCONS NOT UPDATED DURING CHECKPOINT AT SHUTDOWN |
| IC79897 | FRAGMENT ELIMINATION NOT USED WHEN A CURSOR USES HOST VARIABLES |
| IC79943 | WRONG RESULTS WHEN A SUBQUERY IN A NOT EXISTS CLAUSE IS FLATTENED |
| IC79945 | ERROR -768 IN OPJOIN() EXECUTING STATEMENT USING VIEW WHEN IFX_FOLDVIEW IS SET |
| IC79959 | ONSTAT -G SES OUTPUT ON HDR SECONDARY SHOWS JUNK IN HOSTNAME FOR ONE OF THE SESSIONS |
| IC79978 | ERROR -246/-111 WITH BATCHEDREAD_INDEX ON NON-LOGGED DATABASE |
| IC79980 | ERROR -1225 IN EVALCOLS() WHEN SELECTING A TEXT COLUMN |
| IC79981 | QUERY INCLUDING SUBSTR(COL,X,Y) FUNCTION CAN BE OFFLOADED TO IWA, BUT EQUIVALENT NOTATION COL[X,Y] IS REJECTED AND PROCESSED LOC |
| IC79983 | ONSTAT CAN SHOW ADDITIONAL UNINTENDED CHARACTERS AFTER THE ROLE NAME IN THE CURRENT ROLE OUTPUT |
| IC79984 | DISPLAY OF SQL COMMAND IN ONSTAT -G SES OR ONSTAT -G SQL CAN MISS SPACE CHARACTERS |
| IC80084 | AFTER THE ALTER SEQUENCE RESTART COMMAND THE SEQUENCE GETS RESTARTED AGAIN WITH ANY OTHER ALTER SEQUENCE COMMAND |
| IC80085 | INCORRECT USAGE OF TABLE EXPRESSIONS CAN LEAD TO AN ASSERT FAIL IN STCMPR WHEN AGGREGATES ARE INVOLVED |
| IC80087 | SOLARIS: BTS BLADE IS COMPILED IN DEBUG MODE |
| IC80089 | CPUVP COULD NOT BE REMOVED IF EACH LISTEN THREAD WORKS ON EVERY CPUVP BUT THIS RESTRICTION IS NOT DOCUMENTED. |
| IC80100 | SELECTING FROM TIMESERIES VTI CAN CONSUME LARGE CMD MEMORY IF MANY OF THE ELEMENTS DO NOT MEET THE CRITERIA OF THE QUERY |
| IC80130 | SETCONTAINERNAME() API APPENDS EXTRA BYTE TO EACH TIMESERIES ELEMENT AFTER IT IS MOVED TO THE NEW CONTAINER |
| IC80134 | EMPTY TABLES ARE NOT DEFRAGMENTED |
| IC80136 | OPTIMIZER GIVES HIGH ESTIMATED COST AND ROWS RETURNED WITH VIEWS AND OUTER JOINS |
| IC80164 | UPDATE STATISTICS LOW WITH USTLOW_SAMPLE ENABLED CRASHES ENGINE |
| IC80166 | NULL DATE DATA SHOWS UP AS 00/00/0000 IN AN EXTERNAL TABLE |
| IC80167 | ERROR BTS CLUCENE ERROR: IO ERROR: FSE IO CANNOT OPEN FILE RANDOMLY OCCURS DURING LOCK CONTENTION |
| IC80182 | ASSERT FAILURE CRASH IN BUFFGET() |
| IC80187 | ADMIN GUIDE AND ADMIN REFERENCE HAVE DIFFERENT DESCRIPTIONS REGARDING SERVER MODE WHEN CHANGING PHYSICAL-LOG LOCATION OR SIZE |
| IC80234 | THE INSTANCE CAN CRASH IN MINDEX_BIDXFRAGS() IF THE SKIP SCAN METHOD IS USED TO ACCESS A TABLE |
| IC80277 | ONSTAT -G CKP SHOWING IPL CHECKPOINTS AS UNKNOWN |
| IC80280 | SOMETIMES, SCHEDULER SHUTDOWN FAILS TO SHUTDOWN ALL DBWORKER THREADS, WITH VARIOUS SYMPTOMS |
| IC80282 | ERROR -9791 ON RLT_OPEN WHEN R-TREE INDEX ON TEMPORARY TABLE WAS CREATED OUTSIDE OF XA TRANSACTION |
| IC80311 | DOCUMENT STATES YOU CAN INSERT DATA INTO BYTE AND TEXT COLUMNS USING ONLOAD |
| IC80313 | SELECT COUNT(*) IN A UDR CAN LEAD TO ASSERT FAILURE IN LDDBLNULL WHEN INDEX SKIP SCAN PATH IS CHOSEN BY THE OPTIMIZER |
| IC80320 | SETCONTAINERNAME() API APPENDS EXTRA BYTE TO EACH TIMESERIES ELEMENT AFTER IT IS MOVED TO THE NEW CONTAINER |
| IC80385 | DROPPING A BLOBSPACE FAILS IF NO CHECKPOINT OCCURRED BETWEEN TABLE CREATION AND DROPPING THAT TABLES TEXT OR BYTE COLUMN |
| IC80388 | LOW MEMORY MANAGER (LMM) IS NOT ABLE TO TERMINATE SESSIONS PROPERLY |
| IC80431 | WHEN PERFORMING LARGE RESULT SET QUERY ON TIME SERIES VTI TABLE, SEEMS TO STILL BE A CMD POOL MEMORY LEAK EVEN AFTER FIX FOR IC8 |
| IC80490 | ENHANCE ERROR 19803 TO MAKE MENTION OF INABILITY TO GRANT DEFAULT ROLE - WITH GRANT OPTION |
| IC80547 | ASSERT FAILED: NEGATIVE PARTNUM PASSED TO RA_PAGE_ALREADY_READ |
| IC80548 | PREPARE INSERT-SELECT ASSUMES EXCLUSIVE LOCK ON THE SELECT TABLE WHEN THERE IS NOT ONE AT ALL |
| IC80567 | OUTPUT OF MESSAGE DR GROUPER: LOCAL PARTICIPANT(...) STOPPED CAN LEAD TO ASSERTION FAILURE AF |
| IC80636 | ISOLATION LEVEL MIGHT BE TRACKED INCORRECTLY IN SMI TABLES WHEN SQL SET ISOLATION IS USED |
| IC80640 | UPDATE STATISTICS ON PROCEDURE OR CALL PROCEDURE CAN LEAD TO ASSERT FAIL IN WRTHOSTVAR WITH SET EXPLAIN ON |
| IC80653 | ASSERT FAILURE, CRASH IN PROPENDB WHILE QUERYING SYSMASTER:SYSOPENDB TABLE |
| IC80654 | ASSERTION FAILURE IN ROWALTER OR INCORRECT RESULTS WHEN USING COMMITTED READ LAST COMMITTED ISOLATION WHEN A ROW WITH VARCHARS IS DELETED |
| IC80741 | SLOW DRAINING OF SEND QUEUE DUE TO MUTEX CONTENTION WITH LARGE TRANSACTION VOLUME |
| IC80756 | 602/102 ERROR WHEN SELECTING A TEXT/BYTE COLUMN |
| IC80788 | MEMORY CORRUPTION AF CRASH WHILE INSERTING TIMESERIES DATA USING PUTELEMNODUPS |
| IC80837 | WHEN SELECT USING MATCHES OR LIKE USING CONDITION IN BETWEEN TWO MULTI-BYTE CHARACTERS DOES NOT RETURN ANY ROW EVEN IF THERE ARE |
| IC80858 | NEITHER SQL_RUNTIME NOR SQL_TOTALTIME ARE GIVING CORRECT TIME SPENT EXECUTING A STATEMENT |
| IC80866 | AUS EVALUATOR COULD FAIL WITH -242/-113 IN HDR ENVIRONMENT |
| IC80876 | SELECT FIRST 1 WITH AN ORDER BY USES A SEQUENTIAL SCAN AND A SORT INSTEAD OF A MATCHING COMPOSITE INDEX |
| IC80877 | TX STAMP AND PDQ FROM ONSTAT -G HIS OUTPUT ARE NOT DOCUMENTED |
| IC80879 | INCORRECT VALUE FOR PDQ IN ONSTAT -G HIS |
| IC80880 | ASSERTION FAILURE IN STMTMON_INSERT WHEN IFX_GRID_CONNECT() IS USED AND SQL TRACING IS ACTIVATED |
| IC80881 | CORRUPTED SQL AND ISAM ERROR SHOWN IN ONSTAT -G HIS EXECUTING 4GL PROGRAM WHEN PDQ IS ENABLED |
| IC80906 | SLOW PERFORMANCE EXECUTING DELETE STATEMENT WITH SUBQUERY USING PDQ IN 4GL PROGRAM |
| IC80913 | PASSWORD KEYWORD AS A RESERVED WORD IS LISTED IN BOTH VERSION 10.0 AND VERSION 11.70.XC2 FIELD IN MIGRATION GUIDE |
| IC80918 | UPDATE STATISTICS MAY RAISE ERROR 647 ON SOLARIS |
| IC80921 | AN UPDATABLE SECONDARY CAN CRASH WHEN RECONNECTING AFTER A DISCONNECT |
| IC80922 | IF USING UTF8 AND THERE ARE MORE THAN 18 CHARACTER COLUMNS, CDR CHECK CAN FAIL WITH ERROR -528 |
| IC80933 | THE DESCRIPTION OF RESERVED WORDS/SQL KEYWORDS IN THE MANUAL SHOULD BE MORE HELPFUL, USEFUL AND IN DETAIL. |
| IC80960 | NO DESCRIPTION ABOUT AUTOREG MIGRATE DB-NAME STARTUP TASK AND DESCRIPTION ABOUT SYSBLDPREPARE() FUNCTION IS INSUFFICIENT |
| IC80988 | ONDWA -V OUTPUT IS CONFUSING, AS IT DOES NOT REFERENCE IWA (INFORMIX WAREHOUSE ACCELERATOR) |
| IC81026 | INCORRECT RESULTS WHEN LEFT JOIN USED ON TABLE WITH LOCKED ROW |
| IC81028 | CDR REPAIR ATS COMMAND FAILS WHEN REPLICATED ROW CONTAINS A NULL IN THE PRIMARY KEY |
| IC81050 | RUNNING A QUERY WITH AGGREGATE FUNCTION AND GROUP BY WITH PDQ CAUSES A SERVER ABEND |
| IC81085 | CDR SYNC FAILS WITH 691 AND 111 ERRORS IF TABLE HAS RECURSIVE REFERENTIAL INTEGRITY RULES |
| IC81100 | BTS KEYWORD SEARCH DOES NOT WORK FOR ALL SUPPORTED DATA TYPES |
| IC81101 | SQL 242 ERROR RETURNED WHEN DROPPING TEMP TABLES WITH AUTO_READAHEAD ON |
| IC81102 | FINAL AND PREPARE AS RESERVED WORDS ARE MISSED IN MIGRATION GUIDE AND SQL GUIDE: SYNTAX. |
| IC81103 | SIGSEGV IN EXIT_THREAD CALLED FROM SQFAILREQUEST |
| IC81124 | BTS SCORE VARIABLE NOT RECOGNIZED FROM PREPARED STATEMENT IN SPL - ERROR 217 |
| IC81144 | ERROR -254 RETURNED OPENING A CURSOR WITH HOST VARIABLES |
| IC81145 | SQL ADMIN API DOC SAYS THAT ONMODE -Y 2 PREVENTS QUERY FROM EXECUTION WHICH IS NOT TRUE |
| IC81213 | SELECT WITH WHERE CLAUSE CONTAINING LIKE/MATCHES CONDITION WITH BLANKS AND WILDCARDS MIGHT RETURN WRONG RESULTS |
| IC81229 | BTS SNOWBALL INDEX CREATION FAILS WITH UNHELPFUL ERROR MESSAGE: BTS02 - BTS INTERNAL ERROR. |
| IC81249 | INCORRECT QUERY RESULTS WITH PUSH-DOWN HASH-JOIN PLAN AND PDQ ENABLED |
| IC81262 | LOGICAL LOG REPLAY ERROR ON RSS AFTER ALTERING EXTENT SIZE AND USING THE SHRINK METHOD |
| IC81282 | CDC API REPORTS WRONG DATA FOR COLUMN OF INTERVAL TYPE WITH PRECISION AND NOT NULL MODIFIERS |
| IC81339 | BTSCANNER CAN YIELD WAITING ON A BUFFER WITHOUT LEAVING A CRITICAL SECTION WHICH CAN LEAD TO A BLOCKED CHECKPOINT |
| IC81341 | CONNECTION WITH ENCRYPTED PASSWORD AND PAM THROUGH CM GETS ERROR -908 |
| IC81394 | MEMORY LEAK ON SCDR* POOLS ON A PRIMARY/RSS WHEN A LOGICAL LOG IS COMPLETE OR A CREATE DATABASE IS EXECUTED |
| IC81416 | DBACCESS REPORTS ERROR CANNOT OPEN FILE CALS.IEM |
| IC81451 | CDR ERROR COMMAND WITH LEAF NODES CAUSES SYSCDR:CDR_ERRORS TO FLOOD WITH GC OPERATION REVIEW ERROR FAILED: UNDEFINED SERVER MESSAGES |
| IC81557 | ADDING INTERVALS OF YEARS OR MONTHS SHOULD NOT GENERATE INVALID DATETIME ERRORS AT END OF MONTH |
| IC81590 | CRASH IN THE ASF TCP LISTENER THREAD |
| IC81591 | ENABLING IFX_FOLDVIEW MAY CAUSE ERROR 206/111 OR 242/102 |
| IC81741 | SERVER ABENDS IN MT_LOCK WHEN TRYING TO FREE SAPI MEMORY |
| IC81761 | WITH AUTO_REPREPARE SET TO 1 IT IS POSSIBLE TO SEE 1 BYTE MEMORY CORRUPTION WHICH CAN LEAD TO ALL SORTS OF ASSERTION FAILURES |
| IC81764 | SERVER BLOCKED AT CHECKPOINT WHEN A RACE CONDITION BETWEEN THE MAIN_LOOP() THREAD AND THE USER THREAD(SQLEXEC) OCCUR |
| IC81766 | CALL OF ST_ISVALID() RETURNS ERROR -392 |
| IC81768 | ERROR 768: INTERNAL ERROR IN ROUTINE OP_REARRANGE_DTS: WRONG NUMBER OF TABLES WITH STAR JOIN AND PDQ |
| IC81890 | DATABASE SERVER CAN USE THE WRONG FILE DESCRIPTOR STRUCTURES TO ACCESS A TABLE DUE TO DATABASE SERVER FILE DESCRIPTOR MIX-UP |
| IC81891 | VARIOUS ASSERTION FAILURES SEEN WHEN RUNNING MULTIPLE, CONCURRENT SPLS AND UPDATE STATISTICS AT THE SAME TIME |
| IC81892 | /TMP DIRECTORY IS NO LONGER USED FOR TEMPORARY DATA WHEN YOU RUN SELECT STATEMENTS WITH THE GROUP BY CLAUSE OR ORDER BY CLAUSE |
| IC81900 | ERROR 9791 WHEN USING MULTISET AND RALLOC_MODE POOL ENABLED |
| IC81962 | SYNCING AN ERKEY REPLICATE FAILS IF SOME, BUT NOT ALL PARTICIPANTS HAVE A PRIMARY KEY DEFINED |
| IC81965 | ASSERT WARNING : INTERNAL ERROR - FREEING TRANSACTION ENTRY THAT STILL HOLDS LOCKS! IS ALARMED AT SEVERITY 5 |
| IC81967 | CASE EXPRESSION WITH NEGATIVE INT8 VALUES RETURNS WRONG RESULT |
| IC82007 | SELECT FIRST 1 RETURNS ALL RECORDS SATISFYING THE CONDITION, INSTEAD OF RETURNING 1 RECORD |
| IC82085 | MEANINGLESS WARNING MESSAGE IN ONLINE.LOG: FAILED TO INITIALIZE VIRTUAL PROCESSOR OF CLASS AIO. |
| IC82166 | AUTOREGISTRATION OF SPATIAL DATABLADE WHEN A STORED PROCEDURE NAMED ST_* OR SE_* IS EXECUTED |
| IC82170 | EXECUTE PROCEDURE OF PROCEDURES OR FUNCTIONS NAMED ST_* OR SE_* NEEDS MORE THAN 2 MINUTES |
| IC82178 | GROUP BY ON INNER COLLECTION SUBQUERY AND FILTER ON OUTER COLLECTION SUBQUERY APPLIES FILTER IN ERROR AND CAUSES WRONG RESULTS |
| IC82179 | PREPARED INSERT/UPDATE WHEN EXECUTED ON SDS DOES NOT SHOW ON SDS ON FOLLOWING DML STATEMENT UNTIL SOME DELAY |
| IC82227 | IN A NON-LOGGING DATABASE A MEMORY LEAK MIGHT BE OBSERVED IN A SESSION POOL, MEMID SQL |
| IC82283 | PROXY THREAD ASSERT FAILS AND ABORTS PRIMARY WHEN DML STATEMENTS ISSUED FROM UPDATABLE SECONDARY INVOLVE TRIGGERS AND FUNCTIONAL INDEXES |
| IC82288 | RUNNING SELECT FROM SYSDRI MULITPLE TIMES WITH PDQPRIORITY SET LEADS TO NO ROWS FOUND SQL ERROR 100 HPL FAILPOINT 11431 AND 11008 |
| IC82310 | LINUX: VALUES OF SIGINFO_T STRUCTURE NOT PRINTED IN THE ASSERTION FAILURE FILE |
| IC82329 | MEMORY CORRUPTION CRASH WHEN CREATE INDEX ON FRAGMENTED TABLE IS INTERRUPTED, ABORTED / KILLED |
| IC82354 | CAN DEFINE A REPLICATE ON TABLES WITH DIFFERING PRIMARY KEY DEFINITION |
| IC82449 | INCORRECT RESULTS WHEN NESTED LOOP JOIN USED ON TABLE WITH LOCKED ROW |
| IC82450 | THE REGISTER DUMP FROM THE SIGNAL CONTEXT IN AF FILES ON LINUX POWER PC ARE INCORRECT |
| IC82483 | FAILURE TO AUTHENTICATE DOMAIN USERS CRASHES ENGINE |
| IC82506 | SELECT ON ROWID WITH SUBSELECT MIGHT RETURN WRONG RESULTS WHEN OPTIMIZER USES SKIP SCAN INDEX PATH |
| IC82624 | THE OPTIMIZER DOES NOT CHOOSE A COMPOSITE INDEX EVEN THOUGH THE DATA NEEDS TO BE ORDERED LIKE THAT INDEX IN 11.70.FC4 |
| IC82743 | ASSERTION FAILURE POSSIBLE IN ADD_TO_FREELIST() WHEN QSTATS IS ACTIVATED AND ONSTAT -Z IS RUN |
| IC82757 | IFXDEPLOYASSIST HANGS ON THE INSTANCE FEATURES WINDOW - STATUS SHOWS LOADING AND FEATURES DIALOG IS NOT POPULATED |
| IC82955 | CRASH OF PRIMARY SERVER IN RSS_SEND_ THREAD JUST AFTER BOUNCING RSS SERVER |
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.7","Edition":"Developer;Express;Ultimate;Growth","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27025145