We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
unknown column
Please answer these questions before submitting your issue. Thanks!
create table t(a int); select a.a from t a having a.a;
mysql> select a.a from t a having a.a; Empty set (0.00 sec)
tidb> select a.a from t a having a.a; ERROR 1054 (42S22): Unknown column 'a.a' in 'having clause'
all versions
The text was updated successfully, but these errors were encountered:
ERROR 1111 (HY000): Invalid use of group function
Successfully merging a pull request may close this issue.
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
3. What did you see instead (Required)
4. Affected version (Required)
all versions
5. Root Cause Analysis
The text was updated successfully, but these errors were encountered: