Debian Codegraph @

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

raw
1
2
3 # 2011-11-15 - Added
4 #
5
6
7 SET @start_global_value = @@global.innodb_ft_enable_diag_print;
8 SELECT @start_global_value;
9
10 #
11 # exists as global only
12 #
13 --echo Valid values are 'ON' and 'OFF'
14 select @@global.innodb_ft_enable_diag_print in (0, 1);
15 select @@global.innodb_ft_enable_diag_print;
16 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
17 select @@session.innodb_ft_enable_diag_print;
18 show global variables like 'innodb_ft_enable_diag_print';
19 show session variables like 'innodb_ft_enable_diag_print';
20 --disable_warnings
21 select * from performance_schema.global_variables where variable_name='innodb_ft_enable_diag_print';
22 select * from performance_schema.session_variables where variable_name='innodb_ft_enable_diag_print';
23 --enable_warnings
24
25 #
26 # show that it's writable
27 #
28 set global innodb_ft_enable_diag_print='OFF';
29 select @@global.innodb_ft_enable_diag_print;
30 --disable_warnings
31 select * from performance_schema.global_variables where variable_name='innodb_ft_enable_diag_print';
32 select * from performance_schema.session_variables where variable_name='innodb_ft_enable_diag_print';
33 --enable_warnings
34 set @@global.innodb_ft_enable_diag_print=1;
35 select @@global.innodb_ft_enable_diag_print;
36 --disable_warnings
37 select * from performance_schema.global_variables where variable_name='innodb_ft_enable_diag_print';
38 select * from performance_schema.session_variables where variable_name='innodb_ft_enable_diag_print';
39 --enable_warnings
40 set global innodb_ft_enable_diag_print=0;
41 select @@global.innodb_ft_enable_diag_print;
42 --disable_warnings
43 select * from performance_schema.global_variables where variable_name='innodb_ft_enable_diag_print';
44 select * from performance_schema.session_variables where variable_name='innodb_ft_enable_diag_print';
45 --enable_warnings
46 set @@global.innodb_ft_enable_diag_print='ON';
47 select @@global.innodb_ft_enable_diag_print;
48 --disable_warnings
49 select * from performance_schema.global_variables where variable_name='innodb_ft_enable_diag_print';
50 select * from performance_schema.session_variables where variable_name='innodb_ft_enable_diag_print';
51 --enable_warnings
52 --error ER_GLOBAL_VARIABLE
53 set session innodb_ft_enable_diag_print='OFF';
54 --error ER_GLOBAL_VARIABLE
55 set @@session.innodb_ft_enable_diag_print='ON';
56
57 #
58 # incorrect types
59 #
60 --error ER_WRONG_TYPE_FOR_VAR
61 set global innodb_ft_enable_diag_print=1.1;
62 --error ER_WRONG_TYPE_FOR_VAR
63 set global innodb_ft_enable_diag_print=1e1;
64 --error ER_WRONG_VALUE_FOR_VAR
65 set global innodb_ft_enable_diag_print=2;
66 --error ER_WRONG_VALUE_FOR_VAR
67 set global innodb_ft_enable_diag_print=-3;
68 select @@global.innodb_ft_enable_diag_print;
69 --disable_warnings
70 select * from performance_schema.global_variables where variable_name='innodb_ft_enable_diag_print';
71 select * from performance_schema.session_variables where variable_name='innodb_ft_enable_diag_print';
72 --enable_warnings
73 --error ER_WRONG_VALUE_FOR_VAR
74 set global innodb_ft_enable_diag_print='AUTO';
75
76 #
77 # Cleanup
78 #
79
80 SET @@global.innodb_ft_enable_diag_print = @start_global_value;
81 SELECT @@global.innodb_ft_enable_diag_print;