Informix - Problem description
Problem IT34172 | Status: Closed |
SELECT STATEMENT USING A SUBQUERY WILL FAIL WITH 528 ERROR | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
A select statement using a sub-query referring the same table will fail with error 528, even though the values displayed are small. the following statement: SELECT DISTINCT CRITERIA_0.order_no, CRITERIA_0.order_id FROM tab2, tab1 CRITERIA_0 WHERE CRITERIA_0.order_id = tab2.order_id AND EXISTS (SELECT DISTINCT CRITERIA_1.order_id FROM tab2, tab1 CRITERIA_1 WHERE CRITERIA_1.order_id = tab2.order_id AND CRITERIA_0.order_id = CRITERIA_1.order_id will fail with error 528 if the size of both tables is bigger that 32k. This is at the very least misleading as 528 means: -528 Maximum output rowsize max-size exceeded. One table is using an Lvarchar(32000), which is only part of the table, not of the criteria of the query. Making this just a bit smaller will avoid the issue. The stack for onmode -I shows: base: 0x00000000481e9000 len: 69632 pc: 0x00000000014a458d tos: 0x00000000481f72f0 state: running vp: 1 0x00000000014a458d (oninit) afstack 0x00000000014a962d (oninit) afhandler 0x00000000014a9c42 (oninit) affail_interface 0x0000000000ed9a00 (oninit) check_traperror 0x0000000000762a41 (oninit) sqerr 0x000000000096cf11 (oninit) create_rdupsinfo 0x000000000097409f (oninit) opdojoin 0x000000000097492b (oninit) chk_dir_oj 0x00000000009768ef (oninit) opjoin 0x0000000000977da1 (oninit) op_join 0x000000000097b6cd (oninit) op_phasejoin 0x00000000008401e0 (oninit) sqoptim 0x0000000000a9a6ae (oninit) bldstructs 0x0000000000aa79e1 (oninit) sqcmd 0x0000000000aa7f3d (oninit) sq_prepare 0x0000000000b8eeae (oninit) sqmain 0x00000000015d2e3b (oninit) spawn_thread 0x0000000001495103 (oninit) th_init_initgls 0x00000000014dc0bf (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC5. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC5. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC5. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.09.2020 09.12.2020 09.12.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |