akzarma opened a new issue, #23610: URL: https://github.com/apache/superset/issues/23610
There is wrong assignment of object_type [here](https://github.com/apache/superset/blob/master/superset/models/sql_lab.py#LL374C1-L375C1) Due to which, saved_query list API fails to load (when used databases except on sqlite - probably because sqlite does not strictly check enum type of object_type) #### How to reproduce the bug 1. Setup backend database as postgres, Go to 'Saved Queries' page 2. You'll see an error popup right away and there are no saved queries shown. ### Expected results There should not be any error and saved queries should load fine ### Actual results - Shows error popup with sql error and there is no row of saved queries. #### Screenshots <img width="1509" alt="Screenshot 2023-04-06 at 4 51 32 PM" src="https://user-images.githubusercontent.com/25038017/230376783-c2a7efbf-b004-4cf9-b939-f06cd200910f.png";> ### Environment (please complete the following information): browser type and version: superset version: 2.1.0 python version: 3.9.14 node.js version: 16.17.1 any feature flags active: TAGGING_SYSTEM ### 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. - [ ] I have reproduced the issue with at least the latest released version of superset. - [ ] I have checked the issue tracker for the same issue and I haven't found one similar. -- 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]
![https://user-images.githubusercontent.com/25038017/230376783-c2a7efbf-b004-4cf9-b939-f06cd200910f.png"](https://user-images.githubusercontent.com/25038017/230376783-c2a7efbf-b004-4cf9-b939-f06cd200910f.png"){kind=link}