Result Window Shows Incorrect Name & Updates Incorrect Table

Answered

When running ultiple queries across various tables in datagrip, the result window tabs show the table name of the first table.  Tested in MSSQL Connection to Azure SQL Databases.

For example 

SELECT * FROM tableOne

SELECT * FROM tableOne

SELECT * FROM tableTwo

 

All 3 tabs will show the name "tableOne".  When manipulating data in "tableTwo" and submitting changes, I get an error saying a column from tableOne doesn't exist in tableTwo.

 

While this wasnt an issue as the updated failed due to a missing column, I could see this causing problems for others if the original queries contained the same columns.

2 comments
Comment actions Permalink

Yes... I updated the wrong table and did not even know because it had the same column name. This alone can be a reason NOT to use this software because of potentially devastating consequences.

0

Please sign in to leave a comment.