Use the data in the readme
SEMANTIC
select
region || 'foo' as regionfoo,
AGGREGATE(revenue)
from
sales_v;
Result:
Invalid Input Error:
Query error: Binder Error: column "region" must appear in the GROUP BY clause or must be part of an aggregate function.
Either add it to the GROUP BY list, or use "ANY_VALUE(region)" if the exact value of "region" is not important.
LINE 4: ...) _inner WHERE _inner.region || 'foo' IS NOT DISTINCT FROM sales_v.region || 'foo')
^
LINE 2: select
This can probably be worked around with a subquery
Use the data in the readme
Result:
This can probably be worked around with a subquery