Bug #90256 Missing space in error message
Submitted: 29 Mar 2018 14:06 Modified: 16 Apr 2018 11:13
Reporter: Alexey Kopytov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:8.0.4 OS:Any
Assigned to: CPU Architecture:Any

[29 Mar 2018 14:06] Alexey Kopytov
Description:
Got the following message in the error log while testing MySQL 8.0.4:

---
2018-03-29T13:59:24.379119Z 11 [Warning] [MY-010235] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'caching_sha2_password' to rewrite authentication information(if any) for them: 'sbtest'@'localhost'
---

I guess it is missing a space before "(if any)". Source code
inspection suggests there's a similar message related to ALTER USER IF
EXISTS containing the same typo.

How to repeat:
Look at ER_SQL_USER_TABLE_CREATE_WARNING and 
ER_SQL_USER_TABLE_ALTER_WARNING in errmsg-utf8.txt.
[29 Mar 2018 17:07] MySQL Verification Team
Thank you for the bug report.

miguel@tikal:~/build/2018MAR25/mysql-8.0/share $ cat errmsg-utf8.txt | grep SQL_USER_TABLE_CREATE_WARNING -A1
ER_SQL_USER_TABLE_CREATE_WARNING
  eng "Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin '%s' to rewrite authentication information(if any) for them: %s"
[16 Apr 2018 11:13] Paul DuBois
Posted by developer:
 
Fixed in 8.0.12.

Cosmetic change. No changelog entry needed.