Informix - Problem description
Problem IT42285 | Status: Closed |
AF GENERATED WHEN USING GROUP BY FOR SELECT QUERY WITH GENBSON FUNCTION | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
An assert failure is generated when running select query with genbson function using GROUP BY. select genbson(row(customer_num, count (*)))::JSON from orders GROUP BY 1; This select statement can be run against dbaccessdemo. The stack is as follows: 14:37:50 Assert Failed: No Exception Handler 14:37:51 Who: Session(5984, informix@server, 0, 1138eca28) Thread(6063, sqlexec, 1138c5f28, 1) File: mtex.c Line: 569 14:37:51 Results: Exception Caught. Type: MT_EX_OS, Context: mem 14:37:51 Action: Please notify IBM Informix Technical Support. 14:37:51 See Also: /home/informix/af.1b97581c 14:37:50 Stack for thread: 6063 sqlexec oninit :: lddblnull oninit :: rdatavalFloat oninit :: ev_column oninit :: new_eval oninit :: next_row oninit :: get_first_row_from_producer oninit :: hash_process_all_groups oninit :: group_open oninit :: prepselect oninit :: open_cursor oninit :: sql_open oninit :: sq_open oninit :: sqmain oninit :: listen_verify oninit :: spawn_thread oninit :: th_init_initgls oninit :: startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC10 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 or 14.10.xC10. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC10 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 or 14.10.xC10. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC10. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.10.2022 23.02.2023 17.05.2023 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |