After kill query, mysql_stmt_close() hangs for prepared stmt

[Sebastien FLAESCH]

Since MySQL 5.7 SQL interruption is broken in our application.

Did you ever CTRL-C a long running query with mysql command line tool? It works, because mysql.cc uses mysql_real_query(), but when using mysql_stmt_prepare() / mysql_bind_param() / mysql_stmt_execute() as our application there is a problem.

Just installed 8.0.29 and the problem gets worse: First it was limited to long running SELECT statements, now (since 8.0.x) UPDATE waiting for a lock is also broken...

Just giving a heads up here because I don't get much help on the reported bug ticket.

All details with sample program here:

https://bugs.mysql.com/bug.php?id=84470

BR
Seb