Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
mysql> set max_execution_time=5000;
Query OK, 0 rows affected (0.00 sec)
mysql> batch on id limit 200 update sbtest1 set k=1 where k is not null;
ERROR 1105 (HY000): context canceled
2. What did you expect to see? (Required)
The max_execution_time only affects read-only query.
3. What did you see instead (Required)
The non-transactional DML statement is affected by the variable.
4. What is your TiDB version? (Required)
v8.5.3
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
mysql> set max_execution_time=5000;
Query OK, 0 rows affected (0.00 sec)
mysql> batch on id limit 200 update sbtest1 set k=1 where k is not null;
ERROR 1105 (HY000): context canceled
2. What did you expect to see? (Required)
The
max_execution_timeonly affects read-only query.3. What did you see instead (Required)
The non-transactional DML statement is affected by the variable.
4. What is your TiDB version? (Required)
v8.5.3