DataGrip Sqlite foreign key and index bugs?

I have just been trying to work on a new sqlite database in DataGrip and have encountered several errors.

For tables with a foreign keys the foreign key appears in the database browser window with a name that begins with '#FAKE_...'.

Also the database browser and dialogs indicate an index is unique regardless of whether or not it is unique.

Finally modifying a table, index, or foreign key through the built-in dialog often results in SQL that does not maintain the original table structure exactly.  Often it will not execute without errors.

I'm not entirely sure if I'm missing something somewhere or if these are bugs?

My sqlite version is 3.8.9

3 comments
Comment actions Permalink

Hello Andrew,

Currently SQLite database is introspected by jdbc driver which may often be not precise. There are related issues logged:

https://youtrack.jetbrains.com/issue/DBE-2163https://youtrack.jetbrains.com/issue/DBE-2194 . What is the Test Connection output for the SQlite Data Source?

0
Comment actions Permalink

It looks like you have identified some of the issues already although there are others.  I have attached the output of the test connection.  Perhaps the driver needs some work.

0
Comment actions Permalink

Thank you. I've created the https://youtrack.jetbrains.com/issue/DBE-2318 issue. You may follow it for updates. If there are any details you may add to the issue (examples of wrongly detected DDL and original DDL for a table) it would be greatly appreciated.

0

Please sign in to leave a comment.