You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-dev@db.apache.org by "Andy Jefferson (JIRA)" <ji...@apache.org> on 2005/12/28 09:06:02 UTC
[jira] Commented: (JDO-267) Query with alias result generates incorrect SQL
[ http://issues.apache.org/jira/browse/JDO-267?page=comments#action_12361314 ]
Andy Jefferson commented on JDO-267:
------------------------------------
Any clue as to which TCK test this refers to ? The test class name would be nice.
> 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