[ https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16908059#comment-16908059 ]
Rick Hillegas commented on DERBY-7051: -------------------------------------- Glad to hear it! Closing this issue. > 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 > Priority: Major > Fix For: 10.16.0.0 > > > > {code:java} > SELECT DISTINCT (ORDERS.CUSTOMER_ID), DISTINCT (ORDERS.ORDER_ID) > FROM ORDERS > ORDER BY ORDERS.ORDER_ID > ;{code} > throw error: > {code:java} > SQL Error [42X01]: Syntax error: Encountered "DISTINCT" at line 1, column 39. > {code} -- This message was sent by Atlassian JIRA (v7.6.14#76016)