fech-dev opened a new issue, #25637:
URL: https://github.com/apache/superset/issues/25637
On the Chart page, when I set any time filter with 'Custom' as the Range
type and set Start to 'Midnight' and End to 'Now', the SQL query generated is
wrong.
```SQL
...
where created_at >= to_date('2023-10-13', 'yyyy-mm-dd')
and created_at < to_date('2023-10-13', 'yyyy-mm-dd')
```
This is giving me no results...
I'm using an Oracle Database.
I guess that the last filter `created_at < to_date('2023-10-13',
'yyyy-mm-dd')` should be like `created_at < to_date('2023-10-13 17:00:00',
'yyyy-mm-dd hh24:mi:ss')`
#### How to reproduce the bug
1. Open a chart
2. Use the pivot table (or a simple table)
3. Go to the 'Time' section and set a DateTime column, granularity as 'Day'
and time range to `custom` with start `Midnight` and end `Now`
4. Click on Apply and then update the chart
5. Get the 'No results were returned for this query' message
### Expected results
The results for the current day until "now".
### Actual results
Get the 'No results were returned for this query' message
### Environment
(please complete the following information):
- browser type and version: Firefox v118.0.2
- superset version: `2.1.0`
- python version: `python --version`
- node.js version: `node -v`
- any feature flags active:
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [x] I have checked the superset logs for python stacktraces and included
it here as text if there are any.
- [ ] I have reproduced the issue with at least the latest released version
of superset.
- [x] I have checked the issue tracker for the same issue and I haven't
found one similar.
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
