INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70

Query with a certain set of subqueries in the where clause, some
of them
are also nested can  cause an -874 error in the optimizer with
the following stack

0x0000000100093ef0 (oninit)affail_interface
0x00000001000971c0 (oninit)mt_ex_throw_sig@AF11_4
0x000000010005d858 (oninit)afsig_handler
0x00000001010d2970 (oninit)opchop
0x0700000040762750 (*nosymtab*)0x700000040762750
0x00000001010d9d94 (oninit)op_join
0x00000001010daccc (oninit)op_phasejoin
0x000000010044a328 (oninit)sqoptim
0x00000001001f01f0 (oninit)IPRA.$bldstructs
0x00000001001ebb94 (oninit)IPRA.$sqcmd
0x00000001001ef058 (oninit)sq_cmnd
0x00000001001ef650 (oninit)sq_prepare
0x0000000100509500 (oninit)sqmain
0x0000000100bfc38c (oninit)listen_verify
0x0000000100bfb428 (oninit)spawn_thread
0x0000000100a09140 (oninit)th_init_initgls
0x00000001014be700 (oninit)startup


SELECT DISTINCT t_r_dsub.c_ds,typ_ds,prijmeni,jmeno,c_fu

FROM t_r_dsub,t_d_akt_ds

WHERE t_r_dsub.c_fu>013 AND typ_ds="F" AND

   t_d_akt_ds.c_ds=t_r_dsub.c_ds

AND EXISTS (SELECT * FROM t_d_zmp_ WHERE t_d_zmp_.c_ds =
t_r_dsub.c_ds)
AND EXISTS(SELECT * FROM t_v_dsdp WHERE c_up IN (010) AND
t_v_dsdp.c_ds=t_r_dsub.c_ds AND c_drp IN (371) AND
   stav_dsdp="1" AND priznak!="2")

AND NOT EXISTS(SELECT * FROM t_v_dsdp WHERE c_drp IN (775,777)
AND t_v_dsdp.c_ds=t_r_dsub.c_ds AND stav_dsdp="1"
   AND priznak!="2")

AND EXISTS (SELECT * FROM t_l_osdanuc WHERE
   t_l_osdanuc.c_ds = t_r_dsub.c_ds AND du_stav = "1" AND EXISTS
(SELECT *
   FROM t_v_dsdp WHERE t_v_dsdp.c_ds = t_r_dsub.c_ds AND
   t_v_dsdp.c_drp=t_l_osdanuc.c_drp AND c_up IN (010) AND c_drp
IN (371) AND
   stav_dsdp = "1" AND priznak != "2"))

AND t_r_dsub.priz_dic NOT IN ("X","Z","V") AND
t_r_dsub.stav_ds

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS 11.70.xC9 and earlier versions.                 *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Modified backport of defect 500793 in 11.70 addresses the    *
* original problem but doesnt prevent from -874 in             *
* op_join/opchop as in 12.10.                                  *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

17.03.2019
08.10.2019
31.08.2020