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 --source include/have_innodb.inc
7
8 SET @start_global_value = @@global.innodb_ft_aux_table;
9 SELECT @start_global_value;
10
11 #
12 # exists as global only
13 #
14 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
15 select @@session.innodb_ft_aux_table;
16 show global variables like 'innodb_ft_aux_table';
17 show session variables like 'innodb_ft_aux_table';
18 --disable_warnings
19 select * from information_schema.global_variables where variable_name='innodb_ft_aux_table';
20 select * from information_schema.session_variables where variable_name='innodb_ft_aux_table';
21 --enable_warnings
22
23 --error ER_GLOBAL_VARIABLE
24 set session innodb_ft_aux_table='Salmon';
25 --error ER_GLOBAL_VARIABLE
26 set @@session.innodb_ft_aux_table='Salmon';
27
28 #
29 # incorrect types
30 #
31 --error ER_WRONG_TYPE_FOR_VAR
32 set global innodb_ft_aux_table=1.1;
33 --error ER_WRONG_TYPE_FOR_VAR
34 set global innodb_ft_aux_table=1e1;
35 --error ER_WRONG_VALUE_FOR_VAR
36 set global innodb_ft_aux_table='Salmon';
37
38 #
39 # Cleanup
40 #
41
42 SET @@global.innodb_ft_aux_table = @start_global_value;
43 SELECT @@global.innodb_ft_aux_table;