You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/08/10 07:46:24 UTC
[GitHub] [arrow-datafusion] waitingkuo opened a new issue, #3093: Incorrect type coercion rule for date + interval
waitingkuo opened a new issue, #3093:
URL: https://github.com/apache/arrow-datafusion/issues/3093
**Describe the bug**
A clear and concise description of what the bug is.
coercion rule for date + interval('1 day' ) works but fails for hours/min/sec
**To Reproduce**
Steps to reproduce the behavior:
```bash
❯ select now()::date + interval '1 hour';
+----------------------------------------------------+
| CAST(now() AS Date32) + IntervalDayTime("3600000") |
+----------------------------------------------------+
| +11879-01-27 |
+----------------------------------------------------+
1 row in set. Query took 0.000 seconds.
```
**Expected behavior**
A clear and concise description of what you expected to happen.
Cast to Timestamp like what postgresql does
```bash
willy=# select now()::date + interval '1 hour';
?column?
---------------------
2022-08-10 01:00:00
(1 row)
```
**Additional context**
Add any other context about the problem here.
--
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: github-unsubscribe@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] waitingkuo commented on issue #3093: Incorrect type coercion rule for date + interval
Posted by GitBox <gi...@apache.org>.
waitingkuo commented on issue #3093:
URL: https://github.com/apache/arrow-datafusion/issues/3093#issuecomment-1212681786
@JasonLi-cn thank you, looks like this is solved in some pr. I'll close this issue as this is similar as #3103 now.
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] waitingkuo commented on issue #3093: Incorrect type coercion rule for date + interval
Posted by GitBox <gi...@apache.org>.
waitingkuo commented on issue #3093:
URL: https://github.com/apache/arrow-datafusion/issues/3093#issuecomment-1210292739
related issue/pr: #194 #2235
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] JasonLi-cn commented on issue #3093: Incorrect type coercion rule for date + interval
Posted by GitBox <gi...@apache.org>.
JasonLi-cn commented on issue #3093:
URL: https://github.com/apache/arrow-datafusion/issues/3093#issuecomment-1212656286
My reproduce
```sql
❯ select now()::date + interval '1 hour';
+----------------------------------------------------+
| CAST(now() AS Date32) + IntervalDayTime("3600000") |
+----------------------------------------------------+
| 2022-08-12 |
+----------------------------------------------------+
```
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] waitingkuo closed issue #3093: Incorrect type coercion rule for date + interval
Posted by GitBox <gi...@apache.org>.
waitingkuo closed issue #3093: Incorrect type coercion rule for date + interval
URL: https://github.com/apache/arrow-datafusion/issues/3093
--
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: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org