[
https://issues.apache.org/jira/browse/DERBY-3613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12588503#action_12588503
]
Artur Kuś commented on DERBY-3613:
----------------------------------
I starting from the page
http://en.wikipedia.org/wiki/SQL
and next http://en.wikipedia.org/wiki/SQL-92
and next open the page
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt.
In the specyfication I found that
"If DISTINCT is specified, then let TXA be the result of elimi-
nating redundant duplicate values from TX. Otherwise, let TXA be
TX."
So, in JavaDB is not ok :)
> 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.
