[DERBY-7051] Multiple DISTINCT columns are not supported

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Bug
• Fix Version/s: 10.16.1.1
• Component/s: JDBC
• Environment: derby-10.11.1.1
• Urgency: Blocker
• Flags: Important
• Assignee: Unassigned
• Reporter: JackLi0812
• Created: 13/Aug/19 10:12
• Updated: 15/Aug/19 13:04
• Resolved: 15/Aug/19 13:04

Description

 

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.