View the query that the IDE is running for updating / deleting a row
For some very strange reason, the IDE will sometimes fail to update or delete rows. It happens on certain tables, and it happens when you are sorting by a column sometimes. Is there a way to see what query the IDE is actually running? I'd love to know what type of UPDATE / DELETE query it is issuing and why it would be failing.
(It is also next to impossible to open a bug report for it without this information).
Please sign in to leave a comment.
Hello Luke,
>For some very strange reason, the IDE will sometimes fail to update or delete rows.
If there are any problems happened when IDE was trying to execute corresponding SQL - they are written in status bar at the bttom. Do you see any errors/warnings when it happens? Do you have Auto-commit option enabled in Table Editor?
DataGrip does not show sql update/delete queries which are being issued when you manipulate data in Table Editor.
Hello. I need to show/confirm SQL before update / delete, to use force index(for example). Is possible?