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

sql: prepared statements follow-ups #4721

Open
4 tasks
Korablev77 opened this issue Jan 10, 2020 · 0 comments
Open
4 tasks

sql: prepared statements follow-ups #4721

Korablev77 opened this issue Jan 10, 2020 · 0 comments
Labels
feature A new functionality sql
Milestone

Comments

@Korablev77
Copy link
Contributor

  • Provide more sophisticated test cases covering multiple session interaction scenarios.

  • Copy VDBE for each session before execution. Now there's one object in the cache and if it is busy at the moment (i.e. it is executed by another session), execution of prepared statement results in prepare-and-execute procedure. It means that performance benefits from prepared statement may be neglected for statements accessed by several sessions.

  • Now after any DDL operation all prepared statements are considered to be expired (at the moment of statement preparation, schema version is saved within prepared statement object; then it is simply checked before execution with current one). Even if prepared statement has no references to changed by DDL operation entity. We need to invalidate only prepared statements related to the subject of DDL operation.

  • Provide an opportunity to specify types of parameters in :prepare() interface and check them before execution of prepared statement. Now type of binding parameters is always assumed to be ANY.

@Korablev77 Korablev77 added the sql label Jan 10, 2020
@kyukhin kyukhin added the feature A new functionality label Jan 14, 2020
@kyukhin kyukhin added this to the 2.4.1 milestone Jan 14, 2020
@kyukhin kyukhin modified the milestones: 2.4.1, 2.5.1 Mar 30, 2020
@kyukhin kyukhin modified the milestones: 2.5.1, 2.6.1 Apr 10, 2020
@kyukhin kyukhin modified the milestones: 2.6.1, wishlist Oct 23, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature A new functionality sql
Projects
None yet
Development

No branches or pull requests

2 participants