"Create View As" functionality is broken after SQLLAB_BACKEND_PERSISTENCE is set to True

[zhaorui2022]

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

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!

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

Additional context

Add any other context about the problem here.

[zhaorui2022]

If anyone else also experience this issue, can we set this feature flag to False by default in upcoming patch releases? We had the feature flag enabled for 2 days, and after disabling it, users were reporting their previous query tabs were reset to the default one (no query history, and all queries become "SELECT * FROM WHERE")

[mayurnewase]

couldn't reproduce on latest master (last sha: 8f74e46d45ca94f5656f7b881f1096c16657c829)

[eschutho]

I tested this in 2.0.1 and it seems to work, too. I'll close this ticket since it was verified as fixed on master as well.