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

Support disable ONLY_FULL_GROUP_BY sql mode like Mysql #5578

Closed
kangkaisen opened this issue Apr 27, 2022 · 0 comments · Fixed by #5722 or #7084
Closed

Support disable ONLY_FULL_GROUP_BY sql mode like Mysql #5578

kangkaisen opened this issue Apr 27, 2022 · 0 comments · Fixed by #5722 or #7084
Assignees
Milestone

Comments

@kangkaisen
Copy link
Collaborator

For sql

 select c1, c2 from table group by c1;

when sql mode ONLY_FULL_GROUP_BY is false,
we rewrite the sql to

select c1, any_value(c2) from table group by c1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment