| Latest versions | fixlist |
| 14.10.xC10 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
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) | |
