https://bugs.documentfoundation.org/show_bug.cgi?id=160339
Bug ID: 160339
Summary: How Base relationships react at table or column
renaming
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
Hi,
If I use jdbcDriverOOo[1] with Base, I have problems after renaming a table or
column in Base at the relationship management level.
Although I have carried out all the necessary renaming of the indexes and keys
involved in this renaming, this is not enough and I cannot get it to work
satisfactorily.
In fact for the moment the only way to be able to manage foreign keys after
renaming a table or a column, which is referenced by this foreign key, is to
refresh the list of tables in Base using the menu: View -> Refresh Tables.
Maybe I'm missing something?
Steps to Reproduce:
1. In Base create a foreign key between two tables.
2. Rename one of the tables then one of the columns involved in the foreign
key.
3. After each renaming, go to the foreign key management with the menu: Tools
-> Relationships...
Actual Results:
After renaming the relationships are not displayed correctly.
Expected Results:
After renaming the relationships are displayed correctly.
Reproducible: Always
User Profile Reset: No
Additional Info:
If after renaming, you reload the tables using the menu: View -> Refresh
Tables, then the display of the relationships is correct.
If it turns out that this is the solution, wouldn't Base detect that there has
been a renaming and reload the tables right after?
[1] https://prrvchr.github.io/jdbcDriverOOo/#what-has-been-done-for-version-130
--
You are receiving this mail because:
You are the assignee for the bug.
