Debian Codegraph @

mysql-test/suite/sys_vars/t/log_throttle_qni_basic.test

raw
1 ################## mysql-test\t\log_queries_not_using_indexes_basic.test ######
2 # #
3 # Variable Name: log_throttle_queries_not_using_indexes #
4 # Scope: Global #
5 # Access Type: Dynamic #
6 # Data Type: #
7 # #
8 # #
9 # Creation Date: 2011-11-07 #
10 # Author : Azundris (tnuernbe) #
11 # #
12 # Description:Test Cases of Dynamic System Variable #
13 # log_throttle_queries_not_using_indexes #
14 # that checks the behavior of this variable in the following ways #
15 # * Value Check #
16 # * Scope Check #
17 # #
18 # Reference: #
19 # http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html #
20 # #
21 ###############################################################################
22
23 SET @start_value= @@global.log_throttle_queries_not_using_indexes;
24
25 SET @@global.log_throttle_queries_not_using_indexes= DEFAULT;
26 SELECT @@global.log_throttle_queries_not_using_indexes;
27
28 SET @@global.log_throttle_queries_not_using_indexes= 1000;
29 SELECT @@global.log_throttle_queries_not_using_indexes;
30
31 # should throw a clipping warning
32 SET @@global.log_throttle_queries_not_using_indexes= -1;
33 SELECT @@global.log_throttle_queries_not_using_indexes;
34
35 SET @@global.log_throttle_queries_not_using_indexes= 5;
36 SELECT @@global.log_throttle_queries_not_using_indexes;
37
38 --error ER_WRONG_TYPE_FOR_VAR
39 SET @@global.log_throttle_queries_not_using_indexes= OFF;
40 SELECT @@global.log_throttle_queries_not_using_indexes;
41
42 --error ER_WRONG_TYPE_FOR_VAR
43 SET @@global.log_throttle_queries_not_using_indexes= ON;
44 SELECT @@global.log_throttle_queries_not_using_indexes;
45
46 --error ER_WRONG_TYPE_FOR_VAR
47 SET GLOBAL log_throttle_queries_not_using_indexes= 0.01;
48
49 --error ER_GLOBAL_VARIABLE
50 SET SESSION log_throttle_queries_not_using_indexes= 0;
51
52 --error ER_GLOBAL_VARIABLE
53 SET LOCAL log_throttle_queries_not_using_indexes= 0;
54
55 SET @@global.log_throttle_queries_not_using_indexes= @start_value;