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

2 comments
Comment actions Permalink

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.

0
Comment actions Permalink

Hello. I need to show/confirm SQL before update / delete, to use force index(for example). Is possible?

0

Please sign in to leave a comment.