Updating rows in editor fails
I have loaded a data table in DataGrip. When I make edits to the table and click Submit, I get an error message saying 'Function not yet implemented'. This appears to be coming from the database JDBC driver (Mimer SQL - listed under basic support).
Looking at a preview of the SQL update statement in the DML Preview, I see the following SQL is generated:
UPDATE TABLE t
SET t.COLUMN = 'N'
WHERE t.PKEY LIKE '0001' ESCAPE '#';
-- Doesn't work - driver error
Running this SQL directly in a console also fails with the same driver error, as I would expect. However, removing the alias for the table seems to fix the issue.
UPDATE TABLE
SET COLUMN = 'N'
WHERE PKEY LIKE '0001' ESCAPE '#';
-- Works fine
I appreciate this is an issue with the provider JDBC driver, but is there any way to get DataGrip to generate update statements like the second statement, rather than using the table alias?
Thanks
Please sign in to leave a comment.
Thank you for contacting us.
That's correct, support for table aliasing has not been implemented. Due to having very limited functionality in the basic drivers, we have reported it as a feature request:
https://youtrack.jetbrains.com/issue/DBE-17061/Support-for-table-aliasing-in-Mimer-SQL
Please upvote so it can get more attention. See how to use the platform:
https://intellij-support.jetbrains.com/hc/en-us/articles/207241135