Informix - Problem description
Problem IT28962 | Status: Closed |
ENGINE CRASH IN MBLTRIM WHEN FILTER ON SUBQUERY OF DIFFERENT TYPE USING TRIM, SHOULD RETURN -880 | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Engine will crash with following stack: 14:20:09 Stack for thread: 356 sqlexec base: 0x00000000488bf000 len: 167936 pc: 0x000000000141f989 tos: 0x00000000471410b0 state: running vp: 8 0x000000000141f989 (oninit) afstack 0x0000000001423471 (oninit) mt_ex_throw_sig 0x000000000142e343 (oninit) afsig_handler 0x00007f7940efc680 (Linux) 0x000000000060a3a9 (oninit) mbltrim 0x000000000089a7cf (oninit) geval 0x0000000001657041 (oninit) ev_geval 0x000000000165749e (oninit) new_eval 0x00000000008097f2 (oninit) scan_filter 0x0000000000f641de (oninit) rsseqscan_read 0x00000000014ffcc0 (oninit) fmseqscan_read 0x000000000080cb5e (oninit) readseq_batch 0x000000000081b4fa (oninit) gettupl 0x000000000081edf4 (oninit) scan_next 0x0000000000b7fbb9 (oninit) next_row 0x0000000000b80561 (oninit) get_first_row_from_producer 0x0000000000b849f0 (oninit) group_open 0x0000000000822b79 (oninit) prepselect 0x000000000089f999 (oninit) subqprep 0x00000000008a3b8d (oninit) exsubq 0x0000000001657fcf (oninit) ev_cb 0x000000000165749e (oninit) new_eval 0x0000000000824669 (oninit) evalcols 0x0000000000825e00 (oninit) getrow 0x0000000000826408 (oninit) fetchrow 0x00000000005f87c8 (oninit) exfetch 0x0000000000a416cc (oninit) sql_nfetch 0x0000000000a41cbb (oninit) sq_nfetch 0x0000000000b0b011 (oninit) sqmain 0x000000000154ca1b (oninit) spawn_thread 0x0000000001411450 (oninit) th_init_initgls 0x0000000001456d88 (oninit) startup on a query like: SELECT a.col1, a.col5, a.col4, a.col2, a.col6 , a.col3, a.col7, 0 as I_ARBOL, (Select count(b.col1 ) from table_a as b where trim(b.col2) = trim(a.col1)) as childs , a.col8 FROM table_a as a WHERE a.col1 = 04071400000000 and a.col8 = 1 and a.col7 = 'MC' ORDER BY a.col1 If correct type is used in filter i.e. '04071400000000' query returns correct, but it should not crash engine if badly constructed and should return -880. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * Engine crash in mbltrim when filter on subquery of different * * type using trim; should return -880. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Use correct data type in filter. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.04.2019 24.09.2019 24.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC13 | |
Problem solved according to the fixlist(s) of the following version(s) |