QuenKar opened a new issue, #8465:
URL: https://github.com/apache/arrow-datafusion/issues/8465
### Describe the bug
```
> select interval '1 YEAR'
Arrow error: Not yet implemented: Unsupported Interval Expression with value
"1 YEAR seconds"
```
however use lowercase is ok.
```
> select interval '1 year'
+--------------------------------------------------------+
| IntervalMonthDayNano("950737950171172051122527404032") |
+--------------------------------------------------------+
| 0 years 12 mons 0 days 0 hours 0 mins 0.000000000 secs |
+--------------------------------------------------------+
```
I try other databases such as duckdb and postgres, and uppercase style is ok.
### To Reproduce
use datafusion-cli and `select interval '1 YEAR'`
DataFusion CLI v33.0.0
### Expected behavior
ouput the right result.
### Additional context
The reason may be because
https://github.com/apache/arrow-datafusion/blob/main/datafusion/sql/src/expr/value.rs#L319
the `has_units` function just check the lowercase style, and I think add
`to_lowercase` in it can solve this problem.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
