milovidov-desktop :) SET allow_experimental_analyzer = 1

SET allow_experimental_analyzer = 1

Query id: 659a3ac8-077c-4751-8cf0-71772987790e

Ok.

0 rows in set. Elapsed: 0.001 sec. 

milovidov-desktop :) SELECT 'value: ', avg(number + -9223372036854775807) FROM numbers(10) WHERE toDateTime(toDateTime(2147483646, toDateTime(toDateTime(10, NULL), '214748364.6'), toDateTime(toDateTime(NULL))))

SELECT
    'value: ',
    avg(number + -9223372036854775807)
FROM numbers(10)
WHERE toDateTime(toDateTime(2147483646, toDateTime(toDateTime(10, NULL), '214748364.6'), toDateTime(toDateTime(NULL))))

Query id: 6a09023f-3613-492e-adf1-65fb5f48b4ad


0 rows in set. Elapsed: 0.004 sec. 

Received exception from server (version 22.13.1):
Code: 49. DB::Exception: Received from localhost:9000. DB::Exception: Bad cast from type DB::ColumnVector<double> to DB::ColumnVector<long>. (LOGICAL_ERROR)