Kbase P129786: SQL: Correlated sub query not returning correct result
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/20/2008 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1B
All Supported Operating Systems
SYMPTOM(s):
SQL: Correlated sub query not returning correct result
The following SELECT statement incorrectly returns an empty result set with no rows. The correct result set contains one row:
CREATE TABLE PUB.Table1 (iTable1Column1 INTEGER, vcTable1Column2 VARCHAR(50));
INSERT INTO PUB.Table1 VALUES (1, 'Table1Column2Value');
CREATE TABLE PUB.Table2 (iTable2Column1 INTEGER, vcTable2Column2 VARCHAR(50));
INSERT INTO PUB.Table2 (iTable2Column1) VALUES (1);
SELECT iTable1Column1, vcTable1Column2
FROM PUB.Table1
WHERE NOT EXISTS (SELECT * FROM PUB.Table2 WHERE PUB.Table2.vcTable2Column2 = PUB.Table1.vcTable1Column2)
CAUSE:
Bug# OE00166428
FIX:
Upgrade to OpenEdge 10.1C01 or later