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

Some queries using HAVING can't be executed without GROUPBY #1289

Closed
fulghum opened this issue Sep 27, 2022 · 0 comments · Fixed by #1307
Closed

Some queries using HAVING can't be executed without GROUPBY #1289

fulghum opened this issue Sep 27, 2022 · 0 comments · Fixed by #1307
Assignees

Comments

@fulghum
Copy link
Contributor

fulghum commented Sep 27, 2022

Some (but not all) queries using HAVING, but not explicitly using GROUPBY fail with the error: `found HAVING clause with no GROUP BY'. MySQL is able to execute these without problems, so GMS/Dolt should, too.

Example: select t1.val as a from numbers as t1 having a = t1.val;

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