You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@metamodel.apache.org by "Ryan Berdeen (JIRA)" <ji...@apache.org> on 2014/09/26 04:06:34 UTC

[jira] [Updated] (METAMODEL-78) simple SELECT DISTINCT returns duplicates

     [ 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)