AfterShip / clickhouse-sql-parser / 24572473754

push

github

Add COMMENT support to CREATE VIEW parser (#265)

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)

9 of 17 new or added lines in 4 files covered. (52.94%)

8212 of 15961 relevant lines covered (51.45%)

2419.8 hits per line