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

From: Craig L Russell (Craig.Russel..un.COM)
Date: Sun Oct 28 2007 - 13:48:04 EDT

Next message: Andrus Adamchik: "AppFramework licensing discussion"

Previous message: Kevin Menard: "Re: 3.0M2 testing progress"
In reply to: Andrus Adamchik (JIRA): "[JIRA] Created: (CAY-908) Sybase EJBQL Subquery syntax"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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: 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
> INFO: *** error.
> com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near ','.

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

application/pkcs7-signature attachment: smime.p7s

Next message: Andrus Adamchik: "AppFramework licensing discussion"
Previous message: Kevin Menard: "Re: 3.0M2 testing progress"
In reply to: Andrus Adamchik (JIRA): "[JIRA] Created: (CAY-908) Sybase EJBQL Subquery syntax"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Sun Oct 28 2007 - 13:48:48 EDT