Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_ft_aux_table_basic.result

raw
1 SET @start_global_value = @@global.innodb_ft_aux_table;
2 SELECT @start_global_value;
3 @start_global_value
4 NULL
5 select @@session.innodb_ft_aux_table;
6 ERROR HY000: Variable 'innodb_ft_aux_table' is a GLOBAL variable
7 show global variables like 'innodb_ft_aux_table';
8 Variable_name Value
9 innodb_ft_aux_table
10 show session variables like 'innodb_ft_aux_table';
11 Variable_name Value
12 innodb_ft_aux_table
13 select * from performance_schema.global_variables where variable_name='innodb_ft_aux_table';
14 VARIABLE_NAME VARIABLE_VALUE
15 innodb_ft_aux_table
16 select * from performance_schema.session_variables where variable_name='innodb_ft_aux_table';
17 VARIABLE_NAME VARIABLE_VALUE
18 innodb_ft_aux_table
19 set session innodb_ft_aux_table='Salmon';
20 ERROR HY000: Variable 'innodb_ft_aux_table' is a GLOBAL variable and should be set with SET GLOBAL
21 set @@session.innodb_ft_aux_table='Salmon';
22 ERROR HY000: Variable 'innodb_ft_aux_table' is a GLOBAL variable and should be set with SET GLOBAL
23 set global innodb_ft_aux_table=1.1;
24 ERROR 42000: Incorrect argument type to variable 'innodb_ft_aux_table'
25 set global innodb_ft_aux_table=1e1;
26 ERROR 42000: Incorrect argument type to variable 'innodb_ft_aux_table'
27 set global innodb_ft_aux_table='Salmon';
28 ERROR 42000: Variable 'innodb_ft_aux_table' can't be set to the value of 'Salmon'
29 SET @@global.innodb_ft_aux_table = @start_global_value;
30 SELECT @@global.innodb_ft_aux_table;
31 @@global.innodb_ft_aux_table
32 NULL
33 set @a:=repeat(':/',128);
34 set global innodb_ft_aux_table =@a;
35 ERROR 42000: Variable 'innodb_ft_aux_table' can't be set to the value of ':/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/'
36 set @a:=repeat(':/',256);
37 set global innodb_ft_aux_table =@a;
38 ERROR 42000: Variable 'innodb_ft_aux_table' can't be set to the value of ':/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/:/'