|
Problem IT44087
|
Status: Closed |
ROWS RETURNED BY A QUERY WITH MULTISET AND A CONNECT BY - STOPS SOMETIMES CAN ASSERT AND SHOWS AN ERROR
|
| product: |
INFORMIX SERVER / 5725A3900 / E10 - |
| Problem description: |
Query having Multiset and Connect By when executed, hangs in the
middle may assert and shows an error
9791: User Defined Routine (collectionoutput) execution failed.
The issue can be seen if the query is executed multiple times in
dbaccess.
The problem can be seen even when running the query from a file.
Adding an ORDER BY to the query, the error does not occur and
all the rows can be traversed without problems. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC11. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC11. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC11. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC11. *
**************************************************************** |
| Comment |
Fixed in Informix Server 14.10.xC11. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.07.2023
02.06.2024
02.06.2024 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
