Search results

planner: large estimation error of probe-side of IndexJoin when table filter selectivity is extremely low

epic/cardinality-estimationthe optimizer cardinality estimationthe optimizer cardinality estimation

sig/plannerSIG: PlannerSIG: Planner

type/enhancementThe issue or PR belongs to an enhancement.The issue or PR belongs to an enhancement.

Status: Open.

#64217 In pingcap/tidb;

· qw4990 opened on Oct 31, 2025

planner, executor: support unique Limit operator

plan-rewrite

sig/executionSIG executionSIG execution

sig/plannerSIG: PlannerSIG: Planner

type/enhancementThe issue or PR belongs to an enhancement.The issue or PR belongs to an enhancement.

Status: Open.

#63850 In pingcap/tidb;

· qw4990 opened on Oct 7, 2025

planner: large estimation error for queries with large IN list in some cases

epic/cardinality-estimationthe optimizer cardinality estimationthe optimizer cardinality estimation

sig/plannerSIG: PlannerSIG: Planner

type/enhancementThe issue or PR belongs to an enhancement.The issue or PR belongs to an enhancement.

Status: Open.

#63550 In pingcap/tidb;

· qw4990 opened on Sep 17, 2025

planner: consider seek operation cost on the optimizer cost model

epic/cost-modelthe optimizer cost modelthe optimizer cost model

sig/plannerSIG: PlannerSIG: Planner

type/enhancementThe issue or PR belongs to an enhancement.The issue or PR belongs to an enhancement.

Status: Open.

#63487 In pingcap/tidb;

· qw4990 opened on Sep 12, 2025

planner: expand the DNF expression to construct precise scan ranges

plan-rewrite

report/customerCustomers have encountered this bug.Customers have encountered this bug.

sig/plannerSIG: PlannerSIG: Planner

type/enhancementThe issue or PR belongs to an enhancement.The issue or PR belongs to an enhancement.

Status: Open.

#63417 In pingcap/tidb;

· qw4990 opened on Sep 9, 2025

binding: <code>create binding from {plan_digest}</code> can't distinguish different plans with same digest but different schema

component/bindinfo

may-affects-6.5

may-affects-7.1

may-affects-7.5

may-affects-8.1

may-affects-8.5

report/customerCustomers have encountered this bug.Customers have encountered this bug.

severity/major

sig/plannerSIG: PlannerSIG: Planner

type/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.

Status: Open.

#63410 In pingcap/tidb;

· qw4990 opened on Sep 8, 2025

planner: a new risk-aware index selection heuristic rule for IndexLookup in skyline pruning

affects-8.5This bug affects the 8.5.x(LTS) versions.This bug affects the 8.5.x(LTS) versions.

report/customerCustomers have encountered this bug.Customers have encountered this bug.

sig/plannerSIG: PlannerSIG: Planner

type/enhancementThe issue or PR belongs to an enhancement.The issue or PR belongs to an enhancement.

Status: Open.

#63336 In pingcap/tidb;

· qw4990 opened on Sep 2, 2025

planner: utilize prefix of columns in order-limit clause to avoid full table scan in join queries

plan-rewrite

report/customerCustomers have encountered this bug.Customers have encountered this bug.

sig/plannerSIG: PlannerSIG: Planner

type/enhancementThe issue or PR belongs to an enhancement.The issue or PR belongs to an enhancement.

Status: Open.

#63280 In pingcap/tidb;

· qw4990 opened on Aug 29, 2025

planner: pretty used stats info in slow log

component/statistics

sig/plannerSIG: PlannerSIG: Planner

type/enhancementThe issue or PR belongs to an enhancement.The issue or PR belongs to an enhancement.

Status: Open.

#63206 In pingcap/tidb;

· qw4990 opened on Aug 26, 2025

planner: index predicates based on column prefix are not pushed down to index side if they can't be used to construct scan ranges

report/customerCustomers have encountered this bug.Customers have encountered this bug.

sig/plannerSIG: PlannerSIG: Planner

type/questionThe issue belongs to a question.The issue belongs to a question.

Status: Open.

#61990 In pingcap/tidb;

· qw4990 opened on Jun 25, 2025

planner: consider missing Index stats in <code>stats-healthy</code> (how to indicate missing index-stats?)

affects-8.5This bug affects the 8.5.x(LTS) versions.This bug affects the 8.5.x(LTS) versions.

component/statistics

sig/plannerSIG: PlannerSIG: Planner

type/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.

Status: Open.

#61632 In pingcap/tidb;

· qw4990 opened on Jun 10, 2025

planner: <code>straight_join()</code> hint can't work in CTE or subquery

component/spm

epic/hint

sig/plannerSIG: PlannerSIG: Planner

type/enhancementThe issue or PR belongs to an enhancement.The issue or PR belongs to an enhancement.

Status: Open.

#61573 In pingcap/tidb;

· qw4990 opened on Jun 8, 2025