[CAY-2842] Prevent duplicate select columns when using distinct with order by

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.2
• Fix Version/s: 5.0-M1
• Component/s: Core Library
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Jurgen Doll
• Created: 07/Feb/24 12:11
• Updated: 12/Jun/24 13:37
• Resolved: 12/Jun/24 13:37

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.