[Koha-bugs] [Bug 23914] Hea - share the DBMS (name and version)

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23914

Julian Maurice <julian.maurice at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |julian.maurice at biblibre.com

--- Comment #5 from Julian Maurice <julian.maurice at 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.