Bug #117826 Add histogram selectivity for key ranges

• Submitted: 28 Mar 17:29
• Modified: 30 Mar 8:12
• Reporter: Kaiwang CHen (OCA)
• Status: Verified
• Category: MySQL Server: Optimizer
• Severity: S4 (Feature request)
• Version: 9.2
• OS: Any
• CPU Architecture: Any
• Tags: Contribution

[28 Mar 17:31] Kaiwang CHen

Bug #117750 FORCE INDEX does not skip records_in_range() for 'x IS NOT NULL'

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

Attachment: range_estimator_1_of_8_bug_117750.patch (application/octet-stream, text), 2.43 KiB.

[28 Mar 17:32] Kaiwang CHen

Bug #117776: Index statistics is unexpectedly used to estimate eq ranges with null part

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

Attachment: range_estimator_2_of_8_bug_117776.patch (application/octet-stream, text), 14.17 KiB.

[28 Mar 17:32] Kaiwang CHen

Bug #117791 FORCE INDEX does not skip records_in_range() for 'x IS NULL'

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

Attachment: range_estimator_3_of_8_bug_117791.patch (application/octet-stream, text), 6.02 KiB.

[28 Mar 17:33] Kaiwang CHen

Extract single range estimator to range_estimator.cc

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

Attachment: range_estimator_4_of_8_extract.patch (application/octet-stream, text), 20.20 KiB.

[28 Mar 17:33] Kaiwang CHen

Templatize get_selectivity_dispatcher()

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

Attachment: range_estimator_5_of_8_templatize.patch (application/octet-stream, text), 6.29 KiB.

[28 Mar 17:34] Kaiwang CHen

Add histogram selectivity against field range.

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

Attachment: range_estimator_6_of_8_histogram_field.patch (application/octet-stream, text), 18.91 KiB.

[28 Mar 17:35] Kaiwang CHen

Add histogram selectivity for key range, and sys vars.

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

Attachment: range_estimator_7_of_8_histogram_range.patch (application/octet-stream, text), 76.03 KiB.

[28 Mar 17:35] Kaiwang CHen

Add histogram adjust.

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

Attachment: range_estimator_8_of_8_histogram_adjust.patch (application/octet-stream, text), 9.31 KiB.

[1 Apr 10:59] Kaiwang CHen

postfixes: keyno and range flag with next keypart

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

Attachment: range_estimator_postfix_1_keyno_flag.patch (application/octet-stream, text), 9.36 KiB.

[8 Apr 3:58] Kaiwang CHen

Refine comment on the field range selectivity formula

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

Attachment: range_estimator_postfix_2_comment.patch (application/octet-stream, text), 835 bytes.

[14 May 13:12] Kaiwang CHen

Postfix: Uninitialized range estimator for internal temporary tables

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

Attachment: range_estimator_postfix_3_init.patch (application/octet-stream, text), 2.82 KiB.

[14 May 13:12] Kaiwang CHen

Postfix: Uninitialized range estimator for internal temporary tables

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

Attachment: range_estimator_postfix_3_init.patch (application/octet-stream, text), 2.82 KiB.