Informix - Problem description
Problem IT39149 | Status: Closed |
SELECT WITH PDQ AND SUBQUERY CAN PRODUCE WRONG RESULTS | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
With PDQ this example query is producing a different result then without using PDQ shows different results export PDQPRIORITY=10 14.10.FC6 $ six dbaccess sysmaster - Database selected. > SELECT /*+ explain */ count(*) FROM systables t50, syscolumns t71 WHERE t50.tabid = t71.tabid AND t71.tabid||';'||t71.colno in (SELECT tabid||';'||min(colno) FROM syscolumns group by tabid);> > > > > (count(*)) 104 1 row(s) retrieved. ================================= export PDQPRIORITY=0 14.10.FC6 $ six dbaccess sysmaster - Database selected. > SELECT /*+ explain */ count(*) FROM systables t50, syscolumns t71 WHERE t50.tabid = t71.tabid AND t71.tabid||';'||t71.colno in (SELECT tabid||';'||min(colno) FROM syscolumns group by tabid);> > > > > (count(*)) 265 1 row(s) retrieved. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC8. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC8. * **************************************************************** See IT40336 for a related problem. | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC8. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC8. * **************************************************************** See IT40336 for a related problem. | |
Comment | |
Fixed in Informix Server 14.10.xC8. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.11.2021 07.04.2022 07.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |