[FEATURE] MySQL ALTER Table Syntax List: UNSPECIFIC Operations #2118

Grammar or Syntax Description

Description

Certain MySQL-specific ALTER TABLE clauses are not explicitly recognized by JSqlParser. These are categorized as Operation is UNSPECIFIC, which can limit parsing capabilities and programmatic handling of such statements.

EBNF Context

Below is a list of MySQL ALTER TABLE clauses that fall under the UNSPECIFIC category:

• ENABLE KEYS
• DISABLE KEYS
• ALTER TABLE ... FORCE
• ALTER TALBE ... COLLATE

SQL Examples

Example Queries

-- 1. ENABLE KEYS
ALTER TABLE `jin_innodb` ENABLE KEYS;

-- 2. DISABLE KEYS
ALTER TABLE `jin_innodb` DISABLE KEYS;

-- 3. FORCE
ALTER TABLE `my_table` FORCE;

-- 4. COLLATE
alter table cavedb.stat_app_api COLLATE=utf8mb4_general_ci;

-- 5. import / discard tablespace
ALTER TABLE t4 DISCARD TABLESPACE;
ALTER TABLE partitioned_table IMPORT tablespace;

More examples will be added to expand the coverage of MySQL-specific clauses.

Additional Context
JSqlParser Version : 5.0

Applicable RDBMS : MySQL 8.0

Documentation References
MySQL ALTER TABLE Documentation