-
Notifications
You must be signed in to change notification settings - Fork 489
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
Failed to parse WHERE / GROUP BY clauses in a SELECT statement without a FROM table #115
Labels
Comments
zz-jason
added
help wanted
Extra attention is needed
type/new-feature
and removed
type/bug
Something isn't working
labels
Oct 21, 2019
Let me fix it please 😄 |
27 tasks
Hey, I wanna fix this issue. I read the discussion, and wondering:
SELECT @@autocommit limit 1; -- @@autocommit:1 or `@@autocommit limit 1`:1?
select 1 where true group by 1 having 1>0; -- Throw an error? Or just return 1:1?
If there is a clear conclusion, I'll be happy to fix it if I can. Otherwise maybe I can go out and see other cases ^_^. PS: I also read doc in mysql (https://dev.mysql.com/doc/refman/8.0/en/select.html), no clear conclusion found. |
Follow MySQL's behavior on doubt.
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
These SQLs:
All return one row with the value 1 on MySQL 8.0 (also tested on PostgreSQL 9.6 and SQLite 3.24 with the same behavior), but failed to parse on TiDB 2.1.1 and master:
Table-less queries which are correctly accepted by TiDB:
The text was updated successfully, but these errors were encountered: