Method skipClickHouseClauseExpr

pkg/sql/parser/ddl.go:735–774

skipClickHouseClauseExpr consumes the expression following a ClickHouse CREATE TABLE trailing clause (ORDER BY, PARTITION BY, PRIMARY KEY, SAMPLE BY). We do not currently model these clauses on the AST; this just walks the tokens until the start of the next clause, EOF, or ';'. Supports both parenth

()

// tokens until the start of the next clause, EOF, or ';'. Supports both
// parenthesised lists and bare expressions.
func (p *Parser) skipClickHouseClauseExpr() error {
	if p.isType(models.TokenTypeLParen) {
		// Balanced paren block.
		depth := 0
		for {
			switch p.currentToken.Token.Type {
			case models.TokenTypeEOF:
				return p.expectedError(") to close clause expression")
			case models.TokenTypeLParen:
				depth++
				p.advance()
			case models.TokenTypeRParen:
				depth--
				p.advance()
				if depth == 0 {
					return nil
				}
			default:
				p.advance()
			}
		}
	}

	// Bare expression: consume until next clause/EOF/;.
	for {
		t := p.currentToken.Token.Type
		if t == models.TokenTypeEOF || t == models.TokenTypeSemicolon {
			return nil
		}
		// Stop at next CH trailing-clause keyword.
		if t == models.TokenTypeOrder || t == models.TokenTypePrimary {
			return nil
		}
		val := strings.ToUpper(p.currentToken.Token.Value)
		if val == "PARTITION" || val == "SAMPLE" || val == "SETTINGS" || val == "TTL" {
			return nil
		}
		p.advance()
	}
}