planner: implementing multi index merge from CNF/DNF condition

AilinKid commented 8 months ago

What problem does this PR solve?

Issue Number: close https://github.com/pingcap/tidb/issues/47759

Problem Summary:

What is changed and how it works?

Check List

Tests

[x] Unit test
[ ] Integration test
[ ] Manual test (add detailed scripts or steps below)
[ ] No need to test
- [ ] I checked and no code files have been changed.

Side effects

[ ] Performance regression: Consumes more CPU
[ ] Performance regression: Consumes more Memory
[ ] Breaking backward compatibility

Documentation

[ ] Affects user behaviors
[ ] Contains syntax changes
[ ] Contains variable changes
[ ] Contains experimental features
[ ] Changes MySQL compatibility

Release note

Please refer to Release Notes Language Style Guide to write a quality release note.

planner: implementing index merge from CNF condition

tiprow[bot] commented 7 months ago

@AilinKid: The specified target(s) for /test were not found. The following commands are available to trigger required jobs:

/test tiprow_fast_test

Use /test all to run all jobs.

In response to [this](https://github.com/pingcap/tidb/pull/47671#issuecomment-1794075239): >/test mysql-test Instructions for interacting with me using PR comments are available [here](https://git.k8s.io/community/contributors/guide/pull-requests.md). If you have questions or suggestions related to my behavior, please file an issue against the [kubernetes/test-infra](https://github.com/kubernetes/test-infra/issues/new?title=Prow%20issue:) repository.

AilinKid commented 7 months ago

/test tiprow_fast_test

ti-chi-bot[bot] commented 7 months ago

@AilinKid: The specified target(s) for /test were not found. The following commands are available to trigger required jobs:

/test build
/test check-dev
/test check-dev2
/test mysql-test
/test unit-test

The following commands are available to trigger optional jobs:

/test canary-notify-when-compatibility-sections-changed
/test pingcap/tidb/canary_ghpr_unit_test
/test pull-br-integration-test
/test pull-common-test
/test pull-e2e-test
/test pull-integration-common-test
/test pull-integration-copr-test
/test pull-integration-ddl-test
/test pull-integration-jdbc-test
/test pull-integration-mysql-test
/test pull-integration-nodejs-test
/test pull-mysql-client-test
/test pull-sqllogic-test
/test pull-tiflash-test

Use /test all to run the following jobs that were automatically triggered:

pingcap/tidb/ghpr_build
pingcap/tidb/ghpr_check
pingcap/tidb/ghpr_check2
pingcap/tidb/ghpr_mysql_test
pingcap/tidb/ghpr_unit_test

In response to [this](https://github.com/pingcap/tidb/pull/47671#issuecomment-1794076807): >/test tiprow_fast_test Instructions for interacting with me using PR comments are available [here](https://git.k8s.io/community/contributors/guide/pull-requests.md). If you have questions or suggestions related to my behavior, please file an issue against the [kubernetes/test-infra](https://github.com/kubernetes/test-infra/issues/new?title=Prow%20issue:) repository.

AilinKid commented 7 months ago

/test mysql-test

tiprow[bot] commented 7 months ago

@AilinKid: The specified target(s) for /test were not found. The following commands are available to trigger required jobs:

/test tiprow_fast_test

Use /test all to run all jobs.

In response to [this](https://github.com/pingcap/tidb/pull/47671#issuecomment-1794089978): >/test mysql-test Instructions for interacting with me using PR comments are available [here](https://git.k8s.io/community/contributors/guide/pull-requests.md). If you have questions or suggestions related to my behavior, please file an issue against the [kubernetes/test-infra](https://github.com/kubernetes/test-infra/issues/new?title=Prow%20issue:) repository.

AilinKid commented 7 months ago

/test unit-test

tiprow[bot] commented 7 months ago

@AilinKid: The specified target(s) for /test were not found. The following commands are available to trigger required jobs:

/test tiprow_fast_test

Use /test all to run all jobs.

In response to [this](https://github.com/pingcap/tidb/pull/47671#issuecomment-1794184055): >/test unit-test Instructions for interacting with me using PR comments are available [here](https://git.k8s.io/community/contributors/guide/pull-requests.md). If you have questions or suggestions related to my behavior, please file an issue against the [kubernetes/test-infra](https://github.com/kubernetes/test-infra/issues/new?title=Prow%20issue:) repository.

AilinKid commented 7 months ago

/test check-dev2

tiprow[bot] commented 7 months ago

@AilinKid: The specified target(s) for /test were not found. The following commands are available to trigger required jobs:

/test tiprow_fast_test

Use /test all to run all jobs.

In response to [this](https://github.com/pingcap/tidb/pull/47671#issuecomment-1794201815): >/test check-dev2 Instructions for interacting with me using PR comments are available [here](https://git.k8s.io/community/contributors/guide/pull-requests.md). If you have questions or suggestions related to my behavior, please file an issue against the [kubernetes/test-infra](https://github.com/kubernetes/test-infra/issues/new?title=Prow%20issue:) repository.

pingcap / tidb