1SET @start_global_value = @@global.innodb_ft_server_stopword_table;
2SELECT @start_global_value;
3@start_global_value
4NULL
5select @@session.innodb_ft_server_stopword_table;
6ERROR HY000: Variable 'innodb_ft_server_stopword_table' is a GLOBAL variable
7show global variables like 'innodb_ft_server_stopword_table';
8Variable_name	Value
9innodb_ft_server_stopword_table
10show session variables like 'innodb_ft_server_stopword_table';
11Variable_name	Value
12innodb_ft_server_stopword_table
13select * from information_schema.global_variables where variable_name='innodb_ft_server_stopword_table';
14VARIABLE_NAME	VARIABLE_VALUE
15INNODB_FT_SERVER_STOPWORD_TABLE
16select * from information_schema.session_variables where variable_name='innodb_ft_server_stopword_table';
17VARIABLE_NAME	VARIABLE_VALUE
18INNODB_FT_SERVER_STOPWORD_TABLE
19call mtr.add_suppression("\\[ERROR\\] InnoDB: user stopword table Salmon does not exist.");
20set session innodb_ft_server_stopword_table='Salmon';
21ERROR HY000: Variable 'innodb_ft_server_stopword_table' is a GLOBAL variable and should be set with SET GLOBAL
22set @@session.innodb_ft_server_stopword_table='Salmon';
23ERROR HY000: Variable 'innodb_ft_server_stopword_table' is a GLOBAL variable and should be set with SET GLOBAL
24set global innodb_ft_server_stopword_table=1.1;
25ERROR 42000: Incorrect argument type to variable 'innodb_ft_server_stopword_table'
26set global innodb_ft_server_stopword_table=1e1;
27ERROR 42000: Incorrect argument type to variable 'innodb_ft_server_stopword_table'
28set global innodb_ft_server_stopword_table='Salmon';
29ERROR 42000: Variable 'innodb_ft_server_stopword_table' can't be set to the value of 'Salmon'
30SET @@global.innodb_ft_server_stopword_table = @start_global_value;
31SELECT @@global.innodb_ft_server_stopword_table;
32@@global.innodb_ft_server_stopword_table
33NULL
34