Project

General

Profile

Actions
Copy link

Bug #61637

closed

s3select: a backtick(`) on a constant date is converted into timestamp - on parsing time

Added by Gal Salomon 11 months ago. Updated 11 months ago.

Status:
Resolved
Priority:
Normal
Assignee:
Gal Salomon
Target version:
Ceph - v17.2.7
% Done:

0%

Source:
Tags:
s3select
Backport:
Regression:
No
Severity:
2 - major
Reviewed:
Affected Versions:
ceph-qa-suite:
Pull request ID:
52186
Crash signature (v1):
Crash signature (v2):

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
Copy link

Also available in: Atom PDF