Skip to content

'",": Unrecognized alter operation' when altering table with ALGORITHM and LOCK clauses #319

Closed
@PierreKerschgens

Description

@PierreKerschgens

HI!

Despite I'm using your sql-parser as part of php-sqllint I think the following issue origins from sql-parser.

I have the following statement:

ALTER TABLE XXX DROP COLUMN YYY, ALGORITHM=INPLACE, LOCK=NONE;

Which results in the following false-positive:

Line 9, col 65 at ",": Unrecognized alter operation.
Line 9, col 67 at "LOCK": A new statement was found, but no delimiter between it and the previous one.
Line 9, col 67 at "LOCK": Unrecognized alter operation.

best regards!

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions