What happens?
I'm trying to get rid of sqlite and replace it with duckdb. One of the key requirement I have is smooth integration with dbeaver.
Seems like the current version of dbeaver (23.2.3) doesn't show constraints correctly for duckdb. I mean foreign key relationship is not correctly show in ER Diagram.
I hope this is the right place to create this particular issue.
Ideally it should be like below (screen shot from sqlite)
To Reproduce
- Install and connect dbeaver with duckdb as mentioned in the page https://duckdb.org/docs/guides/sql_editors/dbeaver
- Right click on the connection and create new sql script.
- Paste the following
CREATE TABLE students(id INTEGER PRIMARY KEY, name VARCHAR); CREATE TABLE exams(exam_id INTEGER REFERENCES students(id), grade INTEGER); INSERT INTO students VALUES (2, 'Student 2'); INSERT INTO exams VALUES (2, 20);
- Expand database and then right click on main and select View Diagram.
OS:
Windows
DuckDB Version:
0.91
DuckDB Client:
0.91
Full Name:
Vivek Kumar Jain
Affiliation:
ASML
Have you tried this on the latest main branch?
I have tested with a release build (and could not test with a main build)
Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?
What happens?
I'm trying to get rid of sqlite and replace it with duckdb. One of the key requirement I have is smooth integration with dbeaver.
Seems like the current version of dbeaver (23.2.3) doesn't show constraints correctly for duckdb. I mean foreign key relationship is not correctly show in ER Diagram.
I hope this is the right place to create this particular issue.
Ideally it should be like below (screen shot from sqlite)
To Reproduce
CREATE TABLE students(id INTEGER PRIMARY KEY, name VARCHAR); CREATE TABLE exams(exam_id INTEGER REFERENCES students(id), grade INTEGER); INSERT INTO students VALUES (2, 'Student 2'); INSERT INTO exams VALUES (2, 20);OS:
Windows
DuckDB Version:
0.91
DuckDB Client:
0.91
Full Name:
Vivek Kumar Jain
Affiliation:
ASML
Have you tried this on the latest
mainbranch?I have tested with a release build (and could not test with a main build)
Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?