APAR status
Closed as fixed if next.
Error description
server can crash in lddblnull() if a sub-query references, in an aggregate, a column from the main query instead of the same column from the same table but defined in the FROM clause of the subquery. 0x0000000001315863 (oninit) afstack 0x000000000131c658 (oninit) mt_ex_throw_sig 0x00000000012bf983 (oninit) afsig_handler 0x000000386fe0dd40 (Linux) <signal frame> 0x000000000146bd2c (oninit) lddblnull 0x0000000001271760 (oninit) rdatavalFloat 0x00000000009cbe78 (oninit) valload 0x000000000081c15e (oninit) geval 0x00000000007af645 (oninit) evalcols 0x00000000007b0930 (oninit) getrow 0x00000000007b0f39 (oninit) fetchrow 0x00000000007b153f (oninit) doselect 0x0000000000825c7f (oninit) exsubq 0x00000000014eec0f (oninit) ev_cb 0x00000000014ee1ae (oninit) new_eval 0x0000000000ae691f (oninit) next_row 0x0000000000ae6e41 (oninit) get_first_row_from_producer 0x0000000000ae94e6 (oninit) hash_process_all_groups 0x0000000000aeae86 (oninit) group_open 0x00000000007ad7bd (oninit) prepselect 0x00000000009b03ee (oninit) open_cursor 0x00000000009b4e4f (oninit) sql_open 0x00000000009b5016 (oninit) sq_open 0x0000000000a73cba (oninit) sqmain 0x00000000013eb9f3 (oninit) spawn_thread 0x00000000012df094 (oninit) startup The following select works fine select c.fname, o.order_num, ( select count (items.order_num) from items where o.order_num=items.order_num) as toto, max (o.order_date) from customer c join orders o on c.customer_num=o.customer_num join items i on i.order_num=o.order_num group by 1, 2, 3 The following crashes the engine: select c.fname, o.order_num, ( select count (i.order_num) from items where o.order_num=items.order_num) as toto, max (o.order_date) from customer c join orders o on c.customer_num=o.customer_num join items i on i.order_num=o.order_num group by 1, 2, 3 The difference is: select count (items.order_num) from items >>> does not crash select count (i.order_num) from items >>> crashes
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * When correlated aggregates occur in subqueries within the * * projection clause of parent query * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.70.xC9 or earlier PID if available. * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IC97019
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B70
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2013-10-18
Closed date
2017-06-09
Last modified date
2017-06-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
RB70 PSN
UP
RB70 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
09 June 2017