-
Notifications
You must be signed in to change notification settings - Fork 6.2k
All issues
Issue creation is restricted in this repository
- #55231 · AilinKid opened
on Aug 6, 2024 17 - #41316 · hawkingrei opened
on Feb 12, 2023
Issues
is:issue state:open
is:issue state:open
Search results
planner: x BETWEEN y AND y and x >= y AND x <= y cause large performance regression due to missing equi-join extraction
contributionThis PR is from a community contributor.This PR is from a community contributor.sig/plannerSIG: PlannerSIG: Plannertype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.Status: Open.#69935 In pingcap/tidb;planner: NOT (x <> y) is not normalized to an equi-join key, causing a Cartesian join and about 247x slowdown
contributionThis PR is from a community contributor.This PR is from a community contributor.sig/plannerSIG: PlannerSIG: Plannertype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.Status: Open.#69933 In pingcap/tidb;planner: DISTINCT equality join expands duplicate matches instead of using an available Merge Semi Join
contributionThis PR is from a community contributor.This PR is from a community contributor.sig/plannerSIG: PlannerSIG: Plannertype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.Status: Open.#69932 In pingcap/tidb;statistics: ANALYZE shortly after committed bulk INSERT can publish incomplete statistics as healthy
contributionThis PR is from a community contributor.This PR is from a community contributor.sig/plannerSIG: PlannerSIG: Plannertype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.Status: Open.#69931 In pingcap/tidb;TiDB does not eliminate duplicate identical EXISTS predicates, causing repeated semi-join work
contributionThis PR is from a community contributor.This PR is from a community contributor.type/enhancementThe issue or PR belongs to an enhancement.The issue or PR belongs to an enhancement.Status: Open.#69930 In pingcap/tidb;bindinfo: skip SQL binding match for INSERT/REPLACE VALUES
sig/plannerSIG: PlannerSIG: Plannertype/enhancementThe issue or PR belongs to an enhancement.The issue or PR belongs to an enhancement.Status: Open.#69928 In pingcap/tidb;TiDB does not simplify
NOT NOTin aWHEREpredicate, preventingLEFT JOINright-side pruningcontributionThis PR is from a community contributor.This PR is from a community contributor.sig/plannerSIG: PlannerSIG: Plannertype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.Status: Open.#69927 In pingcap/tidb;TiDB does not simplify
NOT NOTaround anINsubquery, causing a large performance regressioncontributionThis PR is from a community contributor.This PR is from a community contributor.sig/plannerSIG: PlannerSIG: Plannertype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.Status: Open.#69926 In pingcap/tidb;TiDB does not eliminate duplicate
GROUP BYexpressions, causing a measurable slowdowncontributionThis PR is from a community contributor.This PR is from a community contributor.sig/plannerSIG: PlannerSIG: Plannertype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.Status: Open.#69925 In pingcap/tidb;- Status: Open.#69923 In pingcap/tidb;
planner: contradictory IS NULL and derived IS NOT NULL predicates are not folded to TableDual
contributionThis PR is from a community contributor.This PR is from a community contributor.sig/plannerSIG: PlannerSIG: Plannertype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.Status: Open.#69922 In pingcap/tidb;Flaky test: TestTableTimerStore in pkg/timer
type/enhancementThe issue or PR belongs to an enhancement.The issue or PR belongs to an enhancement.Status: Open.#69920 In pingcap/tidb;