[Bug] session variables query_timeout and insert_timeout lose effect

[Hastyshell]

Search before asking

• I had searched in the issues and found no similar issues.

Version

master

What's Wrong?

As seen, both query_timeout and insert_timeout lose effect.

mysql> set query_timeout = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> set insert_timeout = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into lineorder select * from lineorder limit 10000000;
Query OK, 10000000 rows affected (8.89 sec)
{'label':'insert_a8fd968e3bf14732_a11221493ff412d2', 'status':'VISIBLE', 'txnId':'19'}

mysql> select * from lineorder limit 1000000;
1000000 rows in set (2.65 sec)

The certain info is that both the session variables are modified sucessfully.

mysql> select @@session.query_timeout;
+-----------------+
| @@query_timeout |
+-----------------+
|               1 |
+-----------------+
1 row in set (0.01 sec)

mysql> select @@session.insert_timeout;
+------------------+
| @@insert_timeout |
+------------------+
|                1 |
+------------------+
1 row in set (0.00 sec)

What You Expected?

The timeout execution should come out with a timeout result.

How to Reproduce?

1. Set query_timeout and insert_timeout to a small val.
2. Do a slow queries or insert.

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct