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
This archive was generated by hypermail 2.0.0 : Fri Dec 11 2009 - 07:48:15 EST