Informix - Problem description
Problem IT30993 | Status: Closed |
QUERY CAN CAUSE SEGV ASSERT IN FIXCOLEXPRS DURING OPTIMIZATION | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Failure stack: 0x00000000013d42d7 (oninit) afstack 0x00000000013d746e (oninit) afhandler 0x00000000013d78e2 (oninit) affail_interface 0x00000000013d7e71 (oninit) mt_ex_throw_sig 0x00000000013f5c83 (oninit) afsig_handler 0x0000003ddfa0e4c0 (Linux) 0x000000000078d67c (oninit) fixcolexprs 0x000000000078d907 (oninit) fixcolexprs 0x000000000078d840 (oninit) fixcolexprs 0x00000000007986e6 (oninit) opchkby 0x00000000007cc550 (oninit) sqoptim 0x00000000009f734c (oninit) bldstructs 0x00000000009fbce0 (oninit) sqcmd 0x0000000000a06512 (oninit) sq_cmnd 0x0000000000a06664 (oninit) sq_prepare 0x0000000000ad57b3 (oninit) sqmain 0x00000000014fc70c (oninit) spawn_thread 0x00000000013c61d0 (oninit) th_init_initgls 0x000000000142d228 (oninit) startup Running this query: select t1.tag, t1.label_type_code, t1.actual_slot_id, t1.item_nbr, t1,item1_desc, t1.curr_unit_qty, t1.pallet_ti_qty, t1.pallet_hi_qty, t1.actl_qty from (select ru.rcv_unit_tag_id as tag, ru.label_type_code, ru.actual_slot_id, ru.item_nbr, it.item1_desc, ru.curr_unit_qty, ru.pallet_ti_qty, ru.pallet_hi_qty, sum(su.ship_unit_qty) as actl_qty from db1:tab1 ru left join db2:tab2 su on ru.rcv_unit_id = su.rcv_unit_id inner join db3:tab3 it on ru.item_nbr = it.item_nbr where ru.actual_slot_id in ('132','133','134','135','136','137','138','139','140','141','14 2','143','144', '145','146','147','148','149','150','151','152','153','154','155 ','156','157', '158','159','160','161','162','163','164','165','166') and su.cur_loc_slot_id in ('132','133','134','135','136','137','138','139','140','141','14 2','143','144', '145','146','147','148','149','150','151','152','153','154','155 ','156','157', '158','159','160','161','162','163','164','165','166') group by 1,2,3,4,5,6,7,8) t1 where t1.actl_qty > 0; | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC4. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC4. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC14 and 14.10.xC4. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.11.2019 27.02.2020 27.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14, 14.10.xC4 | |
Problem solved according to the fixlist(s) of the following version(s) |