Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_ft_num_word_optimize;
2 SELECT @start_global_value;
3 @start_global_value
4 2000
5 Valid values are zero or above
6 select @@global.innodb_ft_num_word_optimize >=1000;
7 @@global.innodb_ft_num_word_optimize >=1000
8 1
9 select @@global.innodb_ft_num_word_optimize;
10 @@global.innodb_ft_num_word_optimize
11 2000
12 select @@session.innodb_ft_num_word_optimize;
13 ERROR HY000: Variable 'innodb_ft_num_word_optimize' is a GLOBAL variable
14 show global variables like 'innodb_ft_num_word_optimize';
15 Variable_name Value
16 innodb_ft_num_word_optimize 2000
17 show session variables like 'innodb_ft_num_word_optimize';
18 Variable_name Value
19 innodb_ft_num_word_optimize 2000
20 select * from performance_schema.global_variables where variable_name='innodb_ft_num_word_optimize';
21 VARIABLE_NAME VARIABLE_VALUE
22 innodb_ft_num_word_optimize 2000
23 select * from performance_schema.session_variables where variable_name='innodb_ft_num_word_optimize';
24 VARIABLE_NAME VARIABLE_VALUE
25 innodb_ft_num_word_optimize 2000
26 set global innodb_ft_num_word_optimize=1000;
27 select @@global.innodb_ft_num_word_optimize;
28 @@global.innodb_ft_num_word_optimize
29 1000
30 select * from performance_schema.global_variables where variable_name='innodb_ft_num_word_optimize';
31 VARIABLE_NAME VARIABLE_VALUE
32 innodb_ft_num_word_optimize 1000
33 select * from performance_schema.session_variables where variable_name='innodb_ft_num_word_optimize';
34 VARIABLE_NAME VARIABLE_VALUE
35 innodb_ft_num_word_optimize 1000
36 set session innodb_ft_num_word_optimize=1000;
37 ERROR HY000: Variable 'innodb_ft_num_word_optimize' is a GLOBAL variable and should be set with SET GLOBAL
38 set global innodb_ft_num_word_optimize=1.1;
39 ERROR 42000: Incorrect argument type to variable 'innodb_ft_num_word_optimize'
40 set global innodb_ft_num_word_optimize=1e1;
41 ERROR 42000: Incorrect argument type to variable 'innodb_ft_num_word_optimize'
42 set global innodb_ft_num_word_optimize="foo";
43 ERROR 42000: Incorrect argument type to variable 'innodb_ft_num_word_optimize'
44 set global innodb_ft_num_word_optimize=-7;
45 Warnings:
46 Warning 1292 Truncated incorrect innodb_ft_num_word_optimize value: '-7'
47 select @@global.innodb_ft_num_word_optimize;
48 @@global.innodb_ft_num_word_optimize
49 1000
50 select * from performance_schema.global_variables where variable_name='innodb_ft_num_word_optimize';
51 VARIABLE_NAME VARIABLE_VALUE
52 innodb_ft_num_word_optimize 1000
53 SET @@global.innodb_ft_num_word_optimize = @start_global_value;
54 SELECT @@global.innodb_ft_num_word_optimize;
55 @@global.innodb_ft_num_word_optimize
56 2000