Re: [JIRA] Created: (CAY-908) Sybase EJBQL Subquery syntax

[Craig L Russell]

Don't you love how far we've come in the last 20 years of SQL implementations.

Incorrect syntax near ",".

Sheesh.

Craig

On Oct 28, 2007, at 7:49 AM, Andrus Adamchik (JIRA) wrote:

Oct 28, 2007 4:37:53 PM org.apache.cayenne.access.QueryLogger logQuery

INFO: *** error.
com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near ','.

INFO: SELECT DISTINCT t0.PAINTING_TITLE AS PAINTING_TITLE, t0.ARTIST_ID AS ARTIST_ID, t0.PAINTING_DESCRIPTION AS PAINTING_DESCRIPTION, t0.ESTIMATED_PRICE AS ESTIMATED_PRICE, t0.GALLERY_ID AS GALLERY_ID, t0.PAINTING_ID AS PAINTING_ID FROM PAINTING t0 WHERE EXISTS (SELECT DISTINCT t1.PAINTING_TITLE, t1.ARTIST_ID, t1.PAINTING_DESCRIPTION, t1.ESTIMATED_PRICE, t1.GALLERY_ID, t1.PAINTING_ID FROM PAINTING t1 WHERE t1.PAINTING_TITLE = t0.PAINTING_TITLE AND t0.ESTIMATED_PRICE <> t1.ESTIMATED_PRICE) Oct 28, 2007 4:37:53 PM org.apache.cayenne.access.QueryLogger logQueryError

Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:[EMAIL PROTECTED]
P.S. A good JDO? O, Gasp!

smime.p7s
Description: S/MIME cryptographic signature