|
Problem IT12169
|
Status: Closed |
ASSERT FAILURE AND CRASH IN OPLOOKSUBQ DURING PREPARE OF QUERY USING STATEMENT CACHE WHEN BATCHEDREAD_TABLE IS CHANGED
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
The prepare of a query involving an expression in the projection
list may result in an Assert Failure and crash when the query
has previously been cached in the statement cache and the value
of BATCHEDREAD_TABLE is dynamically changed, for example by
using the onmode command. The thread stack shows:
oninit :: oplooksubq
oninit :: oplooksubq
oninit :: oplooksubq
oninit :: qd_expandviews
oninit :: ssc_link
oninit :: parsecmd
oninit :: sqcmd
oninit :: sq_cmnd
oninit :: sq_prepare
oninit :: sqmain
oninit :: listen_verify
oninit :: spawn_thread
oninit :: th_init_initgls
oninit :: startup
The associated SQL is:
SELECT MAX(effectdate) FROM accumsetting |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* 12.10.XC4 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC5 or onward *
**************************************************************** |
| Local Fix: |
No crash will occur if either the statement cache is not enabled
or the BATCHEDREAD_TABLE parameter value is not changed
dynamically. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.11.2015
28.06.2016
28.06.2016 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC5
|
| Problem solved according to the fixlist(s) of the following version(s) |
