ER Diagrams

Note: please leave bug reports and feature requests on

Re: ER Diagrams

Postby noanylove » Fri Nov 07, 2014 5:57 am

Attachments
111111.png
111111.png (2.86 KiB) Viewed 29249 times
noanylove
 
Posts: 5
Joined: Fri Oct 24, 2014 8:28 pm

Re: ER Diagrams

Postby Serge » Sat Nov 08, 2014 2:06 pm

Yep, it is a bug in SQLite metadata processing. It will be fixed in the next DBeaver version.
Thanks for report!
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: ER Diagrams

Postby noanylove » Thu Dec 10, 2015 11:32 pm

Attachments
Capture.PNG
ER Diagram
Capture.PNG (6.04 KiB) Viewed 28792 times
noanylove
 
Posts: 5
Joined: Fri Oct 24, 2014 8:28 pm

Re: ER Diagrams

Postby Serge » Fri Dec 11, 2015 1:04 pm

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 ?
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: ER Diagrams

Postby noanylove » Fri Dec 11, 2015 9:17 pm

noanylove
 
Posts: 5
Joined: Fri Oct 24, 2014 8:28 pm

Re: ER Diagrams

Postby Serge » Fri Dec 11, 2015 10:45 pm

Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: ER Diagrams

Postby noanylove » Sat Dec 12, 2015 3:56 am

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.
noanylove
 
Posts: 5
Joined: Fri Oct 24, 2014 8:28 pm

Previous

Return to Support



Who is online

Users browsing this forum: No registered users and 10 guests