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 --source include/have_innodb.inc
7
8 SET @start_global_value = @@global.innodb_ft_user_stopword_table;
9 SELECT @start_global_value;
10
11 #
12 # exists as session as well
13 #
14 select @@session.innodb_ft_user_stopword_table;
15
16 show global variables like 'innodb_ft_user_stopword_table';
17 show session variables like 'innodb_ft_user_stopword_table';
18
19 --disable_warnings
20 select * from information_schema.global_variables where variable_name='innodb_ft_user_stopword_table';
21 select * from information_schema.session_variables where variable_name='innodb_ft_user_stopword_table';
22 --enable_warnings
23
24 call mtr.add_suppression("\\[ERROR\\] InnoDB: user stopword table Salmon does not exist.");
25
26 --error ER_WRONG_VALUE_FOR_VAR
27 set session innodb_ft_user_stopword_table='Salmon';
28
29 --error ER_WRONG_VALUE_FOR_VAR
30 set @@session.innodb_ft_user_stopword_table='Salmon';
31
32 #
33 # incorrect types
34 #
35 --error ER_WRONG_TYPE_FOR_VAR
36 set global innodb_ft_user_stopword_table=1.1;
37 --error ER_WRONG_TYPE_FOR_VAR
38 set global innodb_ft_user_stopword_table=1e1;
39 --error ER_WRONG_VALUE_FOR_VAR
40 set global innodb_ft_user_stopword_table='Salmon';
41