Query with alias result generates incorrect SQL

• Key: JDO-267
• Type: Bug
• Status: Resolved
• Resolution: Fixed
• Priority: Major
• Assignee: Andy Jefferson
• Reporter: Craig Russell
• Component/s: tck2

Description

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.