[FORMATTING] ClickHouse: aggregate functions with combinators (countMerge, sumIf, ...) get a space before the parenthesis #990

Input data

SELECT sumIf(x, y > 1), countMerge(s), uniqExactIfState(id), groupArrayArray(a) FROM t

Options: { language: 'clickhouse' }

Expected Output

SELECT
  sumIf(x, y > 1),
  countMerge(s),
  uniqExactIfState(id),
  groupArrayArray(a)
FROM
  t

Actual Output

SELECT
  sumIf (x, y > 1),
  countMerge (s),
  uniqExactIfState (id),
  groupArrayArray (a)
FROM
  t

Usage

• format(sql, { language: 'clickhouse' })
• ClickHouse. The function list of the dialect comes from system.functions, which does not contain the names ClickHouse builds from an aggregate function and a combinator (-If, -State, -Merge, ...). They are treated as identifiers, so they get a space before the parenthesis, unlike sum(x). They are common in materialized views and queries on AggregatingMergeTree tables.
• sql-formatter 15.9.0

A fix is in #988.

This was prepared with Claude Code (an AI coding assistant); the outputs above come from sql-formatter 15.9.0.