AfterShip / clickhouse-sql-parser / 24571285878

Pull #265

github

feat: add COMMENT support to CREATE VIEW parser

CREATE VIEW in ClickHouse supports COMMENT between the schema and AS SELECT:

  CREATE VIEW db.v (columns) COMMENT '{...}' AS SELECT ...

The parser previously failed with 'expected EOF or ; but got COMMENT'.

Changes:
- Add Comment field to CreateView struct (ast.go)
- Parse COMMENT clause in parseCreateView before AS (parser_view.go)
- Format COMMENT in CreateView.FormatSQL (format.go)
- Add test case: create_view_with_comment.sql
- Update golden files for existing view tests (new nil Comment field)

8 of 10 new or added lines in 2 files covered. (80.0%)

8211 of 15954 relevant lines covered (51.47%)

2420.86 hits per line