[Koha-bugs] [Bug 10732] New: use a stricter SQL_MODE

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10732

            Bug ID: 10732
           Summary: use a stricter SQL_MODE
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: gmcharlt at gmail.com
          Reporter: gmcharlt at gmail.com
        QA Contact: testopia at bugs.koha-community.org

It would be nice to have Koha use a stricter MySQL/MariaDB SQL_MODE. 
Currently, Koha essentially expects that SQL_MODE is NULL.

In particular, STRICT_TRANS_TABLES would add better type checking -- for
example, no more inserting strings into an int field and expecting things to
magically work.

Another mode to consider is NO_ZERO_DATE [2].

It appears that MySQL on OS X ships with SQL_MODE set to a value that includes
STRICT_TRANS_TABLES; a user report indicates that at least one seed data script
cannot be loaded as a consequence. [3]

[1]
http://dev.mysql.com/doc/refman/5.6/en/server-sql-mode.html#sqlmode_strict_trans_tables
[2]
http://dev.mysql.com/doc/refman/5.6/en/server-sql-mode.html#sqlmode_no_zero_date
[3] http://lists.katipo.co.nz/pipermail/koha/2013-August/037031.html

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