The SQL mode configured at the time of creation is not automatically modified per the following MariaDB document:
SQL_MODE
Globally, upgrading to MariaDB version 10.2 or higher will automatically enable strict mode and remove any existing sql_mode entries in the /etc/my.cnf. This is by-design due how MariaDB implements the change. After the initial upgrade to MariaDB 10.2, you'd need to manually add the following value under the [mysqld] section in the /etc/my.cnf file if you want to revert this change:
sql_mode=NO_ENGINE_SUBSTITUTION
Then, restart MariaDB to apply the changes. Once your system is using MariaDB 10.2, the future minor updates will not require that you manually update the sql_mode value again.
Chinese
English