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.

Sign up for GitHub

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

Jump to bottom

Replace all values inside of IN() lists #42

Closed
debeando opened this issue Sep 5, 2018 · 0 comments
Closed

Replace all values inside of IN() lists #42

debeando opened this issue Sep 5, 2018 · 0 comments
Labels
enhancement New feature or request

Comments

@debeando
Copy link
Collaborator

debeando commented Sep 5, 2018 •
edited

To follow the same fingerprint to pt-query-digest. Replace all literals inside of IN() lists with a single placeholder, regardless of cardinality.

Related issues: #37

For example;

SELECT name FROM user WHERE id IN (?, ?, ?, ?, ?, ?);

To:

SELECT name FROM user WHERE id IN (?);
@debeando debeando changed the title Replace all literals inside of IN() and VALUES() lists with a single placeholder Replace all literals inside of IN() and VALUES() lists Sep 5, 2018
@debeando debeando added the enhancement New feature or request label Sep 5, 2018
@debeando debeando self-assigned this Sep 5, 2018
@debeando debeando changed the title Replace all literals inside of IN() and VALUES() lists Replace all values inside of IN() and VALUES() lists Sep 5, 2018
@debeando debeando mentioned this issue Sep 5, 2018
Open
@debeando debeando changed the title Replace all values inside of IN() and VALUES() lists Replace all values inside of IN() lists Sep 6, 2018
@debeando debeando closed this as completed Sep 6, 2018
@debeando debeando removed their assignment Sep 29, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
0 participants