Search results

Enhance the cost estimation of Sort operator

affects-4.0This bug affects 4.0.x versions.This bug affects 4.0.x versions.

affects-5.0This bug affects 5.0.x versions.This bug affects 5.0.x versions.

affects-5.1This bug affects 5.1.x versions.This bug affects 5.1.x versions.

affects-5.2This bug affects 5.2.x versions.This bug affects 5.2.x versions.

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

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

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.

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.

#44597 In pingcap/tidb;

· xuyifangreeneyes opened on Jun 12, 2023

lightning: confusing log of conflict error

affects-5.2This bug affects 5.2.x versions.This bug affects 5.2.x versions.

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

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

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.

component/lightningThis issue is related to Lightning of TiDB.This issue is related to Lightning of TiDB.

severity/minor

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

Status: Open.

#42816 In pingcap/tidb;

· sleepymole opened on Apr 4, 2023

executor, types: ON DUPLICATE UPDATE with bit convert to LittleEndian

affects-4.0This bug affects 4.0.x versions.This bug affects 4.0.x versions.

affects-5.0This bug affects 5.0.x versions.This bug affects 5.0.x versions.

affects-5.1This bug affects 5.1.x versions.This bug affects 5.1.x versions.

affects-5.2This bug affects 5.2.x versions.This bug affects 5.2.x versions.

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

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

affects-6.0

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

affects-6.2

affects-6.3

affects-6.4

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

affects-6.6

affects-7.0

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.

severity/major

sig/executionSIG executionSIG execution

Status: Open.

#40653 In pingcap/tidb;

· felixYing opened on Jan 17, 2023

execution: wrong result when comparing float values in some cases

affects-5.0This bug affects 5.0.x versions.This bug affects 5.0.x versions.

affects-5.1This bug affects 5.1.x versions.This bug affects 5.1.x versions.

affects-5.2This bug affects 5.2.x versions.This bug affects 5.2.x versions.

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

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

affects-6.0

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

affects-6.2

affects-6.3

affects-6.4

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

affects-6.6

affects-7.0

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.

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

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

may-affects-6.1

may-affects-6.5

Status: Open.

#40488 In pingcap/tidb;

· qw4990 opened on Jan 11, 2023

Logical bug: result lost after relaxing comparison condition [v3.0.12, v6.4.0]

affects-5.0This bug affects 5.0.x versions.This bug affects 5.0.x versions.

affects-5.1This bug affects 5.1.x versions.This bug affects 5.1.x versions.

affects-5.2This bug affects 5.2.x versions.This bug affects 5.2.x versions.

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

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

affects-6.0

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

affects-6.2

affects-6.3

affects-6.4

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

affects-6.6

affects-7.0

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.

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

severity/major

sig/plannerSIG: PlannerSIG: Planner

Status: Open.

#40018 In pingcap/tidb;

· qaqcatz opened on Dec 18, 2022

Logical bug: result lost after relaxing comparison condition [v4.0.11, v6.4.0]

affects-5.0This bug affects 5.0.x versions.This bug affects 5.0.x versions.

affects-5.1This bug affects 5.1.x versions.This bug affects 5.1.x versions.

affects-5.2This bug affects 5.2.x versions.This bug affects 5.2.x versions.

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

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

affects-6.0

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

affects-6.2

affects-6.3

affects-6.4

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

affects-6.6

affects-7.0

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.

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

severity/major

sig/executionSIG executionSIG execution

Status: Open.

#40016 In pingcap/tidb;

· qaqcatz opened on Dec 18, 2022

TiDB optimizer didn't choose the best index

affects-5.0This bug affects 5.0.x versions.This bug affects 5.0.x versions.

affects-5.1This bug affects 5.1.x versions.This bug affects 5.1.x versions.

affects-5.2This bug affects 5.2.x versions.This bug affects 5.2.x versions.

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

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

affects-6.0

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

affects-6.2

affects-6.3

affects-6.4

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

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

sig/plannerSIG: PlannerSIG: Planner

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

Status: Open.

#39410 In pingcap/tidb;

· xingyong opened on Nov 28, 2022

TIMESTAMPADD does not return correct data type when parameter is DateTime type

affects-5.0This bug affects 5.0.x versions.This bug affects 5.0.x versions.

affects-5.1This bug affects 5.1.x versions.This bug affects 5.1.x versions.

affects-5.2This bug affects 5.2.x versions.This bug affects 5.2.x versions.

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

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

affects-6.0

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

affects-6.2

affects-6.3

affects-6.4

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

affects-6.6

affects-7.0

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.

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

severity/major

sig/executionSIG executionSIG execution

Status: Open.

#39213 In pingcap/tidb;

· birdstorm opened on Nov 17, 2022

Date value change caused by the combination of (JOIN,LIKE,BIN,DATE_SUB)

affects-5.0This bug affects 5.0.x versions.This bug affects 5.0.x versions.

affects-5.1This bug affects 5.1.x versions.This bug affects 5.1.x versions.

affects-5.2This bug affects 5.2.x versions.This bug affects 5.2.x versions.

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

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

affects-6.0

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

affects-6.2

affects-6.3

affects-6.4

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

affects-6.6

affects-7.0

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.

severity/major

sig/executionSIG executionSIG execution

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

Status: Open.

#38747 In pingcap/tidb;

· qaqcatz opened on Oct 30, 2022

Unexpected Estimated Rows by INNER JOIN

affects-5.1This bug affects 5.1.x versions.This bug affects 5.1.x versions.

affects-5.2This bug affects 5.2.x versions.This bug affects 5.2.x versions.

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

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

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

fuzz/sqlancer

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

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

may-affects-6.0

may-affects-6.2

may-affects-6.3

severity/minor

sig/plannerSIG: PlannerSIG: Planner

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

Status: Open.

#38665 In pingcap/tidb;

· bajinsheng opened on Oct 26, 2022

Join's cost calculation during join reorder mismatches the real physical cost of index join

affects-4.0This bug affects 4.0.x versions.This bug affects 4.0.x versions.

affects-5.0This bug affects 5.0.x versions.This bug affects 5.0.x versions.

affects-5.1This bug affects 5.1.x versions.This bug affects 5.1.x versions.

affects-5.2This bug affects 5.2.x versions.This bug affects 5.2.x versions.

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

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

affects-6.0

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

affects-6.2

affects-6.3

affects-6.4

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.

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

severity/moderate

sig/plannerSIG: PlannerSIG: Planner

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

Status: Open.

#38660 In pingcap/tidb;

· Yisaer opened on Oct 26, 2022

TiDB produces different results for SELECT statements (runtime error: index out of range [0] with length 0)

affects-5.1This bug affects 5.1.x versions.This bug affects 5.1.x versions.

affects-5.2This bug affects 5.2.x versions.This bug affects 5.2.x versions.

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

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

affects-6.0

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

affects-6.2

affects-6.3

affects-6.4

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

affects-6.6

affects-7.0

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.

severity/major

sig/executionSIG executionSIG execution

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

Status: Open.

#38209 In pingcap/tidb;

· JZuming opened on Sep 27, 2022