sfirke opened a new issue, #23372:
URL: https://github.com/apache/superset/issues/23372

   Pretty specific bug I found when testing 2.1.0 (rc2 is the first time I'm 
trying out DRILL_TO_DETAIL).
   
   - Version 2.1.0rc2
   - GENERIC_CHART_AXES and DRILL_TO_DETAIL flags enabled
   - Bar chart v2
   - X-axis variable is of type varchar or date that has been set to temporal 
in the Edit Dataset UI
   - Trying to drill to detail by the x-axis variable or "All" results in error 
message `Arithmetic overflow error converting expression to data type datetime`
   
   My backend is SQL Server, thus that specific error message.
   
   My guess is that there's an operation to cast an X-axis variable to datetime 
when charting if that variable is marked as temporal, but this breaks at the 
drilling?
   
   My workaround: I changed the variable in the database to be datetime and 
then I could drill successfully.  But that's a little misleading since my 
variable does not have that resolution, this data field is only precise to the 
date level.


-- 
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]

Reply via email to