Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-7051

Multiple DISTINCT columns are not supported

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Not A Bug
    • None
    • 10.16.1.1
    • JDBC
    • None
    • derby-10.11.1.1;
    • Blocker
    • Important

    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.
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            JackLi0812 JackLi0812
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: