db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3765) Select distinct Col1 from Table1 order by Col2 failed
Date Tue, 08 Jul 2008 13:34:32 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3765?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12611579#action_12611579
] 

Knut Anders Hatlen commented on DERBY-3765:
-------------------------------------------

I think this is intentional behaviour and not a bug. See Bryan Pendleton's interpretation
of the SQL standard for this case here: https://issues.apache.org/jira/browse/DERBY-2351?focusedCommentId=12505472#action_12505472

Also see Yip Ng's comment explaining that such a query is ambiguous: https://issues.apache.org/jira/browse/DERBY-2351?focusedCommentId=12473871#action_12473871


> Select distinct Col1 from Table1 order by Col2 failed
> -----------------------------------------------------
>
>                 Key: DERBY-3765
>                 URL: https://issues.apache.org/jira/browse/DERBY-3765
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.4.1.3
>            Reporter: Golgoth 14
>
> Hi,
> A query like "Select distinct Col1 from Table1 order by Col2" failed with SQL State:
42879
> see DERBY-2351
> Could you confirm ?
> Thanks

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


Mime
View raw message