AfterShip / clickhouse-sql-parser

63%

master: 50%

LAST BUILD ON BRANCH issue-23

branch: issue-23

CHANGE BRANCH

x

Reset

Sync Branches

• issue-23
• 14-2
• add-benchmarks
• add-coverall
• add-modify-ttl
• add-more-badges
• allow-string-as-tablename
• allow-var-start-with-dollar
• alter-role-settings
• alter-table-drop-detached
• change-sql-string-to-compact
• claude/issue-184-20250827-0341
• codec-delta-level
• copilot/fix-12
• copilot/fix-140
• copilot/fix-179
• copilot/fix-181
• copilot/fix-75186bce-1dd8-4e67-bcd7-685469aa2574
• copilot/fix-e5e3e050-4a0c-4226-8f60-806cafedacba
• dev
• feat/alter_modify_query_support
• feat_support_db_comment
• feature/access-tuple-with-index
• feature/add-projection
• feature/add-union-distinct
• feature/allow-select-modifier
• feature/alter-table-replace
• feature/check-expression
• feature/clear-projection-statement
• feature/column-def-alias-materialized
• feature/create-function
• feature/create-or-replace
• feature/create-role
• feature/delete-from
• feature/drop-projection
• feature/drop-user-role
• feature/grant-privilege
• feature/grouping-sets
• feature/insert-expr
• feature/insert-with-type-column
• feature/materialize-index-and-projection
• feature/optimize-expression
• feature/query-parameter
• feature/rename-table
• feature/select-in-function
• feature/support-json-type-skip
• feature/support-placeholder
• feature/support-ttl-policy
• feature/timestamp-interval
• fix-cannot-parse-join-only
• fix-database-column-name
• fix-describe-table
• fix-materialized-bug
• fix-no-as-alias
• fix-order-by-panic
• fix-panic-in-eof-error
• fix-select-limit-add-select-final
• fix/allow-parameters-for-null-engine
• fix/between-expr
• fix/between-visitor
• fix/cast-expr
• fix/column-alias-string
• fix/distinct-keyword-preservation
• fix/dollar-sign
• fix/double-quote-as-ident
• fix/group-by-column-with-keyworld
• fix/insert-into
• fix/issue-118
• fix/issue-176
• fix/issues-108
• fix/multi-join
• fix/multi-line-comments
• fix/panic-invalid-sql
• fix/parse-comment-literal
• fix/readme
• fix/remove-extra-leading-space
• fix/select-as-query
• fix/select-issues
• fix/string-as-table-ident
• fix/table-visitor
• fix/union-all
• fix/window_clause
• fix/wrong-unary-expr-string
• ft-enhance-json-options
• improve-lexer
• improve-rename-syntax
• improve/parse-expr
• master
• minor-refactor-column-type
• refactor/allow-to-use-precedence
• refactor/expect-token-kind
• refactor/operation-name
• role/alter
• role/on-cluster-expr
• select-format
• select-with-left-join
• sharad/bug_fix
• sharad/codec_parser
• sharad/codec_parser_v3
• sharad/delta_number_literal
• sharad/mv_definer
• sharad/table_comment
• support-refresh-in-mv
• support/table-alias-without-as
• test-automation
• unify-sql-terms
• update-readme

Build # 16666101993

Build Type

Pull #177

github

Committed by git-hulk

Commit Message

Add support for PROJECTION columns in CREATE TABLE statements

This commit implements parsing support for PROJECTION columns within CREATE
TABLE statements according to ClickHouse syntax. Projections are a powerful
feature that allows creating pre-aggregated views of table data for improved
query performance.

Changes included:
  - Enhanced parseTableColumnExpr to detect and handle PROJECTION definitions
  - Added parseTableProjectionInCreateTable function for projection parsing
  - Created comprehensive test cases with input SQL and expected JSON output
  - Updated format tests to ensure proper SQL formatting

The implementation allows projections to be defined inline with regular table
columns, maintaining compatibility with existing CREATE TABLE parsing while
extending functionality for this advanced ClickHouse feature.

Pull Request Pull Request #177: Add support for PROJECTION columns in CREATE TABLE statements

Run Details

23 of 31 new or added lines in 1 file covered. (74.19%)

8113 of 12828 relevant lines covered (63.24%)

2083.16 hits per line