[Koha-bugs] [Bug 23995] Check constraints are supported differently by MySQL and MariaDB so we should remove them for now.
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Nov 8 11:33:32 CET 2019
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23995
--- Comment #2 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
Mysql8 Manual:
`Foreign key referential actions (ON UPDATE, ON DELETE) are prohibited on
columns used in CHECK constraints. Likewise, CHECK constraints are prohibited
on columns used in foreign key referential actions.`
This is why the accountline check constraint must be dropped to support mysql8
(no such requirement in mariadb I believe)
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list