Bug #78225 Default NO_AUTO_CREATE_USER sql_mode behavior broke some tests
Submitted: 26 Aug 2015 13:35 Modified: 1 Sep 2015 20:28
Reporter: Alexander Soklakov Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:5.1.36 OS:Any
Assigned to: CPU Architecture:Any

[26 Aug 2015 13:35] Alexander Soklakov
Description:
NO_AUTO_CREATE_USER sql_mode behavior is the default in 5.7.7 after WL#8326.

That affects several test cases where GRANT is used for user creation.

How to repeat:
Run ConnectionRegressionTest with MySQL 5.7.7+

Suggested fix:
Use CREATE USER.
[1 Sep 2015 20:28] Daniel So
Added the following entry to the Connector/J 5.1.37 changelog:

"A number of regression tests in the testsuite failed when they were run against MySQL 5.7, because the NO_AUTO_CREATE_USER SQL mode had become the default behavior of the server since MySQL 5.7.7, making some GRANT statements in the test fail when a new user had to be created. With this fix, CREATE USER statements have been added to the regressions tests when needed, to prevent the test failures."