[analyzer] Cannot parse DateTime: In scope SELECT _CAST('0', 'DateTime64(3)') AS toDateTime64('1970-01-01 00:00:00', 3) for distributed table with more than one host in select #66773
Description
Please make sure that the version you're using is still supported (you can find the list here).
Describe what's wrong
SELECT toDateTime64('1970-01-01 00:00:00', 3)
FROM remote('127.0.0.{1,2,3,4}', system, one)
SETTINGS allow_experimental_analyzer = 1return error
Received exception from server (version 24.6.2):
Code: 41. DB::Exception: Received from localhost:9000. DB::Exception: Received from 127.0.0.2:9000. DB::Exception: Cannot parse DateTime: In scope SELECT _CAST('0', 'DateTime64(3)') AS `toDateTime64('1970-01-01 00:00:00', 3)` FROM system.one AS __table1. (CANNOT_PARSE_DATETIME)
(query: SELECT toDateTime64('1970-01-01 00:00:00', 3)
FROM remote('127.0.0.{1,2,3,4}', system, one)
SETTINGS allow_experimental_analyzer = 1
)
Does it reproduce on the most recent release?
yes
reproduced with any release when allow_experimental_analyzer = 1