You have to provide the following information whenever possible.
Describe the bug
Interval data type is not passed correctly from subquery
Does it reproduce on recent release?
Yes, tested on 21.6.5.37.
How to reproduce
SELECT
toIntervalDay(5) AS interval,
now() + interval AS res
┌─interval─┬─────────────────res─┐
│ 5 │ 2021-07-03 13:11:45 │
└──────────┴─────────────────────┘But if I wrap interval calculation in subquery:
SELECT
(SELECT toIntervalDay(5)) AS interval,
now() + interval AS res
Received exception from server (version 21.6.5):
Code: 70. DB::Exception: Received from localhost:9000. DB::Exception: Conversion from Int8 to IntervalDay is not supported: While processing CAST(5, 'IntervalDay') AS interval, now() + interval AS res.Expected behavior
Both queries should work the same way.
You have to provide the following information whenever possible.
Describe the bug
Interval data type is not passed correctly from subquery
Does it reproduce on recent release?
Yes, tested on 21.6.5.37.
How to reproduce
But if I wrap interval calculation in subquery:
Expected behavior
Both queries should work the same way.