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/06 15:43:04 UTC
[GitHub] [arrow-datafusion] kmitchener opened a new issue, #3057: once now() is called in a statement, it forever returns the same value
kmitchener opened a new issue, #3057:
URL: https://github.com/apache/arrow-datafusion/issues/3057
**Describe the bug**
A clear and concise description of what the bug is.
```sql
select now();
-- ... 3 days later ...
select now(); -- returns same old value
```
It's correctly caching now() so it returns the same value when used multiple times in the same query, but it shouldn't be caching the value past statement execution, correct?
**To Reproduce**
Steps to reproduce the behavior:
**Expected behavior**
A clear and concise description of what you expected to happen.
Would expect now() to return the same value for all instances in the same query, but a new value for a new statement in the same runtime context.
**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] andygrove closed issue #3057: once now() is called in a statement, it forever returns the same value
Posted by GitBox <gi...@apache.org>.
andygrove closed issue #3057: once now() is called in a statement, it forever returns the same value
URL: https://github.com/apache/arrow-datafusion/issues/3057
--
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] andygrove commented on issue #3057: once now() is called in a statement, it forever returns the same value
Posted by GitBox <gi...@apache.org>.
andygrove commented on issue #3057:
URL: https://github.com/apache/arrow-datafusion/issues/3057#issuecomment-1207242344
> It's correctly caching now() so it returns the same value when used multiple times in the same query, but it shouldn't be caching the value past statement execution, correct?
You are right. This is a bug.
--
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 #3057: once now() is called in a statement, it forever returns the same value
Posted by GitBox <gi...@apache.org>.
waitingkuo commented on issue #3057:
URL: https://github.com/apache/arrow-datafusion/issues/3057#issuecomment-1207347067
`now()` is using the time while session is created (i.e. the time datafusion-cli is launched).
<https://github.com/apache/arrow-datafusion/blob/master/datafusion/physical-expr/src/execution_props.rs#L32>
--
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] alamb commented on issue #3057: once now() is called in a statement, it forever returns the same value
Posted by GitBox <gi...@apache.org>.
alamb commented on issue #3057:
URL: https://github.com/apache/arrow-datafusion/issues/3057#issuecomment-1215886090
Agree -- now() should update between each statement but stay the same *within* a statement
--
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