-
Notifications
You must be signed in to change notification settings - Fork 5.9k
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
Dropping session binding affects global binding
affects-6.5
This bug affects the 6.5.x(LTS) versions.
epic/sql-plan-management
severity/minor
sig/planner
SIG: Planner
type/bug
The issue is confirmed as a bug.
wontfix
This issue will not be fixed.
#58883
opened Jan 13, 2025 by
yi888long
planner: the global binding is not working when using Prepared Statement with "select ... as col ... group by col"
affects-7.1
This bug affects the 7.1.x(LTS) versions.
affects-7.5
This bug affects the 7.5.x(LTS) versions.
affects-8.1
This bug affects the 8.1.x(LTS) versions.
epic/sql-plan-management
report/customer
Customers have encountered this bug.
severity/major
sig/planner
SIG: Planner
type/bug
The issue is confirmed as a bug.
#57992
opened Dec 4, 2024 by
qw4990
ERROR 8066 when create binding for select statement with high_priority
epic/sql-plan-management
report/customer
Customers have encountered this bug.
severity/moderate
sig/planner
SIG: Planner
type/bug
The issue is confirmed as a bug.
#57427
opened Nov 15, 2024 by
pcqz
leading
hint doesn't work with cartesian join + outer join
affects-6.5
#56513
opened Oct 9, 2024 by
time-and-fate
LEADING hint cannot take effect when the subquery is the result of joins.
affects-7.1
This bug affects the 7.1.x(LTS) versions.
affects-7.5
This bug affects the 7.5.x(LTS) versions.
affects-8.1
This bug affects the 8.1.x(LTS) versions.
affects-8.5
This bug affects the 8.5.x(LTS) versions.
epic/hint
epic/sql-plan-management
report/customer
Customers have encountered this bug.
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#52789
opened Apr 22, 2024 by
winoros
SQL bindings are not reload automatically after restore mysql.bind_info
epic/sql-plan-management
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#46528
opened Aug 30, 2023 by
benmaoer
planner: throw error when create not supported binding from history (#39637)
do-not-merge/cherry-pick-not-approved
epic/sql-plan-management
needs-rebase
Indicates a PR cannot be merged because it has merge conflicts with HEAD.
release-note-none
Denotes a PR that doesn't merit a release note.
sig/planner
SIG: Planner
size/L
Denotes a PR that changes 100-499 lines, ignoring generated files.
status/LGT2
Indicates that a PR has LGTM 2.
type/cherry-pick-for-release-6.5
This PR is cherry-picked to release-6.5 from a source PR.
#39658
opened Dec 6, 2022 by
ti-chi-bot
Loading…
1 of 12 tasks
Add more logs to record the operation for binding
epic/sql-plan-management
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#37010
opened Aug 10, 2022 by
Reminiscent
Optimize the usage of the bind cache
epic/sql-plan-management
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#32466
opened Feb 18, 2022 by
Reminiscent
4 tasks
May not need default_db column for mysql.bind_info
epic/sql-plan-management
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#29607
opened Nov 9, 2021 by
Reminiscent
Add id column to table SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
mysql.bind_info
so that we can query or delete by id
epic/sql-plan-management
sig/planner
#27736
opened Sep 1, 2021 by
yuqi1129
SPM: the update time is inconsistent with the time zone
epic/sql-plan-management
severity/moderate
sig/planner
SIG: Planner
type/bug
The issue is confirmed as a bug.
#27641
opened Aug 27, 2021 by
ChenPeng2013
Tracking issue for SPM enhancement
epic/sql-plan-management
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#25970
opened Jul 5, 2021 by
eurekaka
9 of 12 tasks
SPM: create binding failed
epic/sql-plan-management
severity/minor
sig/planner
SIG: Planner
type/bug
The issue is confirmed as a bug.
#21454
opened Dec 3, 2020 by
ChenPeng2013
SQL Plan Management 3.0: improve the usability
epic/sql-plan-management
feature/accepted
This feature request is accepted by product managers
priority/P0
The issue has P0 priority.
sig/planner
SIG: Planner
type/feature-request
Categorizes issue or PR as related to a new feature.
show grants
statement should contain the privilege informations for create bindings
component/bindinfo
component/privilege
epic/sql-plan-management
feature/accepted
#16749
opened Apr 23, 2020 by
lzmhhh123
show bindings
returns session bindings and global bindings
component/bindinfo
epic/sql-plan-management
feature/accepted
#16747
opened Apr 23, 2020 by
lzmhhh123
stop checking if the generated plan is in bindings once we partition baselines based on selectivity
component/bindinfo
epic/sql-plan-management
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#15911
opened Mar 31, 2020 by
eurekaka
resolve equivalent join hints like SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
TIDB_INLJ
and INL_JOIN
when building ID
of bindings
component/bindinfo
epic/sql-plan-management
sig/planner
#15910
opened Mar 31, 2020 by
eurekaka
resolve SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
use index
/ ignore index
and use_index()
/ ignore_index()
when building ID
of bindings
component/bindinfo
epic/sql-plan-management
sig/planner
#15909
opened Mar 31, 2020 by
eurekaka
Ban the written authority for Violation of forwards/backwards compatibility in a design-time piece.
component/bindinfo
epic/sql-plan-management
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
mysql.bind_info
compatibility-breaker
#15660
opened Mar 25, 2020 by
lzmhhh123
draft a proposal about how to support different plan for different parameters in SPM
epic/sql-plan-management
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
#15074
opened Mar 2, 2020 by
zz-jason
UCP: Use the fingerprint of the SQL to bind the plan in SQL Plan Management
epic/sql-plan-management
sig/planner
SIG: Planner
type/usability
#14987
opened Feb 28, 2020 by
winoros
ProTip!
Mix and match filters to narrow down what you’re looking for.