You have to provide the following information whenever possible.
This quite useless query fails with syntax error:
select sum(number) = any(number) from numbers(1)
Expected one of: SELECT query, possibly with UNION, list of union elements, SELECT query, subquery, possibly with UNION, SELECT subquery, SELECT query, WITH, SELECT
While these queries work correctly:
select any(number) = sum(number) from numbers(1);
┌─equals(any(number), sum(number))─┐
│ 1 │
└──────────────────────────────────┘
select sum(number) = avg(number) from numbers(1);
┌─equals(sum(number), avg(number))─┐
│ 1 │
└──────────────────────────────────┘
Found in #35488 in query like
SELECT sum(subcolumns.bytes_on_disk) = any(column_bytes_on_disk)
FROM system.parts_columns ARRAY JOIN subcolumns
This quite useless query fails with syntax error:
While these queries work correctly:
Found in #35488 in query like