Bug #77908 German translation for ER_WARN_USING_OTHER_HANDLER is wrong.

• Submitted: 2 Aug 2015 8:02
• Modified: 3 Aug 2015 5:59
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Server: Errors
• Severity: S3 (Non-critical)
• Version: 5.6.25, 5.7.7, 5.6.26, 5.6.27
• OS: Any
• CPU Architecture: Any
• Tags: ger, german, translation

[2 Aug 2015 8:02] Daniël van Eeden

Description:
For the ger translation of ER_WARN_USING_OTHER_HANDLER the order of %s is swapped.

How to repeat:
mysql-5.6.25 > SET sql_mode = ''; 
Query OK, 0 rows affected (0.01 sec)

mysql-5.6.25 > SET lc_messages = de_DE;
Query OK, 0 rows affected (0.00 sec)

mysql-5.6.25 > CREATE TABLE t1 (id int) ENGINE=FOOBAR;
Query OK, 0 rows affected, 2 warnings (0.05 sec)

mysql-5.6.25 > SHOW WARNINGS;
+---------+------+-------------------------------------------------------+
| Level   | Code | Message                                               |
+---------+------+-------------------------------------------------------+
| Warning | 1286 | Unbekannte Speicher-Engine 'FOOBAR'                   |
| Warning | 1266 | Für Tabelle 'InnoDB' wird Speicher-Engine t1 benutzt  |
+---------+------+-------------------------------------------------------+
2 rows in set (0.00 sec)

mysql-5.6.25 > SET lc_messages = en_US;
Query OK, 0 rows affected (0.00 sec)

mysql-5.6.25 > DROP TABLE t1;
Query OK, 0 rows affected (0.02 sec)

mysql-5.6.25 > CREATE TABLE t1 (id int) ENGINE=FOOBAR;
Query OK, 0 rows affected, 2 warnings (0.05 sec)

mysql-5.6.25 > SHOW WARNINGS;
+---------+------+--------------------------------------------+
| Level   | Code | Message                                    |
+---------+------+--------------------------------------------+
| Warning | 1286 | Unknown storage engine 'FOOBAR'            |
| Warning | 1266 | Using storage engine InnoDB for table 't1' |
+---------+------+--------------------------------------------+
2 rows in set (0.00 sec)

[3 Aug 2015 5:59] MySQL Verification Team

Hello Daniel,

Thank you for the report.
Verified as described on 5.6.25, 5.6.26 and 5.6.27 builds.

Thanks,
Umesh

[3 Aug 2015 6:00] MySQL Verification Team

// 5.6.25/5.6.26/5.6.27

mysql>  SET sql_mode = '';
Query OK, 0 rows affected (0.00 sec)

mysql> SET lc_messages = de_DE;
Query OK, 0 rows affected (0.01 sec)

mysql> CREATE TABLE t1 (id int) ENGINE=FOOBAR;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

mysql> show warnings;
+---------+------+-------------------------------------------------------+
| Level   | Code | Message                                               |
+---------+------+-------------------------------------------------------+
| Warning | 1286 | Unbekannte Speicher-Engine 'FOOBAR'                   |
| Warning | 1266 | Für Tabelle 'InnoDB' wird Speicher-Engine t1 benutzt  |
+---------+------+-------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> SET lc_messages = en_US;
Query OK, 0 rows affected (0.00 sec)

mysql> DROP TABLE t1;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE t1 (id int) ENGINE=FOOBAR;
Query OK, 0 rows affected, 2 warnings (0.00 sec)

mysql>  SHOW WARNINGS;
+---------+------+--------------------------------------------+
| Level   | Code | Message                                    |
+---------+------+--------------------------------------------+
| Warning | 1286 | Unknown storage engine 'FOOBAR'            |
| Warning | 1266 | Using storage engine InnoDB for table 't1' |
+---------+------+--------------------------------------------+
2 rows in set (0.00 sec)