AfterShip / clickhouse-sql-parser / 24144077115

Pull #262

github

fix: support COMMENT before AS SELECT in CREATE MATERIALIZED VIEW

ClickHouse 26.2+ changed SHOW CREATE TABLE output to place COMMENT
before AS SELECT, while 25.x places it after. The parser only
supported COMMENT after AS SELECT, causing parse failures on 26.2+.

Now tries COMMENT in both positions:
- Before AS SELECT (ClickHouse 26.2+ SHOW CREATE TABLE format)
- After AS SELECT (ClickHouse 25.x SHOW CREATE TABLE format)

Fixes #261

8 of 12 new or added lines in 1 file covered. (66.67%)

8190 of 15921 relevant lines covered (51.44%)

2410.11 hits per line