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

UNION queries fail #99

Open
iguberman opened this issue Dec 2, 2021 · 0 comments · May be fixed by #100
Open

UNION queries fail #99

iguberman opened this issue Dec 2, 2021 · 0 comments · May be fixed by #100

Comments

@iguberman
Copy link

Repo.paginate(query, pagination_params) fails with the following error:

 ** (Postgrex.Error) ERROR 42601 (syntax_error) each UNION query must have the same number of columns
     
         query: SELECT count('*') FROM ....  (any UNION query here)

This happens to a large variety of UNION queries. I'll provide some examples if necessary but I don't think it matters what specific query, it's just UNION queries in general. Probably need similar aggregate treatment asgroup_bys

I'm submitting this issue while attempting a fix on my end in the meanwhile.

@iguberman iguberman linked a pull request Dec 8, 2021 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant