Page 2 of 2

Re: ER Diagrams

PostPosted: Fri Nov 07, 2014 5:57 am
by noanylove

Re: ER Diagrams

PostPosted: Sat Nov 08, 2014 2:06 pm
by Serge
Yep, it is a bug in SQLite metadata processing. It will be fixed in the next DBeaver version.
Thanks for report!

Re: ER Diagrams

PostPosted: Thu Dec 10, 2015 11:32 pm
by noanylove

Re: ER Diagrams

PostPosted: Fri Dec 11, 2015 1:04 pm
by Serge
It is a bug in SQLite JDBC driver.
It returns incorrect information about foreign keys (most likely due to a identical column names in linked tables).

Could you post a bug report to https://github.com/xerial/sqlite-jdbc ?

Re: ER Diagrams

PostPosted: Fri Dec 11, 2015 9:17 pm
by noanylove

Re: ER Diagrams

PostPosted: Fri Dec 11, 2015 10:45 pm
by Serge

Re: ER Diagrams

PostPosted: Sat Dec 12, 2015 3:56 am
by noanylove
Hello Serge,

I just posted an issue about getImportedKeys() and getPrimaryKeys() on https://github.com/xerial/sqlite-jdbc/issues/81, but not sure what they would think about.