sql-parser icon indicating copy to clipboard operation
sql-parser copied to clipboard

Missing comma on ALTER TABLE with ENUM

Open MasterSalomon opened this issue 6 years ago • 0 comments

Hi,

the following statement:

ALTER TABLE `mail_template` CHANGE COLUMN `mtpl_group` `mtpl_group` ENUM('ORDER') NULL DEFAULT NULL ;

throws an exeception: "Missing comma before start of a new alter operation.".

When renamed 'ORDER' to 'TEST' parser works fine.

MasterSalomon avatar Mar 14 '19 13:03 MasterSalomon