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)
Updated by Casey Bodley 11 months ago
- Subject changed from a backtick(`) on a constant date is converted into timestamp - on parsing time to s3select: a backtick(`) on a constant date is converted into timestamp - on parsing time
- Tags set to s3select
Updated by Gal Salomon 11 months ago
- Status changed from New to Resolved
- Pull request ID set to 52186
Actions