https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23914
Julian Maurice <julian.maur...@biblibre.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |julian.maur...@biblibre.com
--- Comment #5 from Julian Maurice <julian.maur...@biblibre.com> ---
(In reply to Martin Renvoize from comment #4)
> Also worth noting, CHECK constraints are not a mysqlism.. they're
> implemented in Postgres, MySQL, MariaDB, MSSQL to name but a few... the
> problem comes from how they're defined (or rather removed in this case).
In this case, I think the question should not be "is it a mysqlism ?" but
rather "is it supported by the RDBMS we support ?". And CHECK constraints
support was added in Mysql 8.0.16 and MariaDB 10.2.1. Previous versions accept
the syntax but ignore it.
I think we shouldn't rely on something that is ignored by a good part of RDBMS
(if we support Debian oldstable, MySQL version is 5.5 and MariaDB is 10.1)
--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
