Bug #79957 Error message uses UK English, not US English

• Submitted: 13 Jan 2016 16:08
• Modified: 18 Jan 2016 13:52
• Reporter: Paul DuBois
• Status: Closed
• Category: MySQL Server: Errors
• Severity: S3 (Non-critical)
• Version: 5.7.11
• OS: Any
• CPU Architecture: Any

[13 Jan 2016 16:08] Paul DuBois

Description:
5.7.11 introduced deprecation warnings for bit operations on BINARY/VARBINARY arguments.
The deprecation warning uses UK English, rather than US English.

How to repeat:
Example script:

DROP TABLE IF EXISTS t;
CREATE TABLE t(vbin VARBINARY(32));
INSERT INTO t VALUES (x'59');
SELECT HEX(vbin & vbin) FROM t;
SHOW WARNINGS\G

Result of running script:

mysql> DROP TABLE IF EXISTS t;
Query OK, 0 rows affected (0.02 sec)

mysql> CREATE TABLE t(vbin VARBINARY(32));
Query OK, 0 rows affected (0.03 sec)

mysql> INSERT INTO t VALUES (x'59');
Query OK, 1 row affected (0.01 sec)

mysql> SELECT HEX(vbin & vbin) FROM t;
+------------------+
| HEX(vbin & vbin) |
+------------------+
| 0                |
+------------------+
1 row in set, 3 warnings (0.00 sec)

mysql> SHOW WARNINGS\G
*************************** 1. row ***************************
  Level: Warning
   Code: 1287
Message: Bitwise operations on BINARY will change behaviour in a future version, check the 'Bit functions' section in the manual.
*************************** 2. row ***************************
  Level: Warning
   Code: 1292
Message: Truncated incorrect INTEGER value: 'Y'
*************************** 3. row ***************************
  Level: Warning
   Code: 1292
Message: Truncated incorrect INTEGER value: 'Y'
3 rows in set (0.00 sec)

Suggested fix:
Change "behaviour" to "behavior" in the warning.

[13 Jan 2016 18:07] MySQL Verification Team

Thank you for the bug report.

C:\dbs>c:\dbs\5.7\bin\mysql -uroot -p --port=3570 --prompt="mysql 5.7 > "
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.11 Source distribution PULL: 2015-DEC-27

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 5.7 > use test
Database changed
mysql 5.7 > DROP TABLE IF EXISTS t;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql 5.7 > CREATE TABLE t(vbin VARBINARY(32));
Query OK, 0 rows affected (0.03 sec)

mysql 5.7 > INSERT INTO t VALUES (x'59');
Query OK, 1 row affected (0.00 sec)

mysql 5.7 > SELECT HEX(vbin & vbin) FROM t;
+------------------+
| HEX(vbin & vbin) |
+------------------+
| 0                |
+------------------+
1 row in set, 3 warnings (0.00 sec)

mysql 5.7 > SHOW WARNINGS\G
*************************** 1. row ***************************
  Level: Warning
   Code: 1287
Message: Bitwise operations on BINARY will change behaviour in a future version, check the 'Bit functions' section in the manual.
*************************** 2. row ***************************
  Level: Warning
   Code: 1292
Message: Truncated incorrect INTEGER value: 'Y'
*************************** 3. row ***************************
  Level: Warning
   Code: 1292
Message: Truncated incorrect INTEGER value: 'Y'
3 rows in set (0.00 sec)

mysql 5.7 >

[18 Jan 2016 13:52] Paul DuBois

Fixed in 5.7.12.

Cosmetic change. No changelog entry needed.