# TiDB Customer Issue Experiences

- Repository: `pingcap/tidb`
- Source Query: `repo:pingcap/tidb is:issue label:"report/customer" label:"sig/planner" created:>=2024-01-01`
- Total Issues: 188

| Issue | Status | Type | Linked PR Count | File |
| --- | --- | --- | ---: | --- |
| #67498 | open | type/bug | 1 | [issue-67498-planner-preserve-in-for-varchar-vs-numeric-comparisons-with-a-common-cmp-type.md](./issue-67498-planner-preserve-in-for-varchar-vs-numeric-comparisons-with-a-common-cmp-type.md) |
| #67468 | open | type/enhancement | 0 | [issue-67468-support-join-reorder-for-semi-join.md](./issue-67468-support-join-reorder-for-semi-join.md) |
| #67467 | open | type/enhancement | 1 | [issue-67467-enable-semi-join-rewrite-in-multi-alternative-implementation.md](./issue-67467-enable-semi-join-rewrite-in-multi-alternative-implementation.md) |
| #67409 | open | type/enhancement | 0 | [issue-67409-planner-white-list-based-plan-cache-strategy.md](./issue-67409-planner-white-list-based-plan-cache-strategy.md) |
| #67385 | open | type/bug | 0 | [issue-67385-sql-infra-a-user-wth-super-privilege-can-t-execute-show-config.md](./issue-67385-sql-infra-a-user-wth-super-privilege-can-t-execute-show-config.md) |
| #67366 | open | type/enhancement | 3 | [issue-67366-planner-output-a-warning-if-implicit-join-key-type-conversion-happend.md](./issue-67366-planner-output-a-warning-if-implicit-join-key-type-conversion-happend.md) |
| #67363 | open | type/enhancement | 0 | [issue-67363-planner-better-binding-matching-mechanism.md](./issue-67363-planner-better-binding-matching-mechanism.md) |
| #67138 | closed | type/bug | 2 | [issue-67138-when-cte-contains-order-by-the-subquery-error-returns-null.md](./issue-67138-when-cte-contains-order-by-the-subquery-error-returns-null.md) |
| #67108 | closed | type/enhancement | 1 | [issue-67108-planner-refine-reuse-chunk-heuristic-for-large-rows-under-root-limit.md](./issue-67108-planner-refine-reuse-chunk-heuristic-for-large-rows-under-root-limit.md) |
| #66919 | open | type/enhancement | 2 | [issue-66919-planner-statistics-use-selected-partition-stats-for-dynamic-pruning.md](./issue-66919-planner-statistics-use-selected-partition-stats-for-dynamic-pruning.md) |
| #66903 | closed | type/bug | 1 | [issue-66903-planner-task-nil-pointer.md](./issue-66903-planner-task-nil-pointer.md) |
| #66668 | closed | type/enhancement | 2 | [issue-66668-planner-can-t-use-primary-as-an-index-in-indexmerge-for-predicate-id-and-a-or-b.md](./issue-66668-planner-can-t-use-primary-as-an-index-in-indexmerge-for-predicate-id-and-a-or-b.md) |
| #66658 | open | type/enhancement | 0 | [issue-66658-planner-decrease-concurrency-batch-size-automatically-for-streaming-plans-with-l.md](./issue-66658-planner-decrease-concurrency-batch-size-automatically-for-streaming-plans-with-l.md) |
| #66623 | closed | type/bug | 3 | [issue-66623-planner-same-plans-with-different-in-list-should-have-the-same-plan-digests.md](./issue-66623-planner-same-plans-with-different-in-list-should-have-the-same-plan-digests.md) |
| #66320 | open | type/bug | 1 | [issue-66320-planner-correlate-a-non-correlated-in-subquery.md](./issue-66320-planner-correlate-a-non-correlated-in-subquery.md) |
| #66203 | open | type/enhancement | 0 | [issue-66203-planner-decrease-the-default-value-64mb-of-tidb-opt-range-max-size.md](./issue-66203-planner-decrease-the-default-value-64mb-of-tidb-opt-range-max-size.md) |
| #65938 | closed | type/bug | 2 | [issue-65938-can-t-find-column-column-6-in-schema-column-column-5-pkoruk-nullableuk.md](./issue-65938-can-t-find-column-column-6-in-schema-column-column-5-pkoruk-nullableuk.md) |
| #65924 | open | type/bug | 2 | [issue-65924-the-estrows-of-equal-condition-is-overestimated-when-the-modify-count-is-zero.md](./issue-65924-the-estrows-of-equal-condition-is-overestimated-when-the-modify-count-is-zero.md) |
| #65916 | open | type/bug | 0 | [issue-65916-explain-for-connection-fails-with-non-prepared-plan-cache-parameterization.md](./issue-65916-explain-for-connection-fails-with-non-prepared-plan-cache-parameterization.md) |
| #65915 | closed | type/bug | 1 | [issue-65915-analyze-statement-freezes-if-saveanalyzeresulttostorage-meets-error-when-analyze.md](./issue-65915-analyze-statement-freezes-if-saveanalyzeresulttostorage-meets-error-when-analyze.md) |
| #65878 | open | type/enhancement | 1 | [issue-65878-planner-plan-cache-support-queries-with-int-col-str-val.md](./issue-65878-planner-plan-cache-support-queries-with-int-col-str-val.md) |
| #65876 | closed | type/enhancement | 1 | [issue-65876-planner-non-prep-plan-cache-support-is-null.md](./issue-65876-planner-non-prep-plan-cache-support-is-null.md) |
| #65867 | closed | type/bug | 2 | [issue-65867-tidb-runtime-error-invalid-memory-address-or-nil-pointer-dereference.md](./issue-65867-tidb-runtime-error-invalid-memory-address-or-nil-pointer-dereference.md) |
| #65838 | open | type/bug | 0 | [issue-65838-inl-join-hint-shows-warning-when-tidb-opt-advanced-join-hint-off-but-silently-fa.md](./issue-65838-inl-join-hint-shows-warning-when-tidb-opt-advanced-join-hint-off-but-silently-fa.md) |
| #65822 | open | type/enhancement | 0 | [issue-65822-support-building-indexmerge-path-and-pushing-down-limit-for-in-expression-in-nes.md](./issue-65822-support-building-indexmerge-path-and-pushing-down-limit-for-in-expression-in-nes.md) |
| #65818 | closed | type/bug | 1 | [issue-65818-analyze-cannot-be-cancelled-promptly.md](./issue-65818-analyze-cannot-be-cancelled-promptly.md) |
| #65712 | open | type/enhancement | 1 | [issue-65712-better-plan-for-limit-n-order-by-on-indexmerge-when-not-all-partial-paths-satisf.md](./issue-65712-better-plan-for-limit-n-order-by-on-indexmerge-when-not-all-partial-paths-satisf.md) |
| #65639 | open | type/bug | 0 | [issue-65639-sql-binding-fails-silently-when-sql-is-too-long-binding-created-but-not-visible-.md](./issue-65639-sql-binding-fails-silently-when-sql-is-too-long-binding-created-but-not-visible-.md) |
| #65556 | open | type/bug | 2 | [issue-65556-cost-model-v2-indexhashjoin-cost-underestimation.md](./issue-65556-cost-model-v2-indexhashjoin-cost-underestimation.md) |
| #65489 | closed | type/bug | 3 | [issue-65489-memory-leak-when-analyze-table-is-the-last-statement-in-a-session.md](./issue-65489-memory-leak-when-analyze-table-is-the-last-statement-in-a-session.md) |
| #65381 | closed | type/bug | 3 | [issue-65381-planner-the-optimizer-can-t-use-the-latest-tidb-mem-quota-binding-cache-value-to.md](./issue-65381-planner-the-optimizer-can-t-use-the-latest-tidb-mem-quota-binding-cache-value-to.md) |
| #65208 | open | type/enhancement | 2 | [issue-65208-support-using-ordering-property-to-get-better-join-order.md](./issue-65208-support-using-ordering-property-to-get-better-join-order.md) |
| #65183 | closed | type/bug | 2 | [issue-65183-planner-row-count-incorrectly-forced-to-1-for-indexjoin-when-matching-only-a-pre.md](./issue-65183-planner-row-count-incorrectly-forced-to-1-for-indexjoin-when-matching-only-a-pre.md) |
| #65166 | closed | type/bug | 4 | [issue-65166-planner-outer-join-cannot-be-eliminated-due-to-the-impact-of-the-expression-inde.md](./issue-65166-planner-outer-join-cannot-be-eliminated-due-to-the-impact-of-the-expression-inde.md) |
| #65165 | closed | type/enhancement | 1 | [issue-65165-planner-outer-join-should-be-eliminated-when-join-keys-do-not-use-nulleq-and-can.md](./issue-65165-planner-outer-join-should-be-eliminated-when-join-keys-do-not-use-nulleq-and-can.md) |
| #65100 | closed | type/enhancement | 3 | [issue-65100-planner-unnecessary-overhead-caused-by-the-optimizer-matching-bindings-twice-whe.md](./issue-65100-planner-unnecessary-overhead-caused-by-the-optimizer-matching-bindings-twice-whe.md) |
| #65059 | closed | type/question | 2 | [issue-65059-tiflash-plan-returns-no-access-path-error-in-rc-isolation-level.md](./issue-65059-tiflash-plan-returns-no-access-path-error-in-rc-isolation-level.md) |
| #65032 | closed | type/enhancement | 0 | [issue-65032-planner-set-the-default-value-of-tidb-opt-ordering-index-selectivity-threshold-t.md](./issue-65032-planner-set-the-default-value-of-tidb-opt-ordering-index-selectivity-threshold-t.md) |
| #64809 | open | type/enhancement | 0 | [issue-64809-planner-out-of-range-estimation-enhancement.md](./issue-64809-planner-out-of-range-estimation-enhancement.md) |
| #64712 | open | type/enhancement | 0 | [issue-64712-build-better-range-with-not-expression.md](./issue-64712-build-better-range-with-not-expression.md) |
| #64707 | open | type/enhancement | 0 | [issue-64707-planner-extract-common-leading-predicates-in-dnf-and-push-them-to-indexscan-to-f.md](./issue-64707-planner-extract-common-leading-predicates-in-dnf-and-push-them-to-indexscan-to-f.md) |
| #64649 | open | type/enhancement | 0 | [issue-64649-planner-index-join-cardinality-estimation-issue-because-of-filter-re-estimates-c.md](./issue-64649-planner-index-join-cardinality-estimation-issue-because-of-filter-re-estimates-c.md) |
| #64648 | open | type/enhancement | 0 | [issue-64648-planner-optimizer-uses-total-table-size-for-partition-table-scan-cost-estimation.md](./issue-64648-planner-optimizer-uses-total-table-size-for-partition-table-scan-cost-estimation.md) |
| #64643 | closed | type/bug | 3 | [issue-64643-planner-read-from-storage-hint-table-alias-matching-problem-when-using-crossdb-b.md](./issue-64643-planner-read-from-storage-hint-table-alias-matching-problem-when-using-crossdb-b.md) |
| #64572 | closed | type/bug | 3 | [issue-64572-planner-unexpected-low-out-of-range-estimation-on-index-stats.md](./issue-64572-planner-unexpected-low-out-of-range-estimation-on-index-stats.md) |
| #64463 | closed | type/bug | 0 | [issue-64463-tidb-report-error-some-columns-of-limit-69-cannot-find-the-reference-from-its-ch.md](./issue-64463-tidb-report-error-some-columns-of-limit-69-cannot-find-the-reference-from-its-ch.md) |
| #64423 | closed | type/bug | 3 | [issue-64423-analyze-a-small-table-costs-a-lot-of-memory.md](./issue-64423-analyze-a-small-table-costs-a-lot-of-memory.md) |
| #64375 | closed | type/enhancement | 2 | [issue-64375-planner-a-more-fine-grained-track-of-optimization-time.md](./issue-64375-planner-a-more-fine-grained-track-of-optimization-time.md) |
| #64345 | open | type/enhancement | 0 | [issue-64345-recommend-index-statements-may-be-slow-and-can-t-be-killed.md](./issue-64345-recommend-index-statements-may-be-slow-and-can-t-be-killed.md) |
| #64329 | closed | type/bug | 1 | [issue-64329-xxxx-is-null-prevent-the-optimizer-from-choosing-the-best-join-order-and-indexjo.md](./issue-64329-xxxx-is-null-prevent-the-optimizer-from-choosing-the-best-join-order-and-indexjo.md) |
| #64278 | closed | type/bug | 2 | [issue-64278-planner-chooses-wrong-plan-due-to-the-overestimation-of-equal-condition-on-index.md](./issue-64278-planner-chooses-wrong-plan-due-to-the-overestimation-of-equal-condition-on-index.md) |
| #64276 | open | type/bug | 0 | [issue-64276-planner-incorrect-estrows-on-projection-with-pointget.md](./issue-64276-planner-incorrect-estrows-on-projection-with-pointget.md) |
| #64274 | closed | type/bug | 1 | [issue-64274-async-load-may-panic-when-processing-dropped-indexes.md](./issue-64274-async-load-may-panic-when-processing-dropped-indexes.md) |
| #64263 | closed | type/bug | 2 | [issue-64263-plan-cache-can-t-work-after-update-to-v8-5-3.md](./issue-64263-plan-cache-can-t-work-after-update-to-v8-5-3.md) |
| #64250 | closed | type/bug | 4 | [issue-64250-global-binding-cache-may-be-incorrect-after-concurrent-binding-operations-on-mul.md](./issue-64250-global-binding-cache-may-be-incorrect-after-concurrent-binding-operations-on-mul.md) |
| #64217 | open | type/enhancement | 0 | [issue-64217-planner-large-estimation-error-of-probe-side-of-indexjoin-when-table-filter-sele.md](./issue-64217-planner-large-estimation-error-of-probe-side-of-indexjoin-when-table-filter-sele.md) |
| #64205 | open | type/enhancement | 1 | [issue-64205-support-dump-plan-replayer-for-prepare-stmt.md](./issue-64205-support-dump-plan-replayer-for-prepare-stmt.md) |
| #64137 | closed | type/bug | 3 | [issue-64137-planner-consider-empty-histogram-and-newly-emerging-values-in-out-of-range-estim.md](./issue-64137-planner-consider-empty-histogram-and-newly-emerging-values-in-out-of-range-estim.md) |
| #63985 | closed | type/bug | 4 | [issue-63985-plan-changed-unexpectedly-because-expression-index-wasn-t-chosen-by-default.md](./issue-63985-plan-changed-unexpectedly-because-expression-index-wasn-t-chosen-by-default.md) |
| #63805 | open | type/bug | 1 | [issue-63805-prepare-query-with-order-by-clause-does-not-work-with-sql-binding.md](./issue-63805-prepare-query-with-order-by-clause-does-not-work-with-sql-binding.md) |
| #63602 | closed | type/bug | 2 | [issue-63602-statement-with-scalar-subquery-result-wrong.md](./issue-63602-statement-with-scalar-subquery-result-wrong.md) |
| #63573 | open | type/bug | 0 | [issue-63573-true-or-expressions-are-not-always-short-circuit.md](./issue-63573-true-or-expressions-are-not-always-short-circuit.md) |
| #63492 | closed | type/bug | 2 | [issue-63492-hash-aggregation-may-not-be-pushed-down-to-tikv-during-admin-check-table.md](./issue-63492-hash-aggregation-may-not-be-pushed-down-to-tikv-during-admin-check-table.md) |
| #63417 | open | type/enhancement | 0 | [issue-63417-planner-expand-the-dnf-expression-to-construct-precise-scan-ranges.md](./issue-63417-planner-expand-the-dnf-expression-to-construct-precise-scan-ranges.md) |
| #63410 | open | type/bug | 0 | [issue-63410-binding-create-binding-from-plan-digest-can-t-distinguish-different-plans-with-s.md](./issue-63410-binding-create-binding-from-plan-digest-can-t-distinguish-different-plans-with-s.md) |
| #63370 | closed | type/bug | 4 | [issue-63370-limit-doesn-t-pushdown-to-tikv-automatically.md](./issue-63370-limit-doesn-t-pushdown-to-tikv-automatically.md) |
| #63369 | closed | type/bug | 3 | [issue-63369-tiflash-query-result-materialization-can-t-take-effect-after-setting-sql-mode-by.md](./issue-63369-tiflash-query-result-materialization-can-t-take-effect-after-setting-sql-mode-by.md) |
| #63353 | closed | type/bug | 2 | [issue-63353-dp-join-reorder-on-the-graph-that-is-not-totally-connect-may-fail-to-execute.md](./issue-63353-dp-join-reorder-on-the-graph-that-is-not-totally-connect-may-fail-to-execute.md) |
| #63336 | open | type/enhancement | 2 | [issue-63336-planner-a-new-risk-aware-index-selection-heuristic-rule-for-indexlookup-in-skyli.md](./issue-63336-planner-a-new-risk-aware-index-selection-heuristic-rule-for-indexlookup-in-skyli.md) |
| #63314 | closed | type/enhancement | 8 | [issue-63314-planner-join-order-algo-can-t-select-the-lowest-cost-join-order-since-join-keys-.md](./issue-63314-planner-join-order-algo-can-t-select-the-lowest-cost-join-order-since-join-keys-.md) |
| #63290 | closed | type/enhancement | 2 | [issue-63290-planner-the-greedy-join-order-algorithm-can-t-select-the-lowest-cost-plan-since-.md](./issue-63290-planner-the-greedy-join-order-algorithm-can-t-select-the-lowest-cost-plan-since-.md) |
| #63280 | closed | type/enhancement | 2 | [issue-63280-planner-utilize-prefix-of-columns-in-order-limit-clause-to-avoid-full-table-scan.md](./issue-63280-planner-utilize-prefix-of-columns-in-order-limit-clause-to-avoid-full-table-scan.md) |
| #63235 | closed | type/bug | 12 | [issue-63235-with-the-introduction-of-issaferange-cpu-resources-are-consumed-more-heavily.md](./issue-63235-with-the-introduction-of-issaferange-cpu-resources-are-consumed-more-heavily.md) |
| #63075 | closed | type/bug | 5 | [issue-63075-select-1-from-dual-can-t-hit-instance-level-plan-cache.md](./issue-63075-select-1-from-dual-can-t-hit-instance-level-plan-cache.md) |
| #62978 | closed | type/question | 0 | [issue-62978-unexpected-warning-when-using-read-from-storage-hint.md](./issue-62978-unexpected-warning-when-using-read-from-storage-hint.md) |
| #62975 | open | type/enhancement | 0 | [issue-62975-make-it-possible-to-push-agg-down-cross-unionscan.md](./issue-62975-make-it-possible-to-push-agg-down-cross-unionscan.md) |
| #62917 | closed | type/bug | 3 | [issue-62917-planner-mergejoin-cost-formula-should-consider-othercond.md](./issue-62917-planner-mergejoin-cost-formula-should-consider-othercond.md) |
| #62766 | open | type/enhancement | 1 | [issue-62766-same-predicate-estimation-of-two-approximate-stats-is-quite-different.md](./issue-62766-same-predicate-estimation-of-two-approximate-stats-is-quite-different.md) |
| #62722 | closed | type/enhancement | 1 | [issue-62722-enable-set-var-hint-support-for-tidb-allow-tiflash-cop.md](./issue-62722-enable-set-var-hint-support-for-tidb-allow-tiflash-cop.md) |
| #62672 | closed | type/bug | 6 | [issue-62672-only-full-group-by-check-should-be-case-sensitive.md](./issue-62672-only-full-group-by-check-should-be-case-sensitive.md) |
| #62665 | closed | type/bug | 2 | [issue-62665-equal-predicate-at-end-of-range-or-out-of-range-does-not-recognize-modifycount.md](./issue-62665-equal-predicate-at-end-of-range-or-out-of-range-does-not-recognize-modifycount.md) |
| #62556 | closed | type/bug | 2 | [issue-62556-group-by-in-prepared-statement-causes-error-in-tidb-mysql-compatible.md](./issue-62556-group-by-in-prepared-statement-causes-error-in-tidb-mysql-compatible.md) |
| #62551 | closed | type/bug | 4 | [issue-62551-rollup-will-output-more-rows-than-expected.md](./issue-62551-rollup-will-output-more-rows-than-expected.md) |
| #62499 | closed | type/enhancement | 5 | [issue-62499-planner-consider-the-number-of-ranges-and-the-seek-operation-cost-for-indexjoin-.md](./issue-62499-planner-consider-the-number-of-ranges-and-the-seek-operation-cost-for-indexjoin-.md) |
| #62448 | open | type/enhancement | 0 | [issue-62448-tidb-can-t-push-down-join-with-nulleq-key-condition-to-tiflash.md](./issue-62448-tidb-can-t-push-down-join-with-nulleq-key-condition-to-tiflash.md) |
| #62438 | closed | type/bug | 4 | [issue-62438-the-same-count-tablerowidscan-may-generate-different-cost-evaluation.md](./issue-62438-the-same-count-tablerowidscan-may-generate-different-cost-evaluation.md) |
| #62216 | closed | type/bug | 1 | [issue-62216-stats-analyze-panic-with-error-index-out-of-range-10-with-length-10-include-virt.md](./issue-62216-stats-analyze-panic-with-error-index-out-of-range-10-with-length-10-include-virt.md) |
| #62050 | closed | type/bug | 4 | [issue-62050-cannot-simplify-predicate-isnull-not-null-column.md](./issue-62050-cannot-simplify-predicate-isnull-not-null-column.md) |
| #61990 | open | type/question | 0 | [issue-61990-planner-index-predicates-based-on-column-prefix-are-not-pushed-down-to-index-sid.md](./issue-61990-planner-index-predicates-based-on-column-prefix-are-not-pushed-down-to-index-sid.md) |
| #61889 | closed | type/bug | 3 | [issue-61889-tidb-load-binding-timeout-cannot-rightly-init-the-default-value.md](./issue-61889-tidb-load-binding-timeout-cannot-rightly-init-the-default-value.md) |
| #61822 | closed | type/bug | 4 | [issue-61822-ttl-scan-cannot-trigger-sync-async-load-generateruntimefilter.md](./issue-61822-ttl-scan-cannot-trigger-sync-async-load-generateruntimefilter.md) |
| #61785 | closed | type/bug | 4 | [issue-61785-analyze-s-analyzecolumnspushdownv2-create-too-much-concurrency.md](./issue-61785-analyze-s-analyzecolumnspushdownv2-create-too-much-concurrency.md) |
| #61716 | open | type/enhancement | 2 | [issue-61716-avoid-indexmerge-double-read-for-multi-valued-index.md](./issue-61716-avoid-indexmerge-double-read-for-multi-valued-index.md) |
| #61669 | closed | type/bug | 2 | [issue-61669-planner-invalid-column-error-when-building-indexjoin-for-sub-query-with-multiple.md](./issue-61669-planner-invalid-column-error-when-building-indexjoin-for-sub-query-with-multiple.md) |
| #61606 | closed | type/bug | 6 | [issue-61606-tidb-s-analyze-command-cannot-correctly-handle-a-virtual-generated-column-if-it-.md](./issue-61606-tidb-s-analyze-command-cannot-correctly-handle-a-virtual-generated-column-if-it-.md) |
| #61602 | closed | type/bug | 6 | [issue-61602-planner-wrong-join-estimation-depending-on-uninitialized-or-missing-stats.md](./issue-61602-planner-wrong-join-estimation-depending-on-uninitialized-or-missing-stats.md) |
| #61568 | open | type/enhancement | 0 | [issue-61568-planner-remove-duplicated-predicates-in-cnf-or-dnf.md](./issue-61568-planner-remove-duplicated-predicates-in-cnf-or-dnf.md) |
| #61565 | closed | type/bug | 7 | [issue-61565-internal-sql-wrongly-use-get-plan-cost-v1.md](./issue-61565-internal-sql-wrongly-use-get-plan-cost-v1.md) |
| #61501 | open | type/enhancement | 1 | [issue-61501-planner-support-a-hint-or-var-like-index-join-first-to-indicate-the-planner-to-p.md](./issue-61501-planner-support-a-hint-or-var-like-index-join-first-to-indicate-the-planner-to-p.md) |
| #61339 | closed | type/enhancement | 4 | [issue-61339-totalcount-spends-too-much-time.md](./issue-61339-totalcount-spends-too-much-time.md) |
| #61305 | closed | type/bug | 2 | [issue-61305-full-table-scan-hash-join-index-join-when-using-select-distinct-constant-instead.md](./issue-61305-full-table-scan-hash-join-index-join-when-using-select-distinct-constant-instead.md) |
| #61093 | closed | type/enhancement | 2 | [issue-61093-index-merge-alternative-picking-should-consider-the-countafteraccess-more-than-t.md](./issue-61093-index-merge-alternative-picking-should-consider-the-countafteraccess-more-than-t.md) |
| #60985 | closed | type/bug | 5 | [issue-60985-tidb-panic-when-using-plan-replayer-dump-with-a-table-using-foreign-keys.md](./issue-60985-tidb-panic-when-using-plan-replayer-dump-with-a-table-using-foreign-keys.md) |
| #60984 | open | type/bug | 0 | [issue-60984-wrongly-enable-plan-cache-with-tiflash.md](./issue-60984-wrongly-enable-plan-cache-with-tiflash.md) |
| #60692 | closed | type/bug | 2 | [issue-60692-tidb-reports-can-t-find-column-error-from-v8-5-0-when-there-are-multiple-joins-i.md](./issue-60692-tidb-reports-can-t-find-column-error-from-v8-5-0-when-there-are-multiple-joins-i.md) |
| #60655 | closed | type/bug | 4 | [issue-60655-throw-can-t-find-column-xxx-in-schema-column-error-when-execute-sql.md](./issue-60655-throw-can-t-find-column-xxx-in-schema-column-error-when-execute-sql.md) |
| #60455 | open | type/bug | 0 | [issue-60455-unknown-column-with-only-full-group-by.md](./issue-60455-unknown-column-with-only-full-group-by.md) |
| #60380 | open | type/enhancement | 0 | [issue-60380-plan-cache-the-different-in-value-numbers-in-query-cause-too-much-memory-in-tidb.md](./issue-60380-plan-cache-the-different-in-value-numbers-in-query-cause-too-much-memory-in-tidb.md) |
| #60357 | closed | type/enhancement | 8 | [issue-60357-require-an-ability-to-externally-influence-the-optimizer-cost-model.md](./issue-60357-require-an-ability-to-externally-influence-the-optimizer-cost-model.md) |
| #60242 | closed | type/enhancement | 9 | [issue-60242-planner-need-to-ignore-the-ordering-index-path-even-if-the-index-selectivity-is-.md](./issue-60242-planner-need-to-ignore-the-ordering-index-path-even-if-the-index-selectivity-is-.md) |
| #60137 | closed | type/enhancement | 1 | [issue-60137-planner-prevent-pseudo-stats-from-dominating-the-stats-cache.md](./issue-60137-planner-prevent-pseudo-stats-from-dominating-the-stats-cache.md) |
| #60076 | closed | type/enhancement | 5 | [issue-60076-planner-keep-redundant-join-key-predicates-when-propagating-eq-predicates.md](./issue-60076-planner-keep-redundant-join-key-predicates-when-propagating-eq-predicates.md) |
| #60037 | closed | type/bug | 5 | [issue-60037-auto-analyze-merge-global-statistics-failed-when-some-partition-statistics-are-m.md](./issue-60037-auto-analyze-merge-global-statistics-failed-when-some-partition-statistics-are-m.md) |
| #59986 | closed | type/enhancement | 1 | [issue-59986-planner-support-long-binding-statement.md](./issue-59986-planner-support-long-binding-statement.md) |
| #59972 | closed | type/enhancement | 3 | [issue-59972-planner-selection-splits-the-join-group-to-two-parts-forbidding-join-reorder-to-.md](./issue-59972-planner-selection-splits-the-join-group-to-two-parts-forbidding-join-reorder-to-.md) |
| #59902 | closed | type/bug | 2 | [issue-59902-the-estrows-is-wrong-for-inner-operator-of-index-join.md](./issue-59902-the-estrows-is-wrong-for-inner-operator-of-index-join.md) |
| #59876 | closed | type/bug | 1 | [issue-59876-covering-indexes-do-not-work-in-update-joins.md](./issue-59876-covering-indexes-do-not-work-in-update-joins.md) |
| #59869 | open | type/enhancement | 0 | [issue-59869-unionall-should-be-able-to-reserve-the-order-property-comming-from-its-children.md](./issue-59869-unionall-should-be-able-to-reserve-the-order-property-comming-from-its-children.md) |
| #59759 | closed | type/bug | 7 | [issue-59759-data-too-long-field-len-x-error-when-loading-stats-for-a-bit-column.md](./issue-59759-data-too-long-field-len-x-error-when-loading-stats-for-a-bit-column.md) |
| #59652 | open | type/enhancement | 4 | [issue-59652-rewrite-exprs-like-a-10-or-a-20-or-a-30-to-a-in-10-20-30-for-better-expr-evaluat.md](./issue-59652-rewrite-exprs-like-a-10-or-a-20-or-a-30-to-a-in-10-20-30-for-better-expr-evaluat.md) |
| #59560 | closed | type/bug | 7 | [issue-59560-memory-leak-risk-in-session-pool-usage-in-stats-sync-load.md](./issue-59560-memory-leak-risk-in-session-pool-usage-in-stats-sync-load.md) |
| #59524 | closed | type/bug | 8 | [issue-59524-release-the-internal-session-which-may-meet-error-like-54022.md](./issue-59524-release-the-internal-session-which-may-meet-error-like-54022.md) |
| #59427 | closed | type/bug | 3 | [issue-59427-comments-style-optimizer-hints-can-t-work-for-point-get-plan-sometimes.md](./issue-59427-comments-style-optimizer-hints-can-t-work-for-point-get-plan-sometimes.md) |
| #59406 | open | type/bug | 0 | [issue-59406-invalid-setting-for-the-variable-tidb-record-plan-in-slow-log-and-the-config-rec.md](./issue-59406-invalid-setting-for-the-variable-tidb-record-plan-in-slow-log-and-the-config-rec.md) |
| #59211 | closed | type/bug | 8 | [issue-59211-new-only-full-group-by-mode-can-not-tell-special-union-all-case.md](./issue-59211-new-only-full-group-by-mode-can-not-tell-special-union-all-case.md) |
| #58371 | open | type/bug | 0 | [issue-58371-inaccurate-estimated-rows-in-mixed-cnf-and-dnf-conditions.md](./issue-58371-inaccurate-estimated-rows-in-mixed-cnf-and-dnf-conditions.md) |
| #58284 | closed | type/bug | 4 | [issue-58284-cannot-get-right-max-table-id-when-to-init-stats.md](./issue-58284-cannot-get-right-max-table-id-when-to-init-stats.md) |
| #58016 | closed | type/bug | 5 | [issue-58016-planner-tidb-server-can-t-start-due-to-loading-binding-panic.md](./issue-58016-planner-tidb-server-can-t-start-due-to-loading-binding-panic.md) |
| #57992 | open | type/bug | 0 | [issue-57992-planner-the-global-binding-is-not-working-when-using-prepared-statement-with-sel.md](./issue-57992-planner-the-global-binding-is-not-working-when-using-prepared-statement-with-sel.md) |
| #57991 | open | type/enhancement | 0 | [issue-57991-planner-the-estimation-results-of-same-predicate-on-different-index-statistics-a.md](./issue-57991-planner-the-estimation-results-of-same-predicate-on-different-index-statistics-a.md) |
| #57975 | open | type/enhancement | 1 | [issue-57975-planner-assumed-data-distribution-of-out-of-range-estimation-might-not-be-correc.md](./issue-57975-planner-assumed-data-distribution-of-out-of-range-estimation-might-not-be-correc.md) |
| #57948 | open | type/feature-request | 6 | [issue-57948-update-table-statistics-before-publishing-new-schema-version-after-ddl.md](./issue-57948-update-table-statistics-before-publishing-new-schema-version-after-ddl.md) |
| #57631 | closed | type/bug | 5 | [issue-57631-analyze-is-too-slow-when-run-dml-in-million-tables-scenario.md](./issue-57631-analyze-is-too-slow-when-run-dml-in-million-tables-scenario.md) |
| #57544 | closed | type/bug | 4 | [issue-57544-sync-load-cannot-load-common-column-when-to-concurrently-init-stats.md](./issue-57544-sync-load-cannot-load-common-column-when-to-concurrently-init-stats.md) |
| #57427 | open | type/bug | 0 | [issue-57427-error-8066-when-create-binding-for-select-statement-with-high-priority.md](./issue-57427-error-8066-when-create-binding-for-select-statement-with-high-priority.md) |
| #57090 | closed | type/bug | 2 | [issue-57090-optimizer-cannot-correctly-display-the-statistics-info-for-stored-generated-inde.md](./issue-57090-optimizer-cannot-correctly-display-the-statistics-info-for-stored-generated-inde.md) |
| #57085 | closed | type/bug | 2 | [issue-57085-planner-test-testcostmodelver2scanrowsize-tablescan-row-size-is-incorrect.md](./issue-57085-planner-test-testcostmodelver2scanrowsize-tablescan-row-size-is-incorrect.md) |
| #56741 | open | type/enhancement | 0 | [issue-56741-memory-sync-consistency-across-tidb-node-stats-bindings-for-example.md](./issue-56741-memory-sync-consistency-across-tidb-node-stats-bindings-for-example.md) |
| #56724 | open | type/enhancement | 0 | [issue-56724-use-toja-can-not-be-applied-to-a-named-query-block-leading-hint-can-not-be-appli.md](./issue-56724-use-toja-can-not-be-applied-to-a-named-query-block-leading-hint-can-not-be-appli.md) |
| #56683 | open | type/enhancement | 0 | [issue-56683-the-pushed-operator-should-scale-with-regions-index-lookup-will-issue-too-much-c.md](./issue-56683-the-pushed-operator-should-scale-with-regions-index-lookup-will-issue-too-much-c.md) |
| #56615 | open | type/enhancement | 1 | [issue-56615-wrong-original-sql-display-for-bindings.md](./issue-56615-wrong-original-sql-display-for-bindings.md) |
| #56603 | closed | type/bug | 7 | [issue-56603-parsing-cte-error-with-doesn-t-yet-support-order-by-limit-select-distinct-in-rec.md](./issue-56603-parsing-cte-error-with-doesn-t-yet-support-order-by-limit-select-distinct-in-rec.md) |
| #56480 | closed | type/bug | 4 | [issue-56480-tidb-throws-error-when-querying-zero-datetime-with-table-statistics.md](./issue-56480-tidb-throws-error-when-querying-zero-datetime-with-table-statistics.md) |
| #56217 | closed | type/bug | 5 | [issue-56217-read-from-storage-hint-doesn-t-effect-while-plan-choose-the-index-merge-plan.md](./issue-56217-read-from-storage-hint-doesn-t-effect-while-plan-choose-the-index-merge-plan.md) |
| #55807 | open | type/enhancement | 0 | [issue-55807-planner-doesn-t-rewrite-conflict-expressions-to-dual-in-utf8mb4-general-ci-colla.md](./issue-55807-planner-doesn-t-rewrite-conflict-expressions-to-dual-in-utf8mb4-general-ci-colla.md) |
| #55803 | closed | type/bug | 5 | [issue-55803-query-results-of-information-schema-tables-not-accurate.md](./issue-55803-query-results-of-information-schema-tables-not-accurate.md) |
| #55551 | closed | type/bug | 6 | [issue-55551-cte-hang-or-result-wrong-when-multiple-apply-is-used.md](./issue-55551-cte-hang-or-result-wrong-when-multiple-apply-is-used.md) |
| #55191 | closed | type/bug | 0 | [issue-55191-with-the-same-sql-the-results-on-v6-5-are-inconsistent-with-the-results-on-v7-5-.md](./issue-55191-with-the-same-sql-the-results-on-v6-5-are-inconsistent-with-the-results-on-v7-5-.md) |
| #55126 | closed | type/bug | 13 | [issue-55126-planner-tot-col-size-in-mysql-stats-histograms-might-be-a-negative-number.md](./issue-55126-planner-tot-col-size-in-mysql-stats-histograms-might-be-a-negative-number.md) |
| #54968 | open | type/bug | 1 | [issue-54968-tidb-enforce-mpp-doesn-t-work-when-keep-order-is-true-for-table-scan.md](./issue-54968-tidb-enforce-mpp-doesn-t-work-when-keep-order-is-true-for-table-scan.md) |
| #54870 | closed | type/bug | 7 | [issue-54870-planner-can-t-push-down-predicates-with-generated-columns-down-through-unionscan.md](./issue-54870-planner-can-t-push-down-predicates-with-generated-columns-down-through-unionscan.md) |
| #54812 | closed | type/enhancement | 1 | [issue-54812-planner-ndv-scaling-estimation-formula-is-too-naive.md](./issue-54812-planner-ndv-scaling-estimation-formula-is-too-naive.md) |
| #54652 | closed | type/bug | 12 | [issue-54652-planner-txn-select-for-update-using-plan-cache-can-not-lock-data-correctly-in-so.md](./issue-54652-planner-txn-select-for-update-using-plan-cache-can-not-lock-data-correctly-in-so.md) |
| #54454 | open | type/enhancement | 0 | [issue-54454-optimal-range-is-not-built-for-a-b-in-1-1-2-2-and-c-10-and-c-50-on-b-c-index.md](./issue-54454-optimal-range-is-not-built-for-a-b-in-1-1-2-2-and-c-10-and-c-50-on-b-c-index.md) |
| #54213 | closed | type/bug | 7 | [issue-54213-optimizer-access-table-unnecessarily.md](./issue-54213-optimizer-access-table-unnecessarily.md) |
| #54188 | closed | type/enhancement | 4 | [issue-54188-optimizer-does-not-consider-using-ordered-index-scan-when-is-null-is-used.md](./issue-54188-optimizer-does-not-consider-using-ordered-index-scan-when-is-null-is-used.md) |
| #54125 | open | type/enhancement | 0 | [issue-54125-join-reorder-using-greedy-algorithm-use-wrong-rule-for-the-cost-of-limit-operato.md](./issue-54125-join-reorder-using-greedy-algorithm-use-wrong-rule-for-the-cost-of-limit-operato.md) |
| #54064 | closed | type/bug | 5 | [issue-54064-indexmergejoin-get-different-result-when-using-different-charset.md](./issue-54064-indexmergejoin-get-different-result-when-using-different-charset.md) |
| #54022 | closed | type/bug | 8 | [issue-54022-tidb-memory-leak-after-meets-the-fail-to-get-stats-version-for-this-histogram.md](./issue-54022-tidb-memory-leak-after-meets-the-fail-to-get-stats-version-for-this-histogram.md) |
| #53951 | closed | type/bug | 10 | [issue-53951-projection-containing-virtual-columns-should-be-evaluated-before-the-unionscan-d.md](./issue-53951-projection-containing-virtual-columns-should-be-evaluated-before-the-unionscan-d.md) |
| #53834 | closed | type/bug | 11 | [issue-53834-memory-quota-hint-doesn-t-work-well-with-global-binding.md](./issue-53834-memory-quota-hint-doesn-t-work-well-with-global-binding.md) |
| #53652 | closed | type/bug | 5 | [issue-53652-a-new-table-with-fk-will-not-create-stats-meta-by-ddl-event.md](./issue-53652-a-new-table-with-fk-will-not-create-stats-meta-by-ddl-event.md) |
| #53387 | closed | type/bug | 1 | [issue-53387-outer-join-reorder-will-produce-unexpected-join-sequence.md](./issue-53387-outer-join-reorder-will-produce-unexpected-join-sequence.md) |
| #53236 | closed | type/bug | 5 | [issue-53236-failed-to-execute-sql-but-succeed-in-mysql-v8-0.md](./issue-53236-failed-to-execute-sql-but-succeed-in-mysql-v8-0.md) |
| #52831 | open | type/enhancement | 2 | [issue-52831-tracker-for-sync-load.md](./issue-52831-tracker-for-sync-load.md) |
| #52826 | open | type/enhancement | 0 | [issue-52826-recordhistoricalstatstostorage-used-too-much-memory.md](./issue-52826-recordhistoricalstatstostorage-used-too-much-memory.md) |
| #52813 | closed | type/bug | 2 | [issue-52813-no-join-related-hints-don-t-work-in-sql-binding.md](./issue-52813-no-join-related-hints-don-t-work-in-sql-binding.md) |
| #52789 | open | type/enhancement | 0 | [issue-52789-leading-hint-cannot-take-effect-when-the-subquery-is-the-result-of-joins.md](./issue-52789-leading-hint-cannot-take-effect-when-the-subquery-is-the-result-of-joins.md) |
| #52772 | closed | type/bug | 4 | [issue-52772-tidb-panic-when-new-collation-is-disabled-and-two-expressions-use-different-coll.md](./issue-52772-tidb-panic-when-new-collation-is-disabled-and-two-expressions-use-different-coll.md) |
| #52653 | closed | type/bug | 2 | [issue-52653-unexpected-can-t-find-column-error-for-query-with-expression-index.md](./issue-52653-unexpected-can-t-find-column-error-for-query-with-expression-index.md) |
| #52650 | open | type/enhancement | 0 | [issue-52650-correlated-subquery-will-block-the-join-reorder-and-the-correlated-subquery-shou.md](./issue-52650-correlated-subquery-will-block-the-join-reorder-and-the-correlated-subquery-shou.md) |
| #52601 | closed | type/bug | 6 | [issue-52601-negative-waitgroup-counter-during-the-analyze-cause-tidb-is-killed.md](./issue-52601-negative-waitgroup-counter-during-the-analyze-cause-tidb-is-killed.md) |
| #52294 | closed | type/bug | 6 | [issue-52294-wrong-singleflight-implementation-for-stats-syncload.md](./issue-52294-wrong-singleflight-implementation-for-stats-syncload.md) |
| #52036 | open | type/enhancement | 1 | [issue-52036-tidb-opt-ordering-index-selectivity-threshold-should-also-be-valid-for-clustered.md](./issue-52036-tidb-opt-ordering-index-selectivity-threshold-should-also-be-valid-for-clustered.md) |
| #51873 | closed | type/bug | 5 | [issue-51873-inconsistent-query-result-after-changing-the-order-of-cte-statements.md](./issue-51873-inconsistent-query-result-after-changing-the-order-of-cte-statements.md) |
| #51700 | closed | type/bug | 4 | [issue-51700-planner-constant-propagation-supports-sub-queries-in-update-statements.md](./issue-51700-planner-constant-propagation-supports-sub-queries-in-update-statements.md) |
| #51384 | open | type/enhancement | 0 | [issue-51384-join-order-hints-don-t-work-due-to-left-condition-on-left-join-conditions.md](./issue-51384-join-order-hints-don-t-work-due-to-left-condition-on-left-join-conditions.md) |
| #51379 | open | type/enhancement | 0 | [issue-51379-planner-large-cardinality-estimation-error-for-indexjoin-with-indexlookup-when-j.md](./issue-51379-planner-large-cardinality-estimation-error-for-indexjoin-with-indexlookup-when-j.md) |
| #51362 | closed | type/bug | 5 | [issue-51362-planner-invalid-agg-mode-on-mpp-plans-with-sub-queries-accessing-partitioning-ta.md](./issue-51362-planner-invalid-agg-mode-on-mpp-plans-with-sub-queries-accessing-partitioning-ta.md) |
| #51358 | closed | type/bug | 2 | [issue-51358-panic-when-to-disable-lite-init-stats.md](./issue-51358-panic-when-to-disable-lite-init-stats.md) |
| #51116 | closed | type/unknown | 5 | [issue-51116-planner-the-optimizer-can-t-produce-an-optimal-plan-for-queries-with-sub-queries.md](./issue-51116-planner-the-optimizer-can-t-produce-an-optimal-plan-for-queries-with-sub-queries.md) |
| #51098 | open | type/enhancement | 1 | [issue-51098-wrong-estimated-row-count-for-tidb-rowid.md](./issue-51098-wrong-estimated-row-count-for-tidb-rowid.md) |
| #50507 | closed | type/bug | 2 | [issue-50507-planner-set-var-fix-control-is-incompatible-with-binding.md](./issue-50507-planner-set-var-fix-control-is-incompatible-with-binding.md) |
| #50080 | open | type/bug | 8 | [issue-50080-row-count-estimation-on-datetime-type-is-over-estimated-when-time-span-across-ye.md](./issue-50080-row-count-estimation-on-datetime-type-is-over-estimated-when-time-span-across-ye.md) |
| #50068 | closed | type/bug | 4 | [issue-50068-planner-set-var-cannot-take-effect-in-union-all-statements.md](./issue-50068-planner-set-var-cannot-take-effect-in-union-all-statements.md) |
| #50067 | closed | type/bug | 15 | [issue-50067-planner-leading-hint-cannot-take-effect-in-union-all-statements.md](./issue-50067-planner-leading-hint-cannot-take-effect-in-union-all-statements.md) |
| #50012 | closed | type/bug | 4 | [issue-50012-multi-statements-prefetchpointplankeys-panic.md](./issue-50012-multi-statements-prefetchpointplankeys-panic.md) |
| #49986 | closed | type/bug | 4 | [issue-49986-error-1105-hy000-runtime-error-index-out-of-range-0-with-length-0.md](./issue-49986-error-1105-hy000-runtime-error-index-out-of-range-0-with-length-0.md) |