[Koha-bugs] [Bug 23995] New: 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:26:46 CET 2019


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

            Bug ID: 23995
           Summary: Check constraints are supported differently by MySQL
                    and MariaDB so we should remove them for now.
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Database
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: martin.renvoize at ptfs-europe.com
        QA Contact: testopia at bugs.koha-community.org

We had two check constraints in kohastructure.. MariaDB and MySQL have now both
implimented support for such constraints, but decided to use different,
incompatible, syntaxes.  

As such, we should remove the current check constraints until a time when we
have a better understanding on how to work around these differences.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.


More information about the Koha-bugs mailing list