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 .
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. 
*** This bug has been marked as a duplicate of bug 17258 ***