Search results

Remove redundant LIMIT 1 to enable decorrelation of correlated scalar subqueries

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

Status: Open.

Bug

#64200 In pingcap/tidb;

· King-Dylan opened on Oct 30, 2025

Cascades Planner: Wrong query plan produced with <code>CTEFullScan</code>

severity/moderate

sig/plannerSIG: PlannerSIG: Planner

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

Status: Open.

#62700 In pingcap/tidb;

· King-Dylan opened on Jul 30, 2025

Cascades Planner: The children of partitionUnionAll will cause panic when add <code>addParentGEs</code>

impact/panic

may-affects-6.5

may-affects-7.1

may-affects-7.5

may-affects-8.1

may-affects-8.5

planner/cascadesissue/enhance/bug related to yamsissue/enhance/bug related to yams

severity/major

sig/plannerSIG: PlannerSIG: Planner

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

Status: Open.

#62440 In pingcap/tidb;

· King-Dylan opened on Jul 16, 2025

Planner: can't create a binding for TTL SQL

severity/moderate

sig/plannerSIG: PlannerSIG: Planner

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

Status: Open.

#62439 In pingcap/tidb;

· King-Dylan opened on Jul 16, 2025

runaway: Use AUTO_RANDOM for tidb_runaway_watch PK to avoid hotspot

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

Status: Open.

#62264 In pingcap/tidb;

· King-Dylan opened on Jul 7, 2025

Planner: AGG can be eliminated if the join key is unique and the aggregate function operates on the UK.

planner/cascadesissue/enhance/bug related to yamsissue/enhance/bug related to yams

sig/plannerSIG: PlannerSIG: Planner

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

Status: Open.

#61556 In pingcap/tidb;

· King-Dylan opened on Jun 6, 2025

planner: Unexpected estCost for the build side of an Index Join with different probe sides.

may-affects-6.1

may-affects-6.5

may-affects-7.1

may-affects-7.5

may-affects-8.1

may-affects-8.5

severity/major

sig/plannerSIG: PlannerSIG: Planner

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

Status: Open.

#60557 In pingcap/tidb;

· King-Dylan opened on Apr 14, 2025

[enhancement] Adding current indicator to Connection Count in the performance overview.

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

Status: Open.

#56101 In pingcap/tidb;

· King-Dylan opened on Sep 16, 2024

Memory tracker for mvmap

sig/executionSIG executionSIG execution

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

Status: Open.

#52593 In pingcap/tidb;

· King-Dylan opened on Apr 12, 2024

The batch on delete statement generates uneven job batch size.

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

Status: Open.

#47857 In pingcap/tidb;

· King-Dylan opened on Oct 20, 2023

collation_connection affects the passing of constants cause wrong query plan

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

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-7.5This bug affects the 7.5.x(LTS) versions.This bug affects the 7.5.x(LTS) versions.

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

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

found/gsfound by gsfound by gs

may-affects-5.3This bug maybe affects 5.3.x versions.This bug maybe affects 5.3.x versions.

may-affects-5.4This bug maybe affects 5.4.x versions.This bug maybe affects 5.4.x versions.

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.

#47629 In pingcap/tidb;

· King-Dylan opened on Oct 13, 2023

Need to improve the execution efficiency of the ifnull function.

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

Status: Open.

#47622 In pingcap/tidb;

· King-Dylan opened on Oct 13, 2023