Yuanjia Zhang comments

Results 106 comments of


                                            Yuanjia Zhang

The Plan of TPCH Q3 changes without any data update leading to 13s performance regression

This issue can be solved by Cost Model Ver2.

Selection on merge join could not find column

Fixed by https://github.com/pingcap/tidb/pull/37992

Output is different from mysql where clause used in with dual table

A minimum reproducible case: ``` mysql> select * from dual; ERROR 1051 (42S02): Unknown table '' ``` The reason is that `dual` is a virtual table that has no column,...

Can’t find a proper physical plan for this query when using TiFlash with explicit transaction

Duplicated with https://github.com/pingcap/tidb/issues/51360

incorrect row estimation in having clause

@time-and-fate Please help take a look at this issue

planner: check whether plan-cache is disabled each time when getting plan from the plan cache (#49373)

/retest

planner: check whether plan-cache is disabled each time when getting plan from the plan cache (#49373)

/test mysql-test

planner: check whether plan-cache is disabled each time when getting plan from the plan cache (#49373)

/test mysql-test

Revert "planner: remove the useless variable tidb_enable_point_get_cache"

/retest

server: fix decode issue for prefetch point plan index keys (#50037)

/retest