Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_ft_enable_stopword;
2 SELECT @start_global_value;
3 @start_global_value
4 1
5 Valid values are 'ON' and 'OFF'
6 select @@global.innodb_ft_enable_stopword in (0, 1);
7 @@global.innodb_ft_enable_stopword in (0, 1)
8 1
9 select @@global.innodb_ft_enable_stopword;
10 @@global.innodb_ft_enable_stopword
11 1
12 select @@session.innodb_ft_enable_stopword in (0, 1);
13 @@session.innodb_ft_enable_stopword in (0, 1)
14 1
15 select @@session.innodb_ft_enable_stopword;
16 @@session.innodb_ft_enable_stopword
17 1
18 show global variables like 'innodb_ft_enable_stopword';
19 Variable_name Value
20 innodb_ft_enable_stopword ON
21 show session variables like 'innodb_ft_enable_stopword';
22 Variable_name Value
23 innodb_ft_enable_stopword ON
24 select * from performance_schema.global_variables where variable_name='innodb_ft_enable_stopword';
25 VARIABLE_NAME VARIABLE_VALUE
26 innodb_ft_enable_stopword ON
27 select * from performance_schema.session_variables where variable_name='innodb_ft_enable_stopword';
28 VARIABLE_NAME VARIABLE_VALUE
29 innodb_ft_enable_stopword ON
30 set global innodb_ft_enable_stopword='OFF';
31 set session innodb_ft_enable_stopword='OFF';
32 select @@global.innodb_ft_enable_stopword;
33 @@global.innodb_ft_enable_stopword
34 0
35 select @@session.innodb_ft_enable_stopword;
36 @@session.innodb_ft_enable_stopword
37 0
38 select * from performance_schema.global_variables where variable_name='innodb_ft_enable_stopword';
39 VARIABLE_NAME VARIABLE_VALUE
40 innodb_ft_enable_stopword OFF
41 select * from performance_schema.session_variables where variable_name='innodb_ft_enable_stopword';
42 VARIABLE_NAME VARIABLE_VALUE
43 innodb_ft_enable_stopword OFF
44 set @@global.innodb_ft_enable_stopword=1;
45 set @@session.innodb_ft_enable_stopword=1;
46 select @@global.innodb_ft_enable_stopword;
47 @@global.innodb_ft_enable_stopword
48 1
49 select @@session.innodb_ft_enable_stopword;
50 @@session.innodb_ft_enable_stopword
51 1
52 select * from performance_schema.global_variables where variable_name='innodb_ft_enable_stopword';
53 VARIABLE_NAME VARIABLE_VALUE
54 innodb_ft_enable_stopword ON
55 select * from performance_schema.session_variables where variable_name='innodb_ft_enable_stopword';
56 VARIABLE_NAME VARIABLE_VALUE
57 innodb_ft_enable_stopword ON
58 set global innodb_ft_enable_stopword=0;
59 set session innodb_ft_enable_stopword=0;
60 select @@global.innodb_ft_enable_stopword;
61 @@global.innodb_ft_enable_stopword
62 0
63 select @@session.innodb_ft_enable_stopword;
64 @@session.innodb_ft_enable_stopword
65 0
66 select * from performance_schema.global_variables where variable_name='innodb_ft_enable_stopword';
67 VARIABLE_NAME VARIABLE_VALUE
68 innodb_ft_enable_stopword OFF
69 select * from performance_schema.session_variables where variable_name='innodb_ft_enable_stopword';
70 VARIABLE_NAME VARIABLE_VALUE
71 innodb_ft_enable_stopword OFF
72 set @@global.innodb_ft_enable_stopword='ON';
73 set @@session.innodb_ft_enable_stopword='ON';
74 select @@global.innodb_ft_enable_stopword;
75 @@global.innodb_ft_enable_stopword
76 1
77 select @@session.innodb_ft_enable_stopword;
78 @@session.innodb_ft_enable_stopword
79 1
80 select * from performance_schema.global_variables where variable_name='innodb_ft_enable_stopword';
81 VARIABLE_NAME VARIABLE_VALUE
82 innodb_ft_enable_stopword ON
83 select * from performance_schema.session_variables where variable_name='innodb_ft_enable_stopword';
84 VARIABLE_NAME VARIABLE_VALUE
85 innodb_ft_enable_stopword ON
86 set global innodb_ft_enable_stopword=1.1;
87 ERROR 42000: Incorrect argument type to variable 'innodb_ft_enable_stopword'
88 set session innodb_ft_enable_stopword=1.1;
89 ERROR 42000: Incorrect argument type to variable 'innodb_ft_enable_stopword'
90 set global innodb_ft_enable_stopword=1e1;
91 ERROR 42000: Incorrect argument type to variable 'innodb_ft_enable_stopword'
92 set session innodb_ft_enable_stopword=1e1;
93 ERROR 42000: Incorrect argument type to variable 'innodb_ft_enable_stopword'
94 set global innodb_ft_enable_stopword=2;
95 ERROR 42000: Variable 'innodb_ft_enable_stopword' can't be set to the value of '2'
96 set session innodb_ft_enable_stopword=2;
97 ERROR 42000: Variable 'innodb_ft_enable_stopword' can't be set to the value of '2'
98 set global innodb_ft_enable_stopword='AUTO';
99 ERROR 42000: Variable 'innodb_ft_enable_stopword' can't be set to the value of 'AUTO'
100 set session innodb_ft_enable_stopword='AUTO';
101 ERROR 42000: Variable 'innodb_ft_enable_stopword' can't be set to the value of 'AUTO'
102 set global innodb_ft_enable_stopword=-3;
103 ERROR 42000: Variable 'innodb_ft_enable_stopword' can't be set to the value of '-3'
104 set session innodb_ft_enable_stopword=-7;
105 ERROR 42000: Variable 'innodb_ft_enable_stopword' can't be set to the value of '-7'
106 select @@global.innodb_ft_enable_stopword;
107 @@global.innodb_ft_enable_stopword
108 1
109 select @@session.innodb_ft_enable_stopword;
110 @@session.innodb_ft_enable_stopword
111 1
112 select * from performance_schema.global_variables where variable_name='innodb_ft_enable_stopword';
113 VARIABLE_NAME VARIABLE_VALUE
114 innodb_ft_enable_stopword ON
115 select * from performance_schema.session_variables where variable_name='innodb_ft_enable_stopword';
116 VARIABLE_NAME VARIABLE_VALUE
117 innodb_ft_enable_stopword ON
118 SET @@global.innodb_ft_enable_stopword = @start_global_value;
119 SELECT @@global.innodb_ft_enable_stopword;
120 @@global.innodb_ft_enable_stopword
121 1