MySQL ALTER ADD COLUMN decimal type along with comment make parse DDL incorrect

[an-vt]

When alter add a new column decimal type along comment make parse DDL get precision and scale for decimal type error

Reproduction

1. Start replication.
2. Run ALTER TABLE test ADD decimal_column DECIMAL(10,2) NOT NULL DEFAULT 0.00 COMMENT 'comment decimal column' on MySQL.
3. Clickhouse execute DDL error

DDL error log:

[aadant]

that's a DDL parsing issue. @subkanthi this should be caught by comprehensive QA tests.

[aadant]

this works fine, the comment confuses the parser

ALTER TABLE test ADD decimal_column DECIMAL(10,2) NOT NULL DEFAULT 0.0

[aadant]

Most likely a duplicate of this bug #866, fixed in 2.6.0.