| Latest versions | fixlist |
| 14.10.xC11 |
 |
| 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 IT41114 | Status: Closed |
CRASH ON EV_JNCHAR IN A QUERY WITH OLAP OVER (PARTITION BY) WHENAGGREGATE FUNCTION HAS A SUBQUERY | |
| product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
| Problem description: | |
Stack trace will look like:
01:55:55 Stack for thread: 69 sqlexec
base: 0x0000000047dae000
len: 102400
pc: 0x00000000014cfead
tos: 0x0000000044a19f10
state: running
vp: 1
0x00000000014cfead (oninit) afstack
0x00000000014d2c99 (oninit) mt_ex_throw_sig
0x00000000014d4890 (oninit) afsig_handler
0x00007f711eb7c980 (Linux)
0x00000000016c296e (oninit) ev_jnchar
0x00000000016b8a9f (oninit) new_eval
0x000000000086bd43 (oninit) scan_filter
0x00000000010464a8 (oninit) rsseqscan_read
0x00000000015be1fb (oninit) fmseqscan_read
0x000000000086075f (oninit) gettupl
0x0000000000858047 (oninit) scan_next
0x00000000008735ef (oninit) getrow
0x000000000087335e (oninit) fetchrow
0x0000000000870c98 (oninit) doselect
0x00000000008fd1d5 (oninit) check_subquery_remake
0x00000000008fd581 (oninit) exsubq
0x00000000016c1a05 (oninit) ev_cb
0x00000000016b8a9f (oninit) new_eval
0x00000000008eb205 (oninit) olap_next_row.part.17
0x00000000008e3cc2 (oninit) olap_pbyoby_next
0x00000000008735ef (oninit) getrow
0x000000000087335e (oninit) fetchrow
0x0000000000608084 (oninit) exfetch
0x0000000000ab5c4d (oninit) sql_nfetch
0x0000000000ab5524 (oninit) sq_nfetch
0x0000000000b93e2e (oninit) sqmain
0x0000000001603a79 (oninit) spawn_thread
0x00000000014bcfb3 (oninit) th_init_initgls
0x00000000015054cf (oninit) startup
Query:
SELECT a.col1, a.col2, a.col3,
SUM (CASE WHEN c.col4 = (SELECT b.col4 FROM table_b b
WHERE c.col4 = b.col4) THEN c.col5 ELSE 0 END)
OVER (PARTITION BY a.col1, a.col2, a.col3) result_value
FROM table_a a
JOIN table_c c ON c.col1 = a.col1 AND
c.col2 = a.col2 AND
c.col3 = a.col3
GROUP BY 1,2,3,c.col4,c.col5 | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC9. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC9. * **************************************************************** | |
| Local Fix: | |
| Solution | |
| Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC9. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC9. * **************************************************************** | |
| Comment | |
Fixed in Informix Server 14.10.xC9. | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.06.2022 30.09.2022 30.09.2022 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |