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

unexpected unknown column error #18384

Closed
XuHuaiyu opened this issue Jul 6, 2020 · 0 comments · Fixed by #18349
Closed

unexpected unknown column error #18384

XuHuaiyu opened this issue Jul 6, 2020 · 0 comments · Fixed by #18349
Labels
severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@XuHuaiyu
Copy link
Contributor

XuHuaiyu commented Jul 6, 2020

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t(a int);
select a.a from t a having a.a;

2. What did you expect to see? (Required)

mysql> select a.a from t a having a.a;
Empty set (0.00 sec)

3. What did you see instead (Required)

tidb> select a.a from t a having a.a;
ERROR 1054 (42S22): Unknown column 'a.a' in 'having clause'

4. Affected version (Required)

all versions

5. Root Cause Analysis

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants