Comment # 3 on bug 857349 from Kristyna Streitova

Regarding a comment 0:
======================

Sorry for a late answer. However according to my tests this problem should be
fixed now in openSUSE 13.1 and 13.2.

What I tried:
1) install mysql-community-server

2) start mysql

3) show the current sql_mode value:

mysql> show variables like 'sql_mode';
+---------------+--------------------------------------------+
| Variable_name | Value                                      |
+---------------+--------------------------------------------+
| sql_mode      | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+---------------+--------------------------------------------+
1 row in set (0.00 sec)

4) edit /etc/my.cnf
- remove sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
- set sql_mode=""

5) restart mysql

6) show the current sql_mode value:

mysql> show variables like 'sql_mode';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sql_mode      |       |
+---------------+-------+
1 row in set (0.00 sec)


So it seems that although the /usr/my.cnf file is created, it doesn't override
/etc/my.cnf anymore. Therefore I'm marking this bug as fixed. If you encounter
any further issues, please reopen this bug or file a new one. Thank you.



--------------------------------------------------------------------------------

Regarding a comment 2:
======================

This is a different problem from the one in the initial comment. It looks like
the same issue as the one in bug 842264. Which is fixed now. However if you
encounter any other problems please file a new bug for it or reopen the
corresponding bug. Thank you