5.7.0 does not like removing NO_AUTO_CREATE_USER so lets keep that th…

…ere as it is not relvant to test_escape_string
srlindsay · Aug 26, 2015 · 96f24ef · 96f24ef
1 parent 2d371cc
commit 96f24ef
Showing 1 changed file with 2 additions and 1 deletion.
diff --git a/pymysql/tests/test_connection.py b/pymysql/tests/test_connection.py
@@ -90,7 +90,8 @@ def test_escape_string(self):
         cur = con.cursor()
 
         self.assertEqual(con.escape("foo'bar"), "'foo\\'bar'")
-        cur.execute("SET sql_mode='NO_BACKSLASH_ESCAPES'")
+        # added NO_AUTO_CREATE_USER as not including it in 5.7 generates warnings
+        cur.execute("SET sql_mode='NO_BACKSLASH_ESCAPES,NO_AUTO_CREATE_USER'")
         self.assertEqual(con.escape("foo'bar"), "'foo''bar'")
 
     def test_escape_builtin_encoders(self):