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)