Bug #108116 SQL queries with range of Item_row are not optimized
Submitted: 11 Aug 2022 8:21 Modified: 11 Aug 2022 9:21
Reporter: Brian Yue (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:8.0.29, 8.0.30, 5.7.39 OS:Any (rhel-7.4)
Assigned to: CPU Architecture:Any (x86-64)
Tags: Contribution

To submit contributions, please log in.

[26 Aug 2024 10:47] tianfeng li 
Contribute by Tencent : support row value decomposition for comparison (based on 8.4.2)

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

Attachment: 0001-support-row-value-decomposition-for-comparison.patch (application/octet-stream, text), 34.54 KiB.
[5 Sep 2024 3:40] tianfeng li 
Fix a bug of the above patch: consider NULL in select_list

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

Attachment: 0001-row-comparison-decomposition-for-SelectList-should-n.patch (application/octet-stream, text), 7.97 KiB.