Return-Path: X-Original-To: apmail-metamodel-dev-archive@minotaur.apache.org Delivered-To: apmail-metamodel-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C2D0317B52 for ; Sat, 17 Jan 2015 18:30:32 +0000 (UTC) Received: (qmail 12133 invoked by uid 500); 17 Jan 2015 18:30:34 -0000 Delivered-To: apmail-metamodel-dev-archive@metamodel.apache.org Received: (qmail 12088 invoked by uid 500); 17 Jan 2015 18:30:34 -0000 Mailing-List: contact dev-help@metamodel.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@metamodel.apache.org Delivered-To: mailing list dev@metamodel.apache.org Received: (qmail 12071 invoked by uid 99); 17 Jan 2015 18:30:34 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 17 Jan 2015 18:30:34 +0000 Date: Sat, 17 Jan 2015 18:30:34 +0000 (UTC) From: =?utf-8?Q?Kasper_S=C3=B8rensen_=28JIRA=29?= To: dev@metamodel.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (METAMODEL-78) simple SELECT DISTINCT returns duplicates MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/METAMODEL-78?page=3Dcom.atlassi= an.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D14= 281474#comment-14281474 ]=20 Kasper S=C3=B8rensen commented on METAMODEL-78: ------------------------------------------ Thanks for the fix Fabian. I can give it my +1 (see more details on the rev= iew board). Let's give others time to pitch in, and if nothing happens I th= ink we add it to master in a few days. > simple SELECT DISTINCT returns duplicates > ----------------------------------------- > > Key: METAMODEL-78 > URL: https://issues.apache.org/jira/browse/METAMODEL-78 > Project: Apache 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/c= ore/src/main/java/org/apache/metamodel/QueryPostprocessDataContext.java#L15= 9 matches, and returns without applying the {{DISTINCT}} -- This message was sent by Atlassian JIRA (v6.3.4#6332)