[MDEV-10529] SELECT SLEEP(n) with MAX_STATEMENT_TIME produces no error - Jira

XML

Word

Printable

This is a minor problem, but I think it's natural to use the following query to test the behavior of max_statement_time:

MariaDB [(none)]> SET STATEMENT max_statement_time = 1 FOR SELECT SLEEP(10);

+-----------+

| SLEEP(10) |

+-----------+

|         1 |

+-----------+

1 row in set (1.01 sec)

The natural conclusion is that MAX_STATEMENT_TIME forces MariaDB to send the results it read until now, without any error. But this is not true:

MariaDB [test]> SET STATEMENT max_statement_time = 1 FOR SELECT * FROM t WHERE SLEEP(10);

ERROR 1969 (70100): Query execution was interrupted (max_statement_time exceeded)

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.