Skip to content

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

Closed
@134130

Description

@134130

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions