You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
INTERVAL + timestamp and INTERVAL + date not supported (but timestamp + INTERVAL and date + INTERVAL is) #6180
changed the title [-]Don't support Interval is in left.[/-][+]`INTERVAL` + timestamp and `INTERVAL` + date not supported (but timestamp + `INTERVAL` and date + `INTERVAL` is)[/+]on May 1, 2023
I agree this is a parser problem. INTERVAL + timestamp and INTERVAL+date do work if the ::interval cast syntax is used rather than the interval. I will open another bug explaining this
Activity
jackwener commentedon May 1, 2023
It's wrong in
src/expr/mod.rs:140 sql_interval_to_expr().SQLExpr is
I think it is a bug in Parser. Interval shouldn't include BinaryOp.
alamb commentedon May 1, 2023
Added to #5753
[-]Don't support Interval is in left.[/-][+]`INTERVAL` + timestamp and `INTERVAL` + date not supported (but timestamp + `INTERVAL` and date + `INTERVAL` is)[/+]alamb commentedon May 3, 2023
I agree this is a parser problem. INTERVAL + timestamp and INTERVAL+date do work if the
::intervalcast syntax is used rather than theinterval. I will open another bug explaining thisalamb commentedon May 3, 2023
#6205