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)

Reply via email to