Informix - Problem description
Problem IT27574 | Status: Closed |
VARIOUS ASSERTION FAILURES FOR QUERY WITH WHERE IN-CLAUSE | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
Typically, the test case will report a stack like: (oninit) afstack (oninit) afhandler (oninit) affail_interface (oninit) mt_ex_throw_sig (oninit) afsig_handler (Linux) (oninit) cnttabs (oninit) opcntab (oninit) opchkor (oninit) opchkor (oninit) makefll (oninit) makefll (oninit) makefll (oninit) opinit (oninit) op_opinit (oninit) sqoptim (oninit) sqbind (oninit) sq_common_bind (oninit) sq_bind (oninit) sqmain (oninit) listen_verify (oninit) spawn_thread (informix1210FC6/bin/oninit)afstack (informix1210FC6/bin/oninit)mt_ex_throw_sig (informix1210FC6/bin/oninit)afsig_handler (informix1210FC6/bin/oninit)zlib/zutil.c (informix1210FC6/bin/oninit)exufunc (informix1210FC6/bin/oninit)geval (informix1210FC6/bin/oninit)ev_geval (informix1210FC6/bin/oninit)new_eval (informix1210FC6/bin/oninit)gettupl (informix1210FC6/bin/oninit)scan_next (informix1210FC6/bin/oninit)join_next (informix1210FC6/bin/oninit)join_next (informix1210FC6/bin/oninit)join_next (informix1210FC6/bin/oninit)sort_open (informix1210FC6/bin/oninit)prepselect (informix1210FC6/bin/oninit)open_cursor (informix1210FC6/bin/oninit)sql_open (informix1210FC6/bin/oninit)sq_open (informix1210FC6/bin/oninit)sqmain (informix1210FC6/bin/oninit)listen_verify (informix1210FC6/bin/oninit)spawn_thread (informix1210FC6/bin/oninit)th_init_initgls (informix1210FC6/bin/oninit)startup (informix1210FC6/bin/oninit)coroutine_start (informix1210FC6/bin/oninit)afstack (informix1210FC6/bin/oninit)afhandler (informix1210FC6/bin/oninit)affail_interface (informix1210FC6/bin/oninit)mt_ex_throw_sig (informix1210FC6/bin/oninit)afsig_handler (informix1210FC6/bin/oninit)keyfirst_expr (informix1210FC6/bin/oninit)keyfirst_expr (informix1210FC6/bin/oninit)keyfirst_expr (informix1210FC6/bin/oninit)keyfirst_expr (informix1210FC6/bin/oninit)keyfirst_expr (informix1210FC6/bin/oninit)keyfirst_sel (informix1210FC6/bin/oninit)orindexp (informix1210FC6/bin/oninit)orindexp (informix1210FC6/bin/oninit)oporindex (informix1210FC6/bin/oninit)opidxp (informix1210FC6/bin/oninit)opscanp (informix1210FC6/bin/oninit)op_opinit (informix1210FC6/bin/oninit)sqoptim (informix1210FC6/bin/oninit)sqbind (informix1210FC6/bin/oninit)sq_common_bind (informix1210FC6/bin/oninit)sq_bind (informix1210FC6/bin/oninit)sqmain (informix1210FC6/bin/oninit)listen_verify (informix1210FC6/bin/oninit)spawn_thread (informix1210FC6/bin/oninit)th_init_initgls (informix1210FC6/bin/oninit)startup (informix1210FC6/bin/oninit)coroutine_start (informix1210FC6/bin/oninit)afstack (informix1210FC6/bin/oninit)afhandler (informix1210FC6/bin/oninit)affail_interface (informix1210FC6/bin/oninit)mt_ex_throw_sig (informix1210FC6/bin/oninit)afsig_handler (informix1210FC6/bin/oninit)opeqrestoredges (informix1210FC6/bin/oninit)opeq_adjustsel (informix1210FC6/bin/oninit)opjinit (informix1210FC6/bin/oninit)opdojoin (informix1210FC6/bin/oninit)chk_dir_oj (informix1210FC6/bin/oninit)op_per_ijs (informix1210FC6/bin/oninit)opjoin (informix1210FC6/bin/oninit)op_join (informix1210FC6/bin/oninit)op_phasejoin (informix1210FC6/bin/oninit)sqoptim (informix1210FC6/bin/oninit)bldstructs (informix1210FC6/bin/oninit)sqcmd (informix1210FC6/bin/oninit)sq_cmnd (informix1210FC6/bin/oninit)sq_prepare (informix1210FC6/bin/oninit)sqmain (informix1210FC6/bin/oninit)listen_verify (informix1210FC6/bin/oninit)spawn_thread (informix1210FC6/bin/oninit)th_init_initgls (informix1210FC6/bin/oninit)startup (informix1210FC6/bin/oninit)coroutine_start | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS 11.50.xC8 and 11.70.xC9 and previous verisons. * **************************************************************** * PROBLEM DESCRIPTION: * * Various assertion failures for query with WHERE IN clause. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.12.2018 08.10.2019 08.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |