[CAY-2847] Improve duplicate select column detection when using order by

• Type: Sub-task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 5.0-M1
• Component/s: Core Library
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Jurgen Doll
• Created: 29/Feb/24 10:51
• Updated: 12/Jun/24 13:37
• Resolved: 12/Jun/24 13:37

Description

The current implementation has three problems:

1. It fails when a column has an alias
2. It builds the whole SQL column string before comparing
3. It doesn't seem very robust in preventing false results