Fix list for Informix Server 11.70.xC5, PID 11.70.xC5W1
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.
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 |