home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)