https://bugs.documentfoundation.org/show_bug.cgi?id=150854
Bug ID: 150854
Summary: LO Base Relationship->Relations dialog shows Delete
Options wrongly, using MariaDB
Product: LibreOffice
Version: 7.3.5.2 release
Hardware: x86-64 (AMD64)
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
Database: tables book and author and a bookauthors table connecting the many to
many relation between the two.
Base Tools->Relationships->Relations radio buttons does not indicate
constraints set in database correctly, particularly 'delete options'.
Steps to Reproduce:
1. Set a fk constraint to "delete no action" in 'mysql' utility.
2. Open Base Relationships, dblklick 1->n relation.
3. Save relations in Base and run 'show create table <tablename>;' in 'mysql'.
Actual Results:
Step 2 above: Relations dialog erroneously shows radio button "delete cascade"
active.
Step 3 above: Setting 'delete no action' is now absent.
Expected Results:
The state of Base Tools->Relationships radio buttons reflects constraints in
database.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.3.5.2 / LibreOffice Community
Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01
CPU threads: 4; OS: Mac OS X 10.13.6; UI render: default; VCL: osx
Locale: sv-SE (en_SE.UTF-8); UI: en-US
Calc: threaded
Using MariaDB 10.5.16
--
You are receiving this mail because:
You are the assignee for the bug.
