Debian Codegraph @

mysql-test/suite/sys_vars/r/log_throttle_qni_basic.result

raw
1 SET @start_value= @@global.log_throttle_queries_not_using_indexes;
2 SET @@global.log_throttle_queries_not_using_indexes= DEFAULT;
3 SELECT @@global.log_throttle_queries_not_using_indexes;
4 @@global.log_throttle_queries_not_using_indexes
5 0
6 SET @@global.log_throttle_queries_not_using_indexes= 1000;
7 SELECT @@global.log_throttle_queries_not_using_indexes;
8 @@global.log_throttle_queries_not_using_indexes
9 1000
10 SET @@global.log_throttle_queries_not_using_indexes= -1;
11 Warnings:
12 Warning 1292 Truncated incorrect log_throttle_queries_not_using_indexes value: '-1'
13 SELECT @@global.log_throttle_queries_not_using_indexes;
14 @@global.log_throttle_queries_not_using_indexes
15 0
16 SET @@global.log_throttle_queries_not_using_indexes= 5;
17 SELECT @@global.log_throttle_queries_not_using_indexes;
18 @@global.log_throttle_queries_not_using_indexes
19 5
20 SET @@global.log_throttle_queries_not_using_indexes= OFF;
21 ERROR 42000: Incorrect argument type to variable 'log_throttle_queries_not_using_indexes'
22 SELECT @@global.log_throttle_queries_not_using_indexes;
23 @@global.log_throttle_queries_not_using_indexes
24 5
25 SET @@global.log_throttle_queries_not_using_indexes= ON;
26 ERROR 42000: Incorrect argument type to variable 'log_throttle_queries_not_using_indexes'
27 SELECT @@global.log_throttle_queries_not_using_indexes;
28 @@global.log_throttle_queries_not_using_indexes
29 5
30 SET GLOBAL log_throttle_queries_not_using_indexes= 0.01;
31 ERROR 42000: Incorrect argument type to variable 'log_throttle_queries_not_using_indexes'
32 SET SESSION log_throttle_queries_not_using_indexes= 0;
33 ERROR HY000: Variable 'log_throttle_queries_not_using_indexes' is a GLOBAL variable and should be set with SET GLOBAL
34 SET LOCAL log_throttle_queries_not_using_indexes= 0;
35 ERROR HY000: Variable 'log_throttle_queries_not_using_indexes' is a GLOBAL variable and should be set with SET GLOBAL
36 SET @@global.log_throttle_queries_not_using_indexes= @start_value;