morristech
diff --git a/‎MySQLdb/cursors.py
Copy file name to clipboardExpand all lines: MySQLdb/cursors.py
+1-1Lines changed: 1 addition & 1 deletion b/‎MySQLdb/cursors.py
Copy file name to clipboardExpand all lines: MySQLdb/cursors.py
+1-1Lines changed: 1 addition & 1 deletion
diff --git a/‎tests/test_cursor.py
Copy file name to clipboardExpand all lines: tests/test_cursor.py
+4Lines changed: 4 additions & 0 deletions b/‎tests/test_cursor.py
Copy file name to clipboardExpand all lines: tests/test_cursor.py
+4Lines changed: 4 additions & 0 deletions
@@ -26,7 +26,7 @@
 #: executemany only supports simple bulk insert.
 #: You can use it to load large dataset.
 RE_INSERT_VALUES = re.compile(
-    r"\s*((?:INSERT|REPLACE)\s.+\sVALUES?\s+)" +
+    r"\s*((?:INSERT|REPLACE)\b.+\bVALUES?\s*)" +
     r"(\(\s*(?:%s|%\(.+\)s)\s*(?:,\s*(?:%s|%\(.+\)s)\s*)*\))" +
     r"(\s*(?:ON DUPLICATE.*)?);?\s*\Z",
     re.IGNORECASE | re.DOTALL)
 
@@ -49,6 +49,10 @@ def test_executemany():
     assert m is not None, 'error parse %(id_name)s'
     assert m.group(3) == ' ON duplicate update', 'group 3 not ON duplicate update, bug in RE_INSERT_VALUES?'
 
+    # https://github.com/PyMySQL/mysqlclient-python/issues/178
+    m = MySQLdb.cursors.RE_INSERT_VALUES.match("INSERT INTO bloup(foo, bar)VALUES(%s, %s)")
+    assert m is not None
+
     # cursor._executed myst bee "insert into test (data) values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9)"
     # list args
     data = range(10)