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

SELECT DISTINCT field FROM TABLE_NAME GROUP BY field, field2

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.2.1
    • Fix Version/s: 10.4.2.0, 10.5.1.1
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      Windows XP

      Description

      Query 'SELECT DISTINCT field FROM TABLE_NAME GROUP BY field, field2' not work ok.
      Distinct is ignored !!!

        Attachments

        1. tenThree.diff
          5 kB
          Bryan Pendleton
        2. dontGenerateForDistinct.diff
          5 kB
          Bryan Pendleton
        3. addCommentAndAnotherTest.diff
          6 kB
          Bryan Pendleton

          Activity

            People

            • Assignee:
              bryanpendleton Bryan Pendleton
              Reporter:
              kusartur Artur Kuś
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: