Bug #117826 Add histogram selectivity for key ranges

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.