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

Closed
iguberman opened this issue Dec 2, 2021 · 1 comment
Closed

UNION queries fail #99

iguberman opened this issue Dec 2, 2021 · 1 comment

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.

@cpjolicoeur
Copy link
Member

[fixed by #98]

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.

2 participants