GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — [FEATURE] Support TABLE statement which added since MySQL 8.0.19 · Issue #1836 · JSQLParser/JSqlParser

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

New issue
Copy link
New issue
Copy link
Closed
#1921
Closed
[FEATURE] Support TABLE statement which added since MySQL 8.0.19#1836
#1921
Copy link
Labels
MySQLMySQL specific issueMySQL specific issueSponsor needed

Description

@134130
134130
opened on Jul 25, 2023
Issue body actions

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

Activity

  1. 134130 commented on Jul 25, 2023

    @134130
    134130
    on Jul 25, 2023
    Author
    More actions

    DML MySQL

  2. manticore-projects commented on Jul 25, 2023

    @manticore-projects
    manticore-projects
    on Jul 25, 2023
    Contributor
    More actions

    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.

    Reacted by JiHwan Oh
  3. manticore-projects
    added
    MySQLMySQL specific issueMySQL specific issue
    on Jul 25, 2023
  4. 134130 commented on Jul 25, 2023

    @134130
    134130
    on Jul 25, 2023
    Author
    More actions

    @manticore-projects Never mind! thank you.

  5. manticore-projects
    added
    Sponsor needed
    on Sep 2, 2023
  6. manticore-projects
    closed this as completedin #1921on Dec 16, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    MySQLMySQL specific issueMySQL specific issueSponsor needed

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

      You are visitor 01402503 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.