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鈥檒l occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

馃 functions after GROUP BY #320

Closed
joocer opened this issue Aug 3, 2022 · 3 comments
Closed

馃 functions after GROUP BY #320

joocer opened this issue Aug 3, 2022 · 3 comments
Labels
Bug 馃 Something isn't working

Comments

@joocer
Copy link
Contributor

joocer commented Aug 3, 2022 

SELECT name, HASH(name)
  FROM $planets
 GROUP BY name

Field HASH(name) does not exist.
@joocer joocer added the Bug 馃 Something isn't working label Aug 3, 2022
@joocer joocer self-assigned this Aug 3, 2022
@joocer
Copy link
Contributor Author

joocer commented Aug 5, 2022

This appears to be because the Evaluation step runs before the Aggregation step, and the Aggregation step removes everything not in the GROUP BY clause or an aggregation.

@joocer joocer removed their assignment Aug 6, 2022
@joocer joocer changed the title [BUG] functions after GROUP BY 馃 functions after GROUP BY Aug 16, 2022
@joocer
Copy link
Contributor Author

joocer commented Aug 17, 2022

This will likely be resolved as part of the changes for the Expression Engine #42

@joocer joocer added Next Release Planned for next release and removed Next Release Planned for next release labels Aug 17, 2022
@joocer
Copy link
Contributor Author

joocer commented Aug 19, 2022

Fixed as a side-effect of #338

@joocer joocer closed this as completed Aug 19, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug 馃 Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@joocer