Affects Version/s: None
Fix Version/s: None
Security Level: All
This issue is created automatically through a Github pull request on behalf of gigablah:
Presently, it's possible to do this using QueryBuilder:
->addOrderBy('u.name', 'ASC'); // duplicate
SELECT u.* FROM users u ORDER BY u.name ASC, u.name ASC
This patch removes duplicates from the `SELECT`, `SET`, `ORDER BY` and `GROUP BY` parts during SQL generation (there's already logic that removes duplicate `FROM` parts).
I've added test cases for each affected keyword as well.