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

Handle queries with const in the SELECT part #14

Open
rjuju opened this issue May 6, 2016 · 0 comments
Open

Handle queries with const in the SELECT part #14

rjuju opened this issue May 6, 2016 · 0 comments

Comments

@rjuju
Copy link
Member

rjuju commented May 6, 2016

a query like

SELECT round(i, 2) FROM generate_series(1,10) i

will result in this normalized query:

SELECT round(i, ?) FROM generate_series(?,?)i;

pg_qualstats doesn't track anything for the round(i, ?) part, leading to errors when trying to denormalize this query.

A fallback to the non normalized version (pg_qualstats.example_query(oid)) if available shoud be done.

If no fallback is possible, error shoud be handled (this is at least not the case in the wizard index check part).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant