Bug #113587 SELECT DISTINCT makes ORDER BY ... DESC sort data to ascending
Submitted: 9 Jan 2024 3:31 Modified: 15 Jan 2024 3:33
Reporter: Aristotle Po Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: select distinct order by

To submit contributions, please log in.

[27 Feb 2024 2:23] Yicheng Wei 
This is a fix for Bug #113587 by checking for some conditions before applying the optimization to skip sort.

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: Bug#113587.patch (application/octet-stream, text), 7.96 KiB.