DB::Exception: Cannot find column count(id_with) in source stream

[ucasfl]

How to reproduce:

:) create table test(day Date, id UInt32) engine=MergeTree partition by day order by tuple()                                                    
                                                                                                                                                                                                                    
CREATE TABLE test                                                                                                                                                                                                   
(                                                                                                                                                                                                                   
    `day` Date,                                                                                                                                                                                                     
    `id` UInt32                                                                                                                                                                                                     
)                                                                                                                                                                                                                   
ENGINE = MergeTree                                                                                                                                                                                                  
PARTITION BY day                                                                                                                                                                                                    
ORDER BY tuple()                                                                                                                                                                                                    
                                                                                                                                                                                                                    
Query id: a81e4c06-cbc1-4e18-b1dd-1d68cc30a630                                                                                                                                                                      
                                                                                                                                                                                                                    
Ok.                                                                                                                                                                                                                 
                                                                                                                                                                                                                    
0 rows in set. Elapsed: 0.011 sec.           

:) insert into test select toDate('2023-01-05') AS day, number from numbers(10);

INSERT INTO test SELECT
    toDate('2023-01-05') AS day,
    number
FROM numbers(10)

Query id: 1ee62a35-6c91-4797-9a6e-08518f34995b

Ok.

0 rows in set. Elapsed: 0.002 sec.

 :) with toUInt64(id) as id_with select day, count(id_with)  from test where day >= '2023-01-01' group by day limit 1000

WITH toUInt64(id) AS id_with
SELECT
    day,
    count(id_with)
FROM test
WHERE day >= '2023-01-01'
GROUP BY day
LIMIT 1000

Query id: 362bf093-d693-4655-9d2c-a3e4b687708c


0 rows in set. Elapsed: 0.013 sec. 

Received exception from server (version 22.13.1):
Code: 8. DB::Exception: Received from localhost:9000. DB::Exception: Cannot find column `count(id_with)` in source stream, there are only columns: [day]. (THERE_IS_NO_COLUMN)