=========================================== ADDENDUM TO RELEASE NOTES FOR INFORMIX DYNAMIC SERVER 7.30.UC8 PRODUCT RELEASE DATE: 11 Mar 1999 =========================================== TABLE OF CONTENTS I. BUGS FIXED IN THE 7.30.UC2 RELEASE II. BUGS FIXED IN THE 7.30.UC3 RELEASE III. BUGS FIXED IN THE 7.30.UC5 RELEASE IV. BUGS FIXED IN THE 7.30.UC6 RELEASE V. BUGS FIXED IN THE 7.30.UC7 RELEASE II. BUGS FIXED IN THE 7.30.UC3 RELEASE 92803 ACCESSING DICTIONARY FOR SPECIFIC TABLE CRASHES ENGINE IN (READCATS) 91875 UNINITIALIZED VARIABLE IN OPTIMIZER CAN CAUSE CORE DUMP 90906 CRASH/MEM ASSERTION POSSIBLE WHEN INTERRUPTING A CLIENT IN THE PROCESS OF CONNECTING. 92594 ERROR -111 FROM DATABASE 91979 SUBQUERY CACHE FEATURE DOESN'T WORK(EFFECTIVELY DISABLED) ON THE 2ND EXECUTION OF A PREPARED QUERY. PERFORMANCE PROBLEM. 92193 INCORRECT QUERY RESULTS FROM CORRELATED SUBQUERY WITH CORRELATED VARCHAR GREATER THAN OR EQUAL TO 128 BYTES IN LENGTH IF SUBQUERY CACHE IS USED. 92434 SIGBUS WHILE RUNNING LEGACY/ONLINE/COL_PSUBQ 91913 UPDATE-SELECT SHOWS SIGNIFICANT PERFORMANCE REDUCTION FOR A PEOPLESOFT QUERY COMPARED TO 7.23 90084 NEW:MA-SS ASSERTION FAILURE AS STORED PROCEDURE CANNOT BE EXECUTED AS USER DID NOT CONNECT THROUGH A PASSWORD 92061 INCORRECT QUERY RESULT ON CORRELATED SUBQUERY WHICH USES SUBQUERY CACHE AND SUBSCRIPTED VARCHARS. 92992 SELECT TEXT COLUMN SUBSCRIPT RETURNS -607 IF SUBSCRIPT UPPER LIMIT IS HIGHER THAN VALUE LENGTH, SHOULD RETURN BLANK PADDED VALUE III. BUGS FIXED IN THE 7.30.UC5 RELEASE 93161 SLOW INDEX PATH CHOSEN BY OPTIMIZER WHERE AUTOINDEX IS FASTER. REGRESSION INTRODUCED BY FIX TO B75345 89682 GETTING ERROR -454('LOC_READ()' FAILED) AND -847(ERROR IN LOAD FILE LINE NUMBER) WHEN LOADING INTO TEXT TYPE COLUMN. 87345 7.22.UC1 - SOLARIS 2.5.1 - IMPLICIT CONNECT AFTER EXPLICIT DISCONNECT GENERATES ERROR 1803. 71732 OPTIMIZER SELECTS A QUERY PATH FOR EXECUTION FROM AVAILABLE CHOICES EVEN WHEN ITS EVALUATED COST IS NEGATIVE I.E., INVALID. 88301 DBSCHEMA FAILED WITH ERROR -100 FOR THE NEWLY CREATED TABLE FROM ALTER FRAGMENT AND ADD A FRAGMENT. 89939 SELECT IN DIRTY READ WITH CONCURRENT DELETE GIVES SPORADIC -243/-111 WITH DETACHED INDEXES 91185 ONLINE EXECUTING REMOTE STORED PROCEDURE GIVES ERROR -403 91286 ENGINE GOES DOWN DUE TO INTERRUPTED SYSTEM CALL ERRNO=4, IN FUNCTION SYSV_NSF_SENDFD 92779 REPEATEDLY TRYING TO OPEN A CURSOR AFTER AN ALTER TABLE CAUSES ENGINE TO SEGV 93107 ONLINE CAN ASSERT FAIL WITH A SEGV IN MARKBLKS WHEN ONLINE USES A VIRTUAL SEGMENT > 2GIG 93232 4GL 7.20.UC1 - A REPORT WITH USING CLAUSES GIVES UNPREDICTABLE RESULTS WHEN USING DATE FIELDS. 93674 CRASH/MEM ASSERTION POSSIBLE WHEN INTERRUPTING A CLIENT IN THE PROCESS OF CONNECTING WITH A BAD USER NAME OR PASSWORD(-952). LOOKS SAME AS B90906 94047 ASSERT FAILURE:'NO EXCEPTION HANDLER' WHEN CREATING STORED PROCEDURE. 94075 CLUSTER INDEX ON A TABLE WITH AN EMPTY BLOBSPACE FIELD RETURNS ERROR -502 94607 -710/-101 ON SECOND OPEN/FETCH OF A CURSOR WITH LIKE OR MATCHES CLAUSE ON ANSI DATABASES 94857 SEGV OR MEMORY CORRUPTION IMMEDIATELY AFTER BACKUP STARTED/COMPLETED MESSAGES ARE PRINTED TO THE ONLINE MESSAGE LOG 95376 SUBQUERY FLATTENING PRODUCING WRONG RESULTS WITH EXISTS CLAUSE 95510 UNABLE TO BACKUP LEVEL 1 OR 2 ARCHIVE WITH A TEMP DBSPACE - ARCHIVE FAILED - NO LEVEL 0 ARCHIVE EXISTS; ONLY LEVEL 0 ARCHIVE IS ALLOWED. 90032 HPLOADER LOADS NULLS INTO MONEY COLUMNS WHEN USING BINARY FIXED FORMAT 91712 HPL LOAD FROM DATAFILE WITH BLOB COLUMN IN BLOBSPACE AND NOT NULL CONSTRAINT CAUSES ASSERT FAILURE, ONLINE ENGINE CRASH. 91858 THE BROWSER UTILITY DOES NOT WORK WITH ANY KIND OF FORMAT, UNLESS YOU VIEW ONLY CHARACTER COLUMNS AND USE DELIMITED FORMAT 93541 TIMING PROBLEM WITH ONPLOAD AND DELUXE MODE LOADS CAN PREVENT CADILOAD FROM ACKNOWLEDGING THE END OF STREAM. PLOAD JOB HANGS FAILING TO COMPLETE 94563 DBCENTURY DOES NOT PERFORM AS EXPECTED USING HIGH PERFORMANCE LOADER 94784 IF KILL SIGHUP/SIGKILL/SIGTERM , ASSERT FAILED:CONDITION FAILED(BAD MEMORY POINTER 0XFFFFFFE8), IN (MT_SHM_FR) 93383 ARITHMETIC EXCEPTION IN USRANDSAMP WITH UPDATE STATISTICS MEDIUM - DISTRIBUTIONS ONLY 93468 ONARCHIVE 'COPY/VSET=X/DESINTAION=Y/REQUEST=N' CHEWS UP CPU AND TAKES VERY LONG TIME TO RETURN COMPLETE MSG. 90123 RAPID INSERTS/DELETES OF THE SAME P.K. ROW CAN CAUSE SEGV IN GROUPER IF ROW CONTAINS BLOBS 94782 PERFORMANCE ENHANCEMENT FOR TABLESPACE BLOBS AND FRAGMENTED TABLES 71014 ONARCHIVE FAILS WHEN ONCATALGR DIES WHEN IT RECEIVES SIGPIP - SIGNAL 13 98238 COMPLEX OR CONDITION MUCH WORSE THAN CORRESPONDING UNION ALL CONSTRUCT 97883 HUGE PERFORMANCE PROBLEM WITH ONCHECK -CI (UPPER CASE) IN 7.30 COMPARED TO 7.2X 96467 SERVER CRASHES DURING KEYFIRST SCAN 92118 ENGINE CRASH OPTIMIZING QUERY WITH WHERE CLAUSE OF: WHERE COL LIKE "%XXX%" ESCAPE '\' IV. BUGS FIXED IN THE 7.30.UC6 RELEASE 87615 CONNECTIONS VIA SYNONYMS TO 5.X AND 7.1X SERVERS ARE 2-3 TIMES SLOWER FROM 7.23 SERVER THAN FROM 7.1X SERVER 89978 FRAGMENTS ARE NOT BEING ELIMINATED FOR CERTAIN EXPRESSIONS INVOLVING DATE COLUMNS. 90729 DBLOAD FAILS WITH SYNTAX ERROR OCCURS ON STATEMENT ABOVE LINE 1 CHARACTER 6 IF THE INPUT FILE NAME IS MORE THAN 18 CHARACTERS LONG. 90844 MIGRATING A ONLINE SYSTEM WITH BLOBSPACES TO 7.23 CAN BREAK THE ARCHIVE WITH BLOB PAGE CHECK ERROR AT RSARCBU.C:3756 90967 CDR GROUPER INCORRECTLY HANDLES UNDO RECORDS FOR PARTITION BLOBS 91291 LATCH DEADLY EMBRACE BETWEEN VP_LOCK AND NOTIFYVP_LOCK INVOLVING ADMVP AND CPUVP 92168 PHYSICAL RESTORE FAILED - THE ARCHIVE BACKUP IS CORRUPTED ENCOUNTERED IF BLOBS CONTAINS -1 FOR PAGE ADDRESS AND 5 FOR FLAGS 92328 RUNNING XTREE FROM COMMAND LINE OR FROM WITHIN ONPERF WILL PRODUCE THE ERROR "CHANGING DATA STRUCTURE FORCES TERMINATION OF XTREE" 92633 CONCURRENT EXECUTION OF STORED PROCEDURES IN A NON-LOGGING DB CAN CAUSE ROLLBACK ASSERTION FAILURES AND CORRUPTION OF SYSPROCPLAN. 93396 7.2X ENGINE UPGRADED TO 7.3X AND THEN DOWNGRADED USING ONMODE -B 7.2 CORRUPTS THE DBSPACE RESERVE PAGE IF MORE THAN 28/56 DBSPACES (2K/4K PAGE) 93625 ASSERT FAILED:INDEX LEFT INCONSISTENT,ROLLBACK ERROR 100 AND LOGICAL LOGGING ERROR IN 'ROLLBACK',PANIC: ATTEMPTING TO BRING SYSTEM DOWN 93745 ONPERF TOOLS MENU SELECT QUERY TREE GIVES WARNING: REPRESENTATION SIZE 4 MUST MATCH SUPERCLASS'S TO OVERRIDE REPORTCALLBACK 93772 DBIMPORT OF LARGE DBEXPORT GIVE 201 SYNTAX ERROR ON PROCEDURE. IF YOU MOVE PROCEDURE TO THE END OF THE FILE IT IMPORTS CORRECTLY. 94656 ENGINE CAN CRASH DURING STARTUP DUE TO INTERRUPTED SYSTEM CALL ERRNO=4 (EINTR) IN FUNCTION SYSV_NSF_OPENSTREAM() 94781 ONPLOAD GIVES "ONPLOAD MUST RUN ON THE HOST (HOSTNAME) THAT CONTAIN THE TARGET DATABASE" IF MACHINE HAS 2 ETHERNET CARDS, THEREFORE 2 ADDRESSES 95052 INCORRECT FILES/DIRECTORIES CAN BE REMOVED IF ONINIT IS RUN WITHOUT INFORMIXDIR BEING SET 95744 DBLOAD FAILS WITH LOC_OPEN() FAILED, NOT OWNER LOADING A TABLE WITH A BLOB COLUMN FROM A FLAT FILE. 95865 HDR - CREATING INDEX ON PRIMARY CAUSES SECONDARY TO GO INTO A BLOCKED CHECKPOINT STATE AND EVENTUALLY PING TIMEOUT 96189 LISTENER THREAD CAN GET CAUGHT RUNNING FOREVER IF POLL THREAD IS BOUND TO THE SAME VP. ENGINE HANGS, NO NEW CONNECTIONS 96218 GROUPER COMPRESSION TIES UP CPUVP 96482 FETCH BUFFER OVERFLOW RESULTS IF NEXT RECORD IS LARGER THAN REMAINING AVAILABLE SPACE IN BUFFER (FETBUFSIZE), POTENTIALLY CAUSING SEGV 96492 SHARED MEMORY CONNECTION IGNORES FETBUFSIZE. SQLIDEBUG SHOWS THAT FETCH BUFFER IS USED AS IF IT WAS ONLY 1 KBYTE NOT THE REPORTED TUPLE BUFFER SIZE 96575 GROUPER FANOUT ABORT OCCURING BECAUSE DDRBLOCK NOT BEING SET CORRECTLY 96741 WHEN USING ER MONITOR FROM NT TO SEE SENDQ ON UNIX SERVER DOING REPLICATION, IT TIMES OUT AND ONSNMP ON UNIX USES 99% OF CPU TIME 96790 CDR - SECONDARY ENGINE CRASHED AFTER A LONG TRANSACTION IS REACHED ON THE PRIMARY. 97546 ALTER FRAGMENT (DETACH), REPORTS 407 ERROR WHEN TABLE IS BEING ACCESSED BY OTHER USERS. 97944 SYSTEM HANG. NEGATIVE SLEEP TIMES SHOWING. OTHER BAD BEHAVIOR POSSIBLE (I.E. CRASHES, CORRUPTION, ETC.) 97949 ERROR -951 ON CONNECT WHEN USING PASSWD EXPIRATION AND TRUSTED MODE ON HP-UX 97963 ONPLOAD ROUNDS LARGE DECIMAL NUMBERS WHEN LOADING 98467 QUICK ATTACH USING ALTER FRAGMENT ATTACH. AFTER ATTACH, STATISTICS ON THE SURVIVING TABLE ARE STILL INTACT BUT STATISTICS FROM CONSUMED TABLE ARE NOT 98908 SIZE OF BLOBS IN OPTICAL MEDIA DIFFERS WITH SIZE IN MAGNETIC MEDIA IF THE SIZE IS BIGGER THAN OPCACHEMAX OR IN HIGH VOLUME INSERTS 99227 ASSERT FAILURE - NO EXCEPTION HANDLER WHEN CREATING A STORED PROCEDURE 99238 RESTORE HANG WHEN TRYING TO GET EMPTY BUFFERS IN RSWRITE_PHR() 99268 TIME-BASED REPLICATION WORKING AS IMMEDIATE CONTINUOUS REPLICATION, AND PRIMARY SERVER ALLOCATING SHARED MEMORY SEGMENTS INDEFINITELY. 100622 -951 ERROR ON CONNECTING TO A DB ON SOLARIS IF PASSWORD AGING IS USED 100936 ISM_COMPRESSION=TRUE DOESN'T CREATE A COMPRESSED ARCHIVE OF THE DATA ON SEQUENT. 100976 CHANGING TRIGGER OR SCOPE ON TRANSACTION CAUSES REPLICATE TO ALSO BECOME TIME-BASED V. BUGS FIXED IN THE 7.30.UC7 RELEASE 84894 MGM ACTIVE/READY QUEUE BECOMES CORRUPT ON BUSY SYSTEM. THIS CAUSES THE ONSTAT -G MGM OUTPUT TO BE GARBAGE BUT COULD ALSO CAUSE SEGV/BUS ERROR. 92360 HPLOAD UNLOAD JOB TO AN UNBUFFERED/BUFFERED LOGGING DATABASE WITH A WHERE CLAUSE THAT SPECIFIES 2 DIGIT YEAR UNLOADS ALL ROWS. 4 DIGIT YEAR WORKS. 97544 USING AN UPDATE CURSOR WHERE THERE IS AN IN-CLAUSE IN THE CURSOR DECLARATION YOU GET ERROR 290. 97885 COMPLEX QUERY WITH CORRELATED SUBQUERY BASED ON A VIEW RESULTS IN WRONG RESULTS -- SYSTEM HUNG OR SEGV -- DEPENDING ON QUERY AND ONLINE VERSION 98235 ENGINE CRASH EXECUTING STORED PROCEDURE HAVING A SELECT AGGREGATE WHEN THE STORE PROCEDURE PLAN WAS SAVED WITH PDQPRIORITY > 1 98437 IT TAKES TOO LONG TO CONNECT FROM ONLINE 5 TO IDS 7.2 WHEN MAKING A LARGE NUMBER OF CONNECTIONS 98884 SIGN EXTENSION OF PARTN->PN_FLAGS CAUSES INDEXES TO NOT BE UPDATED WHEN DELETING ROWS AFTER A LIGHT APPEND OPERATION. 99075 SELECT VARCHAR CONTAINING A DECIMAL VALUE AFTER UPDATE STATISTICS MED/HIGH W/DISTRIBUTIONS RETURNS A -1213 ERROR. 99153 ONSTAT -Z CAN CRASH SERVER IN DOSPINLOCK() 100371 ENGINE CRASHES IN THE MIDDLE OF EXECUTING STORED PROCEDURES - MEMORY CORRUPTION 100725 ONCHECKS RUN ON THE SECONDARY AGAINST A TABLE BEING RAPIDLY MODIFIED IN A HDR PAIR CAN HANG THE SECONDARY, USERS WAITING ON A BUFFER 100836 ADDING A VARCHAR COLUMN VIA ALTER TABLE TO A TABLE CONTAINING MANY VARCHAR COLUMNS ALREADY CAN YIELD MEMORY BLOCK HDR CORRUPTION 101162 CRASH EXECUTING STORED PROCEDURE WHEN REOPTIMIZATION OCCURS 101043 AIX KAIO HAS A FIXED (NON-TUNABLE) ARRAY OF REQUEST THAT CAN NOT jBE RESIZED LEADING TO THE FOLLOWING ERRORS "_AIOWRITE() RETURNING EAGAIN" 102180 SELECT * FROM TAB1 WHERE DATECOL <> '' RETURNS NO ROWS BUT THERE ARE ROWS IN TABLE TAB1. 102824 ROLLBACK/ROLLFORWARD ERRORS DUE TO LOG RECORD CORRUPTION ON DEC ALPHA AND OTHER PLATFORMS WITH UNSAFE BYCOPY'S 103473 7.3 CRASH WITH PAGE CHECK ERROR IN UNDOPGALTER:UNDO_ROWALTER IN A ROLLBACK