|
Problem IT27584
|
Status: Closed |
SET EXPLAIN ON FAILS WITH -874 IN HAS_RTCONSTOP()
|
| product: |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 |
| Problem description: |
A
SET EXPLAIN ON;
delete from tpmt_aud where row(pmt_id, aud_order) in (select
row(pmt_id,
aud_order) from bptmpref)
fails with
874: General exception error has occurred in the optimizer.
in
(oninit) has_rtconstop
(oninit) has_rtconstop
(oninit) has_rtconstop
(oninit) has_rtconstop
(oninit) opexplain
(oninit) sqoptim
(oninit) bldstructs
(oninit) sqcmd |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of IDS versions prior to 11.70.xC9W1. *
****************************************************************
* PROBLEM DESCRIPTION: *
* SET EXPLAIN ON FAILS WITH -874 IN HAS_RTCONSTOP() *
****************************************************************
* RECOMMENDATION: *
* Upgrade to IDS 11.70.xC9W1. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.12.2018
26.10.2019
26.10.2019 |
| Problem solved at the following versions (IBM BugInfos) |
11.70.xC9
|
| Problem solved according to the fixlist(s) of the following version(s) |
