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
There should have been a step 2.5 in the 'Steps to Reproduce' section: Click to activate the Delete options 'no action' radio button. Sorry about that.
Have had a look at this with MariaDB on OpenSUSE 15.3 Direct connection from LO 7.3.6.2 When Base will show in relationships "Update cascade" and "Delete cascade" it will both be shown in PHPMyAdmin as "No action" If I try to Update a primary key, which is foreign key in the other table an error appers: Cannot delete or update a parent row: a foreign key constraint fails ("test"."Person", CONSTRAINT "Person_ibfk_1" FOREIGN KEY ("Sport_ID") REFERENCES "Sport" ("ID") ON DELETE NO ACTION ON UPDATE NO ACTION) /home/buildslave/source/libo-core/connectivity/source/drivers/mysqlc/mysqlc_general.cxx:119 So the shown connection in Base for direct connection to MariaDB is wrong. Tried the same with JDBC-connection (org.mariadb.jdbc.Driver, version mariadb-java-client-2.4.1.jar). Relation will be shown right way. So this seem to be a special bug of direct connection to MariaDB/MySQL.