zuzana-vej opened a new issue #12293:
URL: https://github.com/apache/superset/issues/12293


   Simple SQL correctly encodes the values as INTegers. and technically it's 
displaying incorrectly `views IN ('5', '10')` even though it's encoded 
correctly and the query is working - therefore this is a minor issue but can 
confuse users. 
   
   
   ### Expected results
   Displayed as integer in the Custom SQL box.
   
   ### Actual results
   Transforms into string in the Custom SQL box.
   
   #### Screenshots
   Filter:
   ![Screen Shot 2021-01-05 at 3 36 22 
PM](https://user-images.githubusercontent.com/61221714/103711484-65540700-4f6c-11eb-8564-6a1562253c39.png)
   
   Generated SQL Query
   ![Screen Shot 2021-01-05 at 3 37 02 
PM](https://user-images.githubusercontent.com/61221714/103711505-713fc900-4f6c-11eb-8c8d-90d6e6d9fcc1.png)
   
   
   #### How to reproduce the bug
   
   1. Go to Explore
   2. Create chart and go to WHERE filter box
   3. Specify multiple IN integer values
   4. See error
   
   ### Environment
   
   (please complete the following information):
   
   - superset version: `master`
   - python version: `python --version`
   - node.js version: `node -v`
   
   ### 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
   
   This has been introduced a while back - some time in September, but user 
consider it a feature request, not a bug. 
   


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

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