Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1503689024.1207928284950.JavaMail.jira@brutus>
Date: Fri, 11 Apr 2008 08:38:04 -0700 (PDT)
From: "Bryan Pendleton (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-3613) SELECT DISTINCT field FROM
 TABLE_NAME GROUP BY field,  field2
In-Reply-To: <2089939599.1207920607944.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/DERBY-3613?page=3Dcom.atlassian=
.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1258=
8003#action_12588003 ]=20

Bryan Pendleton commented on DERBY-3613:
----------------------------------------

I believe you get two rows because the results have been partitioned
into two groups, as you specified in the GROUP BY.

Within each group you are getting only one distinct value of 'field',
but there are two groups total.

> SELECT DISTINCT field FROM TABLE_NAME GROUP BY field,  field2
> -------------------------------------------------------------
>
>                 Key: DERBY-3613
>                 URL: https://issues.apache.org/jira/browse/DERBY-3613
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.3.2.1
>         Environment: Windows XP
>            Reporter: Artur Ku=C5=9B
>
> Query 'SELECT DISTINCT field FROM TABLE_NAME GROUP BY field,  field2'  no=
t work ok.
>  Distinct is ignored !!!

--=20
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.