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 .. syntax does not work in SQL VALUES clause #5802
I can not use interval .. syntax in SQL VALUES clauses
To Reproduce
createtablet (i interval) asvalues (interval '5 days 3 nanoseconds');
Results in
DataFusion error: This feature is not implemented: Unsupported value Interval \{ value: Value\(SingleQuotedString\("5 days 3 nanoseconds"\)\), leading_field: None, leading_precision: None, last_field: None, fractional_seconds_precision: None \} in a values list expression
Expected behavior
I expect it to work like
❯ create table t (i interval) asvalues ('5 days 3 nanoseconds'::interval);
0 rows inset. Query took 0.002 seconds.
❯ show columns in t;
+---------------+--------------+------------+-------------+------------------------+-------------+
| table_catalog | table_schema | table_name | column_name | data_type | is_nullable |
+---------------+--------------+------------+-------------+------------------------+-------------+
| datafusion | public | t | i | Interval(MonthDayNano) | YES |
+---------------+--------------+------------+-------------+------------------------+-------------+### Additional context
_No response_
Activity