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

[FEATURE] Support TABLE statement which added since MySQL 8.0.19 #1836

Closed
134130 opened this issue Jul 25, 2023 · 3 comments · Fixed by #1921
Closed

[FEATURE] Support TABLE statement which added since MySQL 8.0.19 #1836

134130 opened this issue Jul 25, 2023 · 3 comments · Fixed by #1921
Labels
MySQL MySQL specific issue Sponsor needed

Comments

@134130
Copy link

134130 commented Jul 25, 2023

Grammar or Syntax Description

  • TABLE statement is not supported yet
  • tableStatement ::= TABLE table_name [ORDER BY column_name] [LIMIT number [OFFSET number]]

SQL Example

  • Simplified Query Example, focusing on the failing feature
     TABLE columns;
     TABLE columns LIMIT 10;
     TABLE columns LIMIT 10 OFFSET 10;
     TABLE columns ORDER BY column_name;
     TABLE columns ORDER BY column_name LIMIT 10;
     TABLE columns ORDER BY column_name LIMIT 10 OFFSET 10;

Additional context

The used JSQLParser Version : 4.6 (4.7-snapshot also not supported yet)
State the applicable RDBMS and version : MySQL 8.0.23
Links to the reference documentation : https://dev.mysql.com/doc/refman/8.0/en/table.html

@134130
Copy link
Author

134130 commented Jul 25, 2023

DML MySQL

@manticore-projects
Copy link
Contributor

Greetings.

Sorry to be blunt, but I see little value in adding that because its RDBMS specific and redundant.
However, please feel free to submit a PR/Implementation if you are very interested in this particular statement.

@manticore-projects manticore-projects added the MySQL MySQL specific issue label Jul 25, 2023
@134130
Copy link
Author

134130 commented Jul 25, 2023

@manticore-projects Never mind! thank you.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
MySQL MySQL specific issue Sponsor needed
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants