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
 #1

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
Actions
Copy link
 #2

Updated by Gal Salomon 11 months ago

  • Status changed from New to Resolved
  • Pull request ID set to 52186
Actions
Copy link

Also available in: Atom PDF