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

Values are duplicated in predicates table #232

Open

pgiraud opened this issue Nov 20, 2024 · 1 comment

Labels

bug

Member

pgiraud commented Nov 20, 2024

In the "Predicates used by this query" table in the "predicates" tab for a query overview, the values are duplicated (4 times in example below).

https://demo-powa.anayrat.info/server/1/database/obvious/query/-7556566112357940574/overview/?from=2024-11-19T00:00%2B01:00&to=2024-11-21T00:00%2B01:00

The corresponding XHR request looks like:
https://demo-powa.anayrat.info/server/1/metrics/database/obvious/query/-7556566112357940574/quals/?from=2024-11-19%2000%3A00%3A00%2B0100&to=2024-11-21%2000%3A00%3A00%2B0100

rjuju added the bug label

Member

rjuju commented Nov 21, 2024

I think it's at least missing the join condition on dbid and userid in https://github.com/powa-team/powa-web/blob/master/powa/sql/views.py#L100. Maybe there are some other problems, I will have to reproduce the problem locally to be able to really fix it.

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