Re: no support for SELECT ... WHERE EXISTS

[Tobias Downer <toby@xxxxxxxxx>]

The EXISTS correlated sub-query clause isn't supported in Mckoi yet. 
It will be supported in the next release.

Thanks for the report,
Toby.

Waldo auf der Springe wrote:
> I tried to run the JDO JRELAY query samples (simple2) with mckoi and got the 
> following output:
> [waldo@microstar jrelay_2_0_2]$ ant run
> Buildfile: build.xml
> 
> run:
>      [java] Book Storie, isbn: xyz-0
>      [java] Article Piano Transport
>      [java] Book Pensieros, isbn: xyz-1
>      [java] Article Optik
>      [java] Book Bagombo Snuff Box, isbn: xyz-2
>      [java] SELECT failed: SELECT T0.CLASS_ID, T0.ID, T0.VERSION, 
> T0.FIRSTNAME, T0.LASTNAME, T0.LOCALE FROM AUTHOR T0  WHERE EXISTS ( SELECT 
> DOCUMENT FROM DOCUMENT_AUTHOR_REL, DOCUMENT V0 WHERE DOCUMENT = V0.ID AND 
> AUTHOR = T0.ID AND V0.TITLE LIKE 'Bag%')
>      [java] com.mckoi.database.jdbc.MSQLException: Encountered "EXISTS" at 
> line 1, column 99.