https://bugs.documentfoundation.org/show_bug.cgi?id=160375
Bug ID: 160375
Summary: Base does not manage relationships outside the default
catalog/schema
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
I try to create relationships between two tables in different schema in Base
with: Tools -> Relationships...
If the tables are in the same catalog / schema it works but if the tables are
not in the same schema then it does not work.
Steps to Reproduce:
1. Open Base on connect to a database supporting catalog and/or schema
2. Create a new table: Table1, in default schema PUBLIC with a primary key
column ID auto-increment and a second column UID same type of ID.
2. create a new schema in Base with: Tools -> SQL... (ie: CREATE SCHEMA TEST
AUTHORIZATION DBA;)
3. Create a new table: Table1, in schema TEST with a primary key column ID
auto-increment with same type as PUBLIC.Table1.UID and a second column UID same
type of ID.
4. In Base open the foreign key management tool with: Tools -> Relationships...
and try to create a foreign key between the two tables PUBLIC.Table1 and
TEST.Table1
Actual Results:
You can not
Expected Results:
It would be better to be able to do this...
Reproducible: Always
User Profile Reset: No
Additional Info:
I found a way to make this work, but it's really a hack.
You have to start again at step 4 of how to reproduce.
4. create a new foreign key in Base with: Tools -> SQL... : ALTER TABLE
"PUBLIC"."PUBLIC"."Table1" ADD FOREIGN KEY ("UID") REFERENCES
"PUBLIC"."TEST"."Table1" ("ID") ON UPDATE CASCADE ON DELETE CASCADE;
5. Important: after creating this foreign key, close Base.
6. If you return to the management of foreign keys in Base then everything
works as it should (ie: Base manages the full name of the tables)
--
You are receiving this mail because:
You are the assignee for the bug.
