[GitHub] [superset] jinghua-qa opened a new issue #19453: [dataset] dttm will change to string type for virtual dataset in sqlite

[GitBox <gi...@apache.org>]

jinghua-qa opened a new issue #19453:
URL: https://github.com/apache/superset/issues/19453


   dttm will change to string type for virtual dataset in sqlite, this issue is sqlite only, can not reproduce in other db 
   
   #### How to reproduce the bug
   1, connect to sqlite db
   2, go to sql lab, select datetime column and run query
   3, open dataset in explore
   4, click dataset edit and look for the datetime column for data type
   
   ### Expected results
   datetime column should show type in datetime in virtual dataset for sqlite
   
   
   ### Actual results
   datetime column show type in string in virtual dataset for sqlite
   
   #### Screenshots
   
   https://user-images.githubusercontent.com/81597121/160977186-5dae1174-d4d6-468d-80cc-d7f903358792.mov
   
   
   If applicable, add screenshots to help explain your problem.
   
   
   ### Environment
   
   (please complete the following information):
   
   - browser type and version:
   - superset version: `superset master`
   - python version: `python --version`
   - node.js version: `node -v`
   - 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
   
   Add any other context about the problem here.
   


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org