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
Assigned to: 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
