Bug #119442 Optimizer fails to simplify ORDER BY when column is filtered by IS NULL, causing filesort
Submitted: 21 Nov 20:13 Modified: 27 Nov 4:52
Reporter: Kishore Kumar (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S5 (Performance)
Version:8.4.4 OS:Any
Assigned to: CPU Architecture:Any
Tags: filesort, INDEX, IS NULL, Optimizer, order by

To submit contributions, please log in.

[25 Nov 23:19] OCA Admin 
Contribution submitted via Github - Bug #119442: Fix ORDER BY optimization doesn't recognize IS NULL as constant 
(*) Contribution by Kishore Kumar (Github akcube, mysql-server/pull/637#issuecomment-3577811434): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Attachment: git_patch_3036837769.txt (text/plain), 28.44 KiB.