On Dec 11, 2009, at 3:32 AM, Andrey Razumovsky wrote:
OK, may I suggest we just slightly change the test, so that it works
on
Derby as well. Current problem is that Derby does not allow more
than one
column in subquery result.
So if wwe replace
"SELECT a FROM Artist a WHERE EXISTS (SELECT DISTINCT p1 ...) "
with
"SELECT a FROM Artist a WHERE EXISTS (SELECT DISTINCT
p1.paintingTitle ...)
"
it will work with same sense
Then how do we know that the other syntax variant is broken?
We clearly need an exclude list per DB...
Andrus
