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
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_
The text was updated successfully, but these errors were encountered:
Uh oh!
There was an error while loading. Please reload this page.
Describe the bug
I can not use
interval ..
syntax in SQLVALUES
clausesTo Reproduce
Results in
Expected behavior
I expect it to work like
The text was updated successfully, but these errors were encountered: