[
https://issues.apache.org/jira/browse/DERBY-3613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12588565#action_12588565
]
Knut Anders Hatlen commented on DERBY-3613:
-------------------------------------------
I tried the query with different versions of Derby:
10.0.1.2: two rows
10.1.1.0: two rows
10.1.2.1: one row
10.2.1.6: one row
10.2.2.0: one row
10.3.1.4: two rows
10.3.2.1: two rows
10.4.1.1 (RC): two rows
So, given that one row is the correct result, the bug was fixed at some point,
but it regressed back later.
> 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ś
>
> Query 'SELECT DISTINCT field FROM TABLE_NAME GROUP BY field, field2' not
> work ok.
> Distinct is ignored !!!
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
