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] Parsing CONVERT TO Statement in ALTER TABLE Using JSQLParser · Issue #2089 · JSQLParser/JSqlParser

[FEATURE] Parsing CONVERT TO Statement in ALTER TABLE Using JSQLParser #2089

New issue
Copy link
New issue
Copy link
Closed
Closed
[FEATURE] Parsing CONVERT TO Statement in ALTER TABLE Using JSQLParser#2089
Copy link
Labels
DDLDDL statement relatedDDL statement relatedMySQLMySQL specific issueMySQL specific issueSponsor needed

Description

@minleejae
minleejae
opened on Oct 18, 2024
Issue body actions

Grammar or Syntax Description

  • The CONVERT TO CHARACTER SET clause in ALTER TABLE statements is not correctly parsed by JSQLParser.
  • The parser treats the operation as UNSPECIFIC instead of the appropriate operation type.

SQL Example

ALTER TABLE test_table CONVERT TO CHARACTER SET utf8mb4;

Additional context

  • Applicable RDBMS: MySQL 8.0
  • JSQLParser: 5.0

The parsing succeeds without errors, but I believe it is necessary to add an appropriate CONVERT or AlterOperation type to handle this clause correctly.

Activity

  1. manticore-projects
    added
    MySQLMySQL specific issueMySQL specific issue
    DDLDDL statement relatedDDL statement related
    Sponsor needed
    on Oct 18, 2024
  2. manticore-projects commented on Oct 18, 2024

    @manticore-projects
    manticore-projects
    on Oct 18, 2024
    Contributor
    More actions

    Greetings!
    You will need to provide or sponsor an implementation to make this happen.

  3. JSQLParser
    deleted a comment from on Oct 31, 2024
  4. manticore-projects commented on Nov 14, 2024

    @manticore-projects
    manticore-projects
    on Nov 14, 2024
    Contributor
    More actions

    Solved via #2097

  5. manticore-projects
    closed this as completedon Nov 14, 2024
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

    DDLDDL statement relatedDDL statement relatedMySQLMySQL 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.