Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-2842

Prevent duplicate select columns when using distinct with order by

    XMLWordPrintableJSON

Details

    Description

      When a "select distinct" query has an "order by" clause then the "order by" fields must also be listed in the select clause. However no check is currently done to see if the column is already specified which can result in duplicate columns being fetched.

      This is listed as a TODO item in OrderingStage.

      Attachments

        Activity

          People

            Unassigned Unassigned
            jurgen Jurgen Doll
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 8h 40m
                8h 40m