Informix - Problem description
Problem IT33874 | Status: Closed |
QUERY USING ROWID AND DOUBLE QUOTES WITH DELIMIDENT SET CRASHES IN EVALCOLS | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Facing several assertions when issuing the following type of query: Running the following query I was able to reproduce the issue: SELECT rowid, "xyz" FROM (SELECT COUNT(*) "xyz" FROM "stores":"informix"."table_a" "table_xyz") abc WHERE "xyz">(0) The stack signature shows: oninit :: evalcols oninit :: getrow oninit :: fetchrow oninit :: exfetch oninit :: sql_nfetch oninit :: sq_nfetch 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.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * Facing several assertions when issuing the following type of * * query: * * * * Running the following query reproduces the issue: * * * * SELECT rowid, "xyz" FROM (SELECT COUNT(*) "xyz" FROM * * "stores":"informix"."table_a" "table_xyz") abc WHERE * * "xyz">(0) * * * * The stack signature shows: * * oninit :: evalcols * * oninit :: getrow * * oninit :: fetchrow * * oninit :: exfetch * * oninit :: sql_nfetch * * oninit :: sq_nfetch * * oninit :: sqmain * * oninit :: listen_verify * * oninit :: spawn_thread * * oninit :: th_init_initgls * * 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: * * Facing several assertions when issuing the following type of * * query: * * * * Running the following query reproduces the issue: * * * * SELECT rowid, "xyz" FROM (SELECT COUNT(*) "xyz" FROM * * "stores":"informix"."table_a" "table_xyz") abc WHERE * * "xyz">(0) * * * * The stack signature shows: * * oninit :: evalcols * * oninit :: getrow * * oninit :: fetchrow * * oninit :: exfetch * * oninit :: sql_nfetch * * oninit :: sq_nfetch * * oninit :: sqmain * * oninit :: listen_verify * * oninit :: spawn_thread * * oninit :: th_init_initgls * * 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 : | 11.08.2020 25.01.2021 25.01.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |