[ http://issues.apache.org/jira/browse/JDO-267?page=comments#action_12361329 ]
Craig Russell commented on JDO-267: ----------------------------------- Sorry, I should have included the full stack trace and identified the test case. I decided to open a new JIRA for this issue because the JIRA that had been tracking this test case had changed so many times the original description was no longer descriptive. Anyway thanks for the comment. > 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
