db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andy Jefferson (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (JDO-267) Query with alias result generates incorrect SQL
Date Wed, 28 Dec 2005 11:54:04 GMT
     [ http://issues.apache.org/jira/browse/JDO-267?page=all ]
     
Andy Jefferson resolved JDO-267:
--------------------------------

    Resolution: Fixed

Presuming you're talking about SingleString test.
Now fixed in JPOX CVS - build dated 29/12/2005 or later.

> Query with alias result generates incorrect SQL
> -----------------------------------------------
>
>          Key: JDO-267
>          URL: http://issues.apache.org/jira/browse/JDO-267
>      Project: JDO
>         Type: Bug
>   Components: tck20
>     Reporter: Craig Russell
>     Assignee: Andy Jefferson

>
> This JDOQL query results in the wrong SQL:
>         /*UNIQUE*/      Boolean.FALSE,
>         /*RESULT*/      "firstname AS firstName, lastname AS lastName",
>         /*INTO*/        FullName.class, 
>         /*FROM*/        FullTimeEmployee.class,
>         /*EXCLUDE*/     Boolean.TRUE,
>         /*WHERE*/       "salary > 1000 & projects.contains(p) & " +
>                         "p.budget > limit",
>         /*VARIABLES*/   "Project p",
>         /*PARAMETERS*/  "BigDecimal limit",
>         /*IMPORTS*/     "import org.apache.jdo.tck.pc.company.Project; " +
>                         "import java.math.BigDecimal",
>         /*GROUP BY*/    "firstname, lastname HAVING lastname.startsWith('emp')",
>         /*ORDER BY*/    "lastname ASCENDING",
>         /*FROM*/        0,
>         /*TO*/          3)
> 001 error:  javax.jdo.JDODataStoreException: Error executing JDOQL query "SELECT DISTINCT
THIS.FIRSTNAME AS firstName,THIS.LASTNAME AS lastName,THIS.LASTNAME FROM datastoreidentity0.PERSONS
THIS INNER JOIN datastoreidentity0.PROJECT_MEMBER THIS_PROJECTS ON THIS_PROJECTS."MEMBER"
= THIS.DATASTORE_IDENTITY INNER JOIN datastoreidentity0.PROJECTS UNBOUND_P ON UNBOUND_P.DATASTORE_IDENTITY
= THIS_PROJECTS.PROJID LEFT OUTER JOIN datastoreidentity0.PROJECTS UNBOUND_P_BUDGET ON UNBOUND_P.DATASTORE_IDENTITY
= UNBOUND_P_BUDGET.DATASTORE_IDENTITY WHERE THIS.DISCRIMINATOR = ? AND THIS.SALARY > 1000
AND UNBOUND_P_BUDGET.BUDGET > .2E4 GROUP BY THIS.FIRSTNAME,THIS.LASTNAME HAVING LOCATE(?,THIS.LASTNAME)
= 1 ORDER BY THIS.LASTNAME" : Column name 'LASTNAME' appears more than once in the result
of the query expression.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message