-
Notifications
You must be signed in to change notification settings - Fork 1.8k
Closed
Labels
bugSomething isn't workingSomething isn't working
Description
Describe the bug
I can not use interval .. syntax in SQL VALUES clauses
To Reproduce
create table t (i interval) as values (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) as values ('5 days 3 nanoseconds'::interval);
0 rows in set. 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_Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't working