[GitHub] hajdbo opened a new issue #4857: Incorrect SQL statement on "View Query": python-encoded % character (%%) on STR_TO_DATE()

[GitBox]

hajdbo opened a new issue #4857: Incorrect SQL statement on "View Query": 
python-encoded % character (%%) on STR_TO_DATE()
URL: https://github.com/apache/incubator-superset/issues/4857
 
 
   Using Mysql engine, the request displayed when clicking "View Query" shows a 
python-encoded %: %%
   
   The query should have single % characters, rather than %%.
   
   I followed the trail to get_query_str() in 
https://github.com/apache/incubator-superset/blob/master/superset/connectors/sqla/models.py#L418
   
   - [X] I have checked the superset logs for python stacktraces and included 
it here as text if 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
   
   
   ### Superset version
   0.24.0
   
   ### Expected results
   The query displayed should be syntactically correct, showing a single % for 
STR_TO_DATE() function.
   
   ### Actual results
   <img width="1031" alt="screen shot 2018-04-20 at 14 58 49" 
src="https://user-images.githubusercontent.com/1834306/39035397-65880d84-44ac-11e8-88c8-ec1fb2275df2.png";>
   
   <img width="596" alt="screen shot 2018-04-20 at 15 09 19" 
src="https://user-images.githubusercontent.com/1834306/39035516-eda6e7a8-44ac-11e8-9e2f-58f637de5fb7.png";>
   
   ### Steps to reproduce
   Use a mysql engine, create a slice with time constraits, click the "View 
Query" button.
   
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services