Debian Codegraph @

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

raw
1
2
3 # 2011-11-15 - Added
4 #
5
6
7 SET @start_global_value = @@global.innodb_ft_user_stopword_table;
8 SELECT @start_global_value;
9
10 #
11 # exists as session as well
12 #
13 select @@session.innodb_ft_user_stopword_table;
14
15 show global variables like 'innodb_ft_user_stopword_table';
16 show session variables like 'innodb_ft_user_stopword_table';
17
18 --disable_warnings
19 select * from performance_schema.global_variables where variable_name='innodb_ft_user_stopword_table';
20 select * from performance_schema.session_variables where variable_name='innodb_ft_user_stopword_table';
21 --enable_warnings
22
23 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* user stopword table Salmon does not exist.");
24
25 --error ER_WRONG_VALUE_FOR_VAR
26 set session innodb_ft_user_stopword_table='Salmon';
27
28 --error ER_WRONG_VALUE_FOR_VAR
29 set @@session.innodb_ft_user_stopword_table='Salmon';
30
31 #
32 # incorrect types
33 #
34 --error ER_WRONG_TYPE_FOR_VAR
35 set global innodb_ft_user_stopword_table=1.1;
36 --error ER_WRONG_TYPE_FOR_VAR
37 set global innodb_ft_user_stopword_table=1e1;
38 --error ER_WRONG_VALUE_FOR_VAR
39 set global innodb_ft_user_stopword_table='Salmon';
40