Describe the bug
Queries with a nested count (select count(*) from (select count(*) from (select 1));)
fail with
Optimizer rule 'optimize_projections' failed
caused by
Error during planning: Aggregate requires at least one grouping or aggregate expression
To Reproduce
No response
Expected behavior
Should return the number of rows (1)
Additional context
No response
Describe the bug
Queries with a nested count (
select count(*) from (select count(*) from (select 1));)fail with
To Reproduce
No response
Expected behavior
Should return the number of rows (1)
Additional context
No response