a-cid opened a new issue #15962: URL: https://github.com/apache/superset/issues/15962
Charts with a simple filter on a column of type DOUBLE generate invalid SQL due to passing the filter value as a string. The query then fails with an error message such as: `SYNTAX_ERROR: line 6:22: '>=' cannot be applied to double, varchar(1)` ### Expected results Generated SQL contains: `column > 0` ### Actual results Generated SQL contains: `column > '0'` #### Screenshots    #### How to reproduce the bug Create a chart that filters on a DOUBLE column. ### Environment (please complete the following information): - superset version: 1.2 (pip installed) - python version: 3.8.10 - node.js version: not installed ### 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. - [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 Problem seems to affect all charts. Not sure if it's exclusive to AWS Athena databases. -- 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]
