Modify view > Open query to console does not pull code for the correct view Follow

Hello,

Could you please attach screenshots demonstrating the issue? It seems to work fine on my side.

Yes, I have attached the screenshots; hopefully it still makes sense with the info redacted.

When I right click and select modify view on the view ag_____vw, I click the "open query to console" button as shown in the red circle.

What is populated in the new query window is the code for a different view, qu____vw. This is my first issue, as this is not the view I clicked on and not the view I want the code for.

Here is a snippet of the code that appears under this ALTER VIEW command:

This is not the correct code. When I right click on qu___vw and generate the DDL:

This is the same section of code, with the correct and most recent update:

Let me know if that makes sense.

Thanks for the screenshots.

Seems there are two points:

1. "Open in console" uses some cached console and it seems to be a bug.

2. When there are no changes in view then "Preview" is also empty and no code is shown in console. Please try to change view - it will fill "Preview" with code and it should be also shown in console.

I guess I don't understand the second point. When I change the name of the view, there is code generated in the preview box to change the view name. If I click OK, it changes the name of the view and closes, but if I click "open query to console" after changing the view name it still generates the code for the incorrect view.

Thanks for information. I reported issue on YouTrack: https://youtrack.jetbrains.com/issue/DBE-17567/Modify-View.-Open-query-in-console-does-not-pull-code-for-the-correct-view 

Please follow it for updates.