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 batchPointGet in the prepare plan cache #27594

Closed
Reminiscent opened this issue Aug 26, 2021 · 4 comments
Closed

support batchPointGet in the prepare plan cache #27594

Reminiscent opened this issue Aug 26, 2021 · 4 comments
Assignees
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@Reminiscent
Copy link
Contributor

Enhancement

Related to issue#26873
Now we don't support batchPointGet plan in the prepare plan cache. You can check it through the following steps.

Enable prepared-plan-cache.

use test
drop table if exists t;
create table t(a int primary key, b int, c int);
prepare stmt from 'select * from t where a = 2 or a = ?';
set @p = 3;
execute stmt using @p;
select @@last_plan_from_cache;
execute stmt using @p;
select @@last_plan_from_cache;
@Reminiscent Reminiscent added the type/enhancement The issue or PR belongs to an enhancement. label Aug 26, 2021
@Reminiscent
Copy link
Contributor Author

/assign

@Reminiscent
Copy link
Contributor Author

Now the prepare plan cache can support the BatchPointGet. So I close the issue.

@Reminiscent
Copy link
Contributor Author

/close

@ti-chi-bot
Copy link
Member

@Reminiscent: Closing this issue.

In response to this:

/close

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the kubernetes/test-infra repository.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Development

No branches or pull requests

2 participants