Bug #113699 QEP regression with prefer_ordering_index=off
Submitted: 21 Jan 2024 16:58 Modified: 7 Aug 2024 17:50
Reporter: Daniel Nichter (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S5 (Performance)
Version:8.0, 8.1, 8.2, 8.3 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

Contributions can be accepted to Open bugs only.

[23 Jan 2024 18:50] Daniel Nichter 
Patch 8.0.35 sql/sql_optimizer.cc to fix issue

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

Attachment: sql_optimizer.cc.patch (application/octet-stream, text), 957 bytes.
[23 Jan 2024 18:51] Daniel Nichter 
Patch 8.0.35 mysql-test/t/order_by_limit.test to test issue and fix

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

Attachment: order_by_limit.test.patch (application/octet-stream, text), 908 bytes.
[23 Jan 2024 18:52] Daniel Nichter 
Patch 8.0.35 mysql-test/r/order_by_limit.result to test issue and fix

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

Attachment: order_by_limit.result.patch (application/octet-stream, text), 1.07 KiB.