-
Notifications
You must be signed in to change notification settings - Fork 5.8k
Issues: pingcap/tidb
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Author
Label
Projects
Milestones
Assignee
Sort
Issues list
planner: can't push down predicates with generated columns down through UnionScan
type/bug
This issue is a bug.
#54870
opened Jul 24, 2024 by
qw4990
planner: NDV estimation formula is too naive
epic/cardinality-estimation
the optimizer cardinality estimation
sig/planner
SIG: Planner
type/enhancement
#54812
opened Jul 22, 2024 by
qw4990
planner: Plan Cache is not compatible with CTE
sig/planner
SIG: Planner
type/enhancement
#54130
opened Jun 20, 2024 by
qw4990
planner: instance/node level plan cache - phase 1
type/enhancement
#54057
opened Jun 17, 2024 by
qw4990
planner: plan cache can't support SQLs like "where pk_col1 = ? and pk_col2 = ? and pk_col3 in (1, 2, 3)"
sig/planner
SIG: Planner
type/enhancement
#53962
opened Jun 12, 2024 by
qw4990
planner: large cardinality estimation error for IndexJoin with IndexLookup when join estimation is zero
affects-8.1
epic/cardinality-estimation
the optimizer cardinality estimation
report/customer
Customers have encountered this bug.
sig/planner
SIG: Planner
type/enhancement
#51379
opened Feb 28, 2024 by
qw4990
planner: Plan Binding Enhancement
sig/planner
SIG: Planner
type/enhancement
#51347
opened Feb 27, 2024 by
qw4990
6 of 18 tasks
planner: the optimizer can't produce an optimal plan for queries with sub-queries in select list
sig/planner
SIG: Planner
type/enhancement
#51225
opened Feb 21, 2024 by
qw4990
planner: cannot choose the best predicate to build IndexRangeScan for correlated queries in some cases
sig/planner
SIG: Planner
type/enhancement
#51148
opened Feb 19, 2024 by
qw4990
planner: the optimizer can't produce an optimal plan for queries with sub-queries in select list since it always decorrelate sub-queries
affects-5.4
This bug affects 5.4.x versions.
affects-6.1
affects-6.5
affects-7.1
affects-7.5
report/customer
Customers have encountered this bug.
sig/planner
SIG: Planner
type/enhancement
#51116
opened Feb 18, 2024 by
qw4990
planner: track the time consumption of analyze correctly
component/statistics
sig/planner
SIG: Planner
type/enhancement
#51030
opened Feb 7, 2024 by
qw4990
planner: prevent the optimizer from using different versions of stats of a table during optimization
component/statistics
epic/cardinality-estimation
the optimizer cardinality estimation
sig/planner
SIG: Planner
type/enhancement
#50281
opened Jan 10, 2024 by
qw4990
planner: Projection operator leads to join order failure and leading hint cannot take effect
sig/planner
SIG: Planner
type/enhancement
#50229
opened Jan 9, 2024 by
qw4990
planner: large outer-join cardinality estimation error when there are multiple join keys
epic/cardinality-estimation
the optimizer cardinality estimation
found/gs
found by gs
sig/planner
SIG: Planner
type/enhancement
#49893
opened Dec 28, 2023 by
qw4990
planner: the cost model considers offload and cache-miss for TiDB serverless
epic/cost-model
the optimizer cost model
sig/planner
SIG: Planner
type/enhancement
#48780
opened Nov 22, 2023 by
qw4990
planner: utilize the order property of leading columns in index
sig/planner
SIG: Planner
type/enhancement
#48241
opened Nov 2, 2023 by
qw4990
planner: the optimizer cannot select the best IndexMerge plan automatically
sig/planner
SIG: Planner
type/enhancement
#48088
opened Oct 30, 2023 by
qw4990
planner: zero estimation result if all values are in TopN
epic/cardinality-estimation
the optimizer cardinality estimation
sig/planner
SIG: Planner
type/enhancement
#47400
opened Oct 5, 2023 by
qw4990
planner: support using IndexMerge to access MVIndex in more scenarios
sig/planner
SIG: Planner
type/enhancement
#46319
opened Aug 22, 2023 by
qw4990
planner: optimizer statistics cost too much amount of memory
component/statistics
sig/planner
SIG: Planner
type/enhancement
#46149
opened Aug 16, 2023 by
qw4990
planner: SIG: Planner
type/enhancement
type/performance
tidb_enable_new_only_full_group_by_check
cause plan-cache hit ratio regression on sysbench
affects-7.1
epic/plan-cache
sig/planner
#45519
opened Jul 24, 2023 by
qw4990
planner: cannot use SIG: Planner
type/enhancement
IndexJoin
due to implicit cast
sig/planner
#45182
opened Jul 5, 2023 by
qw4990
planner: 'regexp' cannot cache the pattern compile result if the pattern is a plan-cache parameter
component/expression
epic/plan-cache
sig/planner
SIG: Planner
type/enhancement
#45101
opened Jun 30, 2023 by
qw4990
planner: non-prep plan cache support negative numbers
epic/plan-cache
sig/planner
SIG: Planner
type/enhancement
#44977
opened Jun 27, 2023 by
qw4990
Previous Next
ProTip!
Add no:assignee to see everything that’s not assigned.