[ https://issues.apache.org/jira/browse/DERBY-7051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
JackLi0812 updated DERBY-7051: ------------------------------ Description: {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} was: 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. > 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 > > > {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)