The problem is still there...
Now i'm anxious to see the first answer of the SAPDB-people.
...thank You for your answer. I tried your suggestion to use ANSI syntax and used your syntax exactly as proposed. Unfortunately, the result set is identical to the one with the Oracle syntax and wrong. The problem is somewhere deeper in SapDB.BTW: what version of SAPDB do you use?
SAP: The following SQL statement produces wrong results:
SELECT a.x, b.y, c.z FROM a LEFT JOIN b ON a.x=b.x LEFT JOIN c ON a.r=c.x WHERE c.z=1799 AND EXISTS (SELECT * FROM p JOIN u ON p.s=u.x WHERE p.x=a.x AND u.t='text') This should work fine.Nope.
7.3 or 7.4beta?
I think SAP rewrote some parts of SAPDB 7.4.
So 7.4 could fix your bug, or the bug could be new to 7.4.
Plz try with both 7.3.0.30 and 7.4.3.7 and supply us with the results.
I can also test for you, but you should send me some create-table- and insert-statements so i have some data to test on.
Thx
Sven
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
