Informix - Problem description
Problem IT33928 | Status: Closed |
INSERT INTO EXTERNAL TABLE SELECT FROM DERIVED TABLE WITH ORDER BY CAN ASSERT IN EVALCOLS FROM XUC_NEXT | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
It's possible to assert with the stack below while inserting into an external table selected data from a derived table with an order by. 0x00000000013e7bf9 (oninit) afstack 0x00000000013eb621 (oninit) mt_ex_throw_sig 0x00000000013fc313 (oninit) afsig_handler 0x0000003ddfa0e4c0 (Linux) 0x0000003ddee79ea0 (/lib64/libc-2.5.so) __GI_memmove 0x00000000007f81ba (oninit) evalcols 0x00000000008409d1 (oninit) xuc_next 0x0000000000842908 (oninit) xuw_next 0x0000000000892067 (oninit) doinsert 0x00000000005d1048 (oninit) excommand 0x0000000000a1998c (oninit) sq_execute 0x0000000000adcc43 (oninit) sqmain 0x00000000015132d6 (oninit) spawn_thread 0x00000000013d9890 (oninit) th_init_initgls 0x00000000014423e8 (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * It's possible to assert with the stack below while inserting * * into an external table selected data from a derived table * * with an order by. * * * * 0x00000000013e7bf9 (oninit) afstack * * 0x00000000013eb621 (oninit) mt_ex_throw_sig * * 0x00000000013fc313 (oninit) afsig_handler * * 0x0000003ddfa0e4c0 (Linux) * * 0x0000003ddee79ea0 (/lib64/libc-2.5.so) __GI_memmove * * 0x00000000007f81ba (oninit) evalcols * * 0x00000000008409d1 (oninit) xuc_next * * 0x0000000000842908 (oninit) xuw_next * * 0x0000000000892067 (oninit) doinsert * * 0x00000000005d1048 (oninit) excommand * * 0x0000000000a1998c (oninit) sq_execute * * 0x0000000000adcc43 (oninit) sqmain * * 0x00000000015132d6 (oninit) spawn_thread * * 0x00000000013d9890 (oninit) th_init_initgls * * 0x00000000014423e8 (oninit) startup * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * It's possible to assert with the stack below while inserting * * into an external table selected data from a derived table * * with an order by. * * * * 0x00000000013e7bf9 (oninit) afstack * * 0x00000000013eb621 (oninit) mt_ex_throw_sig * * 0x00000000013fc313 (oninit) afsig_handler * * 0x0000003ddfa0e4c0 (Linux) * * 0x0000003ddee79ea0 (/lib64/libc-2.5.so) __GI_memmove * * 0x00000000007f81ba (oninit) evalcols * * 0x00000000008409d1 (oninit) xuc_next * * 0x0000000000842908 (oninit) xuw_next * * 0x0000000000892067 (oninit) doinsert * * 0x00000000005d1048 (oninit) excommand * * 0x0000000000a1998c (oninit) sq_execute * * 0x0000000000adcc43 (oninit) sqmain * * 0x00000000015132d6 (oninit) spawn_thread * * 0x00000000013d9890 (oninit) th_init_initgls * * 0x00000000014423e8 (oninit) startup * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC5. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.08.2020 04.02.2021 04.02.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |