maanwater commented on issue #35271:
URL: https://github.com/apache/superset/issues/35271#issuecomment-3588370954
We have found what causes the issue. It is the STR_TO_DATE function. In SQL
lab, when we remove that function then the result is correct. Since this worked
in v5.x is this something that has changed in v6.0?
Wrong results in v6.0;
`WHERE timestamp >= STR_TO_DATE('2025-09-23 00:00:00.000000', '%Y-%m-%d
%T.%f') AND timestamp < STR_TO_DATE('2025-09-23 11:32:16.000000', '%Y-%m-%d
%T.%f')`
Correct results in v6.0:
`WHERE timestamp >= '2025-09-23 00:00:00' AND timestamp < '2025-09-23
11:32:16'`
Also, is there a way to avoid Superset from adding the STR_TO_DATE when
using a timestamp filter?
--
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]
