Comment 1 for bug 809033

Revision history for this message
Geert JM Vanderkelen (geertjmvdk) wrote :

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()