[ https://issues.apache.org/jira/browse/METAMODEL-78?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ryan Berdeen updated METAMODEL-78: ---------------------------------- Description: Running {{SELECT DISTINCT name FROM table}} on a PojoDataContext returns duplicate names. Adding {{ORDER BY name}} fixes it. It looks like https://github.com/apache/incubator-metamodel/blob/master/core/src/main/java/org/apache/metamodel/QueryPostprocessDataContext.java#L159 matches, and returns without applying the {{DISTINCT}} was: {{SELECT DISTINCT name FROM table}} returns duplicate names. Adding {{ORDER BY name}} fixes it. It looks like https://github.com/apache/incubator-metamodel/blob/master/core/src/main/java/org/apache/metamodel/QueryPostprocessDataContext.java#L159 matches, and returns without applying the {{DISTINCT}} > simple SELECT DISTINCT returns duplicates > ----------------------------------------- > > Key: METAMODEL-78 > URL: https://issues.apache.org/jira/browse/METAMODEL-78 > Project: Metamodel > Issue Type: Bug > Reporter: Ryan Berdeen > > Running {{SELECT DISTINCT name FROM table}} on a PojoDataContext returns > duplicate names. Adding {{ORDER BY name}} fixes it. > It looks like > https://github.com/apache/incubator-metamodel/blob/master/core/src/main/java/org/apache/metamodel/QueryPostprocessDataContext.java#L159 > matches, and returns without applying the {{DISTINCT}} -- This message was sent by Atlassian JIRA (v6.3.4#6332)