You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "JackLi0812 (JIRA)" <ji...@apache.org> on 2019/08/13 10:13:00 UTC

[jira] [Created] (DERBY-7051) Multiple DISTINCT columns are not supported

JackLi0812 created DERBY-7051:
---------------------------------

             Summary: Multiple DISTINCT columns are not supported
                 Key: DERBY-7051
                 URL: https://issues.apache.org/jira/browse/DERBY-7051
             Project: Derby
          Issue Type: Bug
          Components: JDBC
         Environment: derby-10.11.1.1;
            Reporter: JackLi0812


SELECT DISTINCT (ORDERS.CUSTOMER_ID), DISTINCT (ORDERS.ORDER_ID)
FROM ORDERS
ORDER BY ORDERS.ORDER_ID
;

 

throw error: SQL Error [42X01]: Syntax error: Encountered "DISTINCT" at line 1, column 39.



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)