"SELECT cid,rid FROM seen WHERE uid=1 AND ts>0 LIMIT 3;" ERROR: Failed to execute query: SELECT cid,rid FROM seen WHERE uid=1 AND ts>0 LIMIT 3;, source: Failed to execute logical plan, source: Failure during query execution, source: Fail to crea te physical plan: type_coercion about greptimedb HOT 2 CLOSED

CAST转换貌似也不对，这个查询应该感觉不应该包含 1690252336408
English (USA): CAST's conversion seems wrong, this query should not be included 169025236408

SELECT cid,rid,CAST(ts as BIGINT) t FROM seen WHERE uid=1 AND ts>CAST(1690252336408 as timestamp) ORDER BY ts LIMIT 3;

Ruihang
SELECT cid,rid,CAST(ts as BIGINT) t FROM seen WHERE uid=1 AND ts>arrow_cast(1690252336408, 'Timestamp(Millisecond, None)') ORDER BY ts LIMIT 3;

xxai.art
我明白了，不过我感觉 CAST(ts as BIGINT) 和 CAST(bigint as TIMESTAMP) 是可逆操作比较符合直觉。 也就是 CAST(CAST(ts AS BIGINT) as TIMESTAMP) = ts
English (USA): I understand, but I feel that CAST(ts as BIGINT) and CAST(bigint as TIMESTAMP) are more intuitive than reversible operations. That is CAST(CAST(ts AS BIGINT) as TIMESTAMP) = ts

from greptimedb.

Submitted a doc PR to include this case GreptimeTeam/docs#500. Thanks for reporting

from greptimedb.