Actions
Bug #61637
closeds3select: a backtick(`) on a constant date is converted into timestamp - on parsing time
% Done:
0%
Source:
Tags:
s3select
Backport:
Regression:
No
Severity:
2 - major
Reviewed:
Description
the following SQL construct
cast(_1 as timestamp) = `1997-01-02`
failed on the processing time
it seems the constant string is converted into a timestamp (the backtick imply that)
upon running the Trino with TPCDS, the Trino is converting some of the original queries into s3select requests
with this SQL construct, which fails on runtime. (comparison between timestamp and a string)
Actions