[ 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