Issue with unbuffered cursor

[hiepnq94]

If the previous query isn't iterated to the end, the subsequent query raises pymysql.err.InternalError: Packet sequence number wrong with a warning RuntimeWarning: coroutine 'MySQLResult._finish_unbuffered_query' was never awaited.

Reproduction:

# with cursorclass=SSCursor set in connection
async with conn.cursor() as cur:
    await cur.execute("""SELECT 1""")
    await cur.execute("""SELECT 2""")
    # raise

It seems the problem is in this line, as it should be await-ed:

aiomysql/aiomysql/connection.py

Line 650 in 45d241e

self._result._finish_unbuffered_query()

(python 3.10.0, aiomysql 0.0.22)

[Nothing4You]

thanks for the report!