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 SQL bind for Update / Delete statements #20640

Closed
eurekaka opened this issue Oct 26, 2020 · 1 comment
Closed

support SQL bind for Update / Delete statements #20640

eurekaka opened this issue Oct 26, 2020 · 1 comment
Assignees
Labels
epic/sql-plan-management sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.

Comments

@eurekaka
Copy link
Contributor

Development Task

Support features like:

create global binding for update t set a = 1 where b = 1 using update /*+ use_index(t,b) */ t set a = 1 where b = 1;
create global binding for update t1,t2 set t1.a = 1 where t1.b = t2.b using update /*+ INL_JOIN(t1) */ t1,t2 set t1.a = 1 where t1.b = t2.b;
create global binding for delete from t where a = 1 using delete /*+ use_index(t,a) */ from t where a = 1;
create global binding for delete /*+ hash_join(t1,t2), use_index(t1,c) */ t1, t2 from t1 inner join t2 on t1.b = t2.b where t1.c = 1;
@eurekaka
Copy link
Contributor Author

Duplicated with #15827.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
epic/sql-plan-management sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Development

No branches or pull requests

1 participant