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: 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

A small table with high modify count without table analyze, missing the est rows in plan

component/statistics

epic/cardinality-estimationthe optimizer cardinality estimationthe optimizer cardinality estimation

sig/plannerSIG: PlannerSIG: Planner

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

Status: Open.

#62924 In pingcap/tidb;

· elsa0520 opened on Aug 11, 2025

same predicate estimation of two approximate stats is quite different

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

component/statistics

epic/cardinality-estimationthe optimizer cardinality estimationthe optimizer cardinality estimation

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.

#62766 In pingcap/tidb;

· AilinKid opened on Aug 1, 2025

Redundant expressions containing user parameters on irrelevant columns interfere with estimation on other columns in PREPARE/EXECUTE now

epic/cardinality-estimationthe optimizer cardinality estimationthe optimizer cardinality estimation

epic/plan-cache

sig/plannerSIG: PlannerSIG: Planner

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

Status: Open.

#59140 In pingcap/tidb;

· time-and-fate opened on Jan 23, 2025

planner: the estimation results of same predicate on different index statistics are not consistent

epic/cardinality-estimationthe optimizer cardinality estimationthe optimizer cardinality estimation

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.

#57991 In pingcap/tidb;

· qw4990 opened on Dec 4, 2024

planner: assumed data distribution of out-of-range estimation might not be correct in some cases

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

epic/cardinality-estimationthe optimizer cardinality estimationthe optimizer cardinality estimation

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.

#57975 In pingcap/tidb;

· qw4990 opened on Dec 4, 2024

point query on unique index will make estimation row count inconsistent

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

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

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

epic/cardinality-estimationthe optimizer cardinality estimationthe optimizer cardinality estimation

severity/moderate

sig/plannerSIG: PlannerSIG: Planner

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

Status: Open.

#55569 In pingcap/tidb;

· winoros opened on Aug 21, 2024

join reorder using greedy algorithm use wrong rule for the cost of limit operator

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

epic/cardinality-estimationthe optimizer cardinality estimationthe optimizer cardinality estimation

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.

#54125 In pingcap/tidb;

· tiancaiamao opened on Jun 19, 2024

Planner should consider specified partition when caculate <code>estRows</code>

component/tablepartitionThis issue is related to Table Partition of TiDB.This issue is related to Table Partition of TiDB.

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.

#53657 In pingcap/tidb;

· Defined2014 opened on May 29, 2024

planner: large cardinality estimation error for IndexJoin with IndexLookup when join estimation closes to zero

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

epic/cardinality-estimationthe optimizer cardinality estimationthe optimizer cardinality estimation

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.

#51379 In pingcap/tidb;

· qw4990 opened on Feb 28, 2024

incorrect row estimation in having clause

epic/cardinality-estimationthe optimizer cardinality estimationthe optimizer cardinality estimation

fuzz/randomtest

severity/moderate

sig/plannerSIG: PlannerSIG: Planner

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

Status: Open.

#51280 In pingcap/tidb;

· wjhuang2016 opened on Feb 23, 2024