1 month, 2 weeks ago Mike Treadgold

Does STRICT_TRANS_TABLES also set ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE, and NO_ZERO_IN_DATE, as it does for MySQL?

Reference: https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_strict_trans_tables

 
1 month, 2 weeks ago Ian Gilfillan

No, those changes were made in MySQL 5.7, not in MariaDB.

 
1 month, 1 week ago Mike Treadgold

Thank you!