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)