https://bugs.documentfoundation.org/show_bug.cgi?id=150854
Robert Großkopf <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 OS|macOS (All) |All CC| |[email protected] Status|UNCONFIRMED |NEW Summary|LO Base |LO Base |Relationship->Relations |Relationship->Relations |dialog shows Delete Options |dialog shows Delete Options |wrongly, using MariaDB |wrongly, using MariaDB and | |direct connection (not | |JDBC) --- Comment #2 from Robert Großkopf <[email protected]> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
