Skip to content
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

support create binding for update/delete/insert queries #15827

Closed
zz-jason opened this issue Mar 30, 2020 · 2 comments · Fixed by #20686
Closed

support create binding for update/delete/insert queries #15827

zz-jason opened this issue Mar 30, 2020 · 2 comments · Fixed by #20686
Assignees
Labels
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.
Milestone

Comments

@zz-jason
Copy link
Member

Feature Request

Is your feature request related to a problem? Please describe:

These statements also involves reading data from the storage sometimes. If the plan for them is not optimized, for now users can only modify their application code, add hints in their SQLs.

We need a way for users to workaround the sub-optimal plan issue without modifying their code. SQL Bind is the best choice.

Describe the feature you'd like:

We've supported hints for update/delete/insert queries. It's better to support <create|drop> [session|global] binding for these statements.

Describe alternatives you've considered:

N/A

Teachability, Documentation, Adoption, Migration Strategy:

N/A

@zz-jason zz-jason added sig/planner SIG: Planner type/feature-request Categorizes issue or PR as related to a new feature. labels Mar 30, 2020
@Reminiscent
Copy link
Contributor

/assign

@zz-jason zz-jason added this to the v5.0-alpha milestone Jun 15, 2020
@scsldb scsldb added the priority/P0 The issue has P0 priority. label Jun 15, 2020
@scsldb scsldb modified the milestones: v5.0.0-alpha, v5.0.0-beta.1 Jul 15, 2020
@zz-jason zz-jason added the feature/accepted This feature request is accepted by product managers label Jul 29, 2020
@tangwz
Copy link
Contributor

tangwz commented Sep 23, 2020

/assign

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
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.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants