ValentinC-BR opened a new issue, #20539: URL: https://github.com/apache/superset/issues/20539
If a calculated column is used as a time column, an error occurs : the WHERE clause is not adapted. ### How to reproduce the bug 1. Create a calculated column with DATETIME type and tick the "time column" checkbox 2. Create a chart and use this calculated column as time column 3. Filter on "Last week" 4. Run 5. See error ### Expected results The query should run without any problem ### Actual results An error occurs : `Error: SYNTAX_ERROR: line 5:20: '>=' cannot be applied to date, varchar(26)` ### Screenshots ##### Config  #### Error  #### Cause  ### Environment (please complete the following information): - browser type and version: Google Chrome Version 103.0.5060.53 (Official Build) (x86_64) - superset version: 1.5 - python version: 3.9 - node.js version: / - any feature flags active: / ### Checklist Make sure to follow these steps before submitting your issue - thank you! - [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any. - [X] 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. ### Additional context Already present in the earlier versions of Superset -- 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]
