Setting max_statement_time per query has no effect

[David Turner]

Cut and paste from developer:

> Do we have a good way of reporting bugs to Percona? I think I found some misbehavior.
>
> SET STATEMENT max_statement_time=1000 FOR SELECT * FROM server_file_journal
> seems to ignore the max_statement_time. Setting a max_statement_time at the session level works fine.
>
> http://www.percona.com/blog/2013/11/07/using-per-query-variable-statements-in-percona-server/)

[Muhammad Irfan (muhammad-irfan)]

I am able to reproduce this problem. max_statement_time works as expected when set on session level or global level (in my.cnf) but fails to work correctly when set on query level with SET STATEMENT. I tested on on Percona Server 5.6.16/5.6.20

mysql [localhost] {msandbox} (world) > show global variables like '%version%';
+-------------------------+-----------------------------------------------------------------+
| Variable_name | Value |
+-------------------------+-----------------------------------------------------------------+
| innodb_version | 5.6.16-rel64.1 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.16-64.1-rel64.1-log |
| version_comment | Percona Server with XtraDB (GPL), Release rel64.1, Revision 563 |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+-----------------------------------------------------------------+

mysql [localhost] {msandbox} (world) > show global variables like '%version%';
+-------------------------+--------------------------------------------------+
| Variable_name | Value |
+-------------------------+--------------------------------------------------+
| innodb_version | 5.6.20-rel68.0 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.20-68.0 |
| version_comment | Percona Server (GPL), Release 68.0, Revision 656 |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+--------------------------------------------------+

When set max_statement_time variable in my.cnf it works as expected as per below test results.

mysql [localhost] {msandbox} (world) > SELECT * FROM Country GROUP BY HeadOfState ORDER BY Continent;
ERROR 1882 (70101): Query execution was interrupted, max_statement_time exceeded

mysql [localhost] {msandbox} (world) > SELECT * FROM CountryLanguage GROUP BY IsOfficial ORDER BY Percentage DESC;
ERROR 1882 (70101): Query execution was interrupted, max_statement_time exceeded

Again, when one set on session level, it works correctly.

mysql [localhost] {msandbox} (world) > SET SESSION max_statement_time=1;
Query OK, 0 rows affected (0.00 sec)

mysql [localhost] {msandbox} ((none)) > SHOW VARIABLES LIKE 'max_statement_time';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| max_statement_time | 1 |
+--------------------+-------+
1 row i...

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1542