Code to reproduce:
import time import mysql.connector
def bug809033(): cnx = mysql.connector.connect(user='root',database='test') cnx2 = mysql.connector.connect(user='root',database='mysql')
cur = cnx.cursor() # Bad query cur.execute("SELECT * FROM mysql.time_zone AS t1 JOIN mysql.time_zone AS t2")
cur2 = cnx2.cursor() cur2.execute("KILL %d" % cnx.connection_id)
for row in cur: print(row)
cur.close() cnx.close() cur2.close() cnx2.close()
Code to reproduce:
import time
import mysql.connector
def bug809033(): .connect( user='root' ,database= 'test') .connect( user='root' ,database= 'mysql' )
cnx = mysql.connector
cnx2 = mysql.connector
cur = cnx.cursor() execute( "SELECT * FROM mysql.time_zone AS t1 JOIN mysql.time_zone AS t2")
# Bad query
cur.
cur2 = cnx2.cursor() execute( "KILL %d" % cnx.connection_id)
cur2.
for row in cur:
print(row)
cur.close()
cnx.close()
cur2.close()
cnx2.close()