Debian Codegraph @

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

raw
1
2
3 # 2011-11-15 - Added
4 #
5
6
7 SET @start_global_value = @@global.innodb_ft_aux_table;
8 SELECT @start_global_value;
9
10 #
11 # exists as global only
12 #
13 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
14 select @@session.innodb_ft_aux_table;
15 show global variables like 'innodb_ft_aux_table';
16 show session variables like 'innodb_ft_aux_table';
17 --disable_warnings
18 select * from performance_schema.global_variables where variable_name='innodb_ft_aux_table';
19 select * from performance_schema.session_variables where variable_name='innodb_ft_aux_table';
20 --enable_warnings
21
22 --error ER_GLOBAL_VARIABLE
23 set session innodb_ft_aux_table='Salmon';
24 --error ER_GLOBAL_VARIABLE
25 set @@session.innodb_ft_aux_table='Salmon';
26
27 #
28 # incorrect types
29 #
30 --error ER_WRONG_TYPE_FOR_VAR
31 set global innodb_ft_aux_table=1.1;
32 --error ER_WRONG_TYPE_FOR_VAR
33 set global innodb_ft_aux_table=1e1;
34 --error ER_WRONG_VALUE_FOR_VAR
35 set global innodb_ft_aux_table='Salmon';
36
37 #
38 # Cleanup
39 #
40
41 SET @@global.innodb_ft_aux_table = @start_global_value;
42 SELECT @@global.innodb_ft_aux_table;
43
44 set @a:=repeat(':/',128);
45 --error ER_WRONG_VALUE_FOR_VAR
46 set global innodb_ft_aux_table =@a;
47 set @a:=repeat(':/',256);
48 --error ER_WRONG_VALUE_FOR_VAR
49 set global innodb_ft_aux_table =@a;