zhaorui2022 opened a new issue, #21665: URL: https://github.com/apache/superset/issues/21665
After we upgrade superset to 2.0.0, we got user reports saying "Create View As" is broken and it shows an error message saying "No stored results found, you need to re-run your query", and if rerunning, it will complain the view already exists. After disabling SQLLAB_BACKEND_PERSISTENCE, it solves the issue. But SQLLAB_BACKEND_PERSISTENCE is set to True by default in 2.0.0. #### How to reproduce the bug 1. Go to SQL Lab's SQL editor 2. Select a database where it allows "Create View As" 3. Write any query 4. Click on "Create View As" button in the dropdown list next to "Run" button. And fill in the information as expected. 5. See the error on the UI. ### Expected results The UI should show it has successfully created the view with a link to explore the view immediately. ### Actual results Shows an error. #### Screenshots <img width="527" alt="Screen Shot 2022-09-30 at 11 13 55 AM" src="https://user-images.githubusercontent.com/105950525/193331778-73925f89-a131-4a68-8d54-f8d052c7d045.png";> ### Environment (please complete the following information): - browser type and version: N/A, not browser specific - superset version: 2.0.0 - python version: 3.8 - node.js version: not specific to node.js version - any feature flags active: has the error when SQLLAB_BACKEND_PERSISTENCE is set to true ### 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 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: [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/105950525/193331778-73925f89-a131-4a68-8d54-f8d052c7d045.png"](https://user-images.githubusercontent.com/105950525/193331778-73925f89-a131-4a68-8d54-f8d052c7d045.png"){kind=link}