https://bugs.documentfoundation.org/show_bug.cgi?id=150854
Robert Großkopf changed:
What|Removed |Added
Ever confirmed|0 |1
OS|macOS (All) |All
CC||rob...@familiegrosskopf.de
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 ---
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.