max_execution_time hint is not effecting statement with sleep.

[ramanich1]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

drop table if exists t1;
CREATE TABLE t1 (a INT, b VARCHAR(300));
INSERT INTO t1 VALUES (1, 'string');
SELECT /*+ MAX_EXECUTION_TIME(1) */ *, SLEEP(5) FROM t1;

2. What did you expect to see? (Required)

mysql> SELECT /*+ MAX_EXECUTION_TIME(1) */ *, SLEEP(5) FROM t1;
ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded

3. What did you see instead (Required)

mysql> SELECT /*+ MAX_EXECUTION_TIME(1) */ *, SLEEP(5) FROM t1;
+------+--------+----------+
| a    | b      | SLEEP(5) |
+------+--------+----------+
|    1 | string |        1 |
+------+--------+----------+
1 row in set (0.04 sec

4. What is your TiDB version? (Required)

| Release Version: v6.0.0
Edition: Community
Git Commit Hash: 36a9810441ca0e496cbd22064af274b3be771081
Git Branch: heads/refs/tags/v6.0.0
UTC Build Time: 2022-03-31 10:33:28
GoVersion: go1.18
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |

[tiancaiamao]

Fixed by #17359