Debian Codegraph @

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

raw
1 call mtr.add_suppression("option 'ngram-token-size': signed value 0");
2 call mtr.add_suppression("option 'ngram-token-size': signed value -1");
3 call mtr.add_suppression("option 'ngram-token-size': signed value 11");
4 select @@global.ngram_token_size;
5 @@global.ngram_token_size
6 2
7 select @@session.ngram_token_size;
8 ERROR HY000: Variable 'ngram_token_size' is a GLOBAL variable
9 show global variables like 'ngram_token_size';
10 Variable_name Value
11 ngram_token_size 2
12 show session variables like 'ngram_token_size';
13 Variable_name Value
14 ngram_token_size 2
15 select * from performance_schema.global_variables where variable_name='ngram_token_size';
16 VARIABLE_NAME VARIABLE_VALUE
17 ngram_token_size 2
18 select * from performance_schema.session_variables where variable_name='ngram_token_size';
19 VARIABLE_NAME VARIABLE_VALUE
20 ngram_token_size 2
21 set global ngram_token_size = 3;
22 ERROR HY000: Variable 'ngram_token_size' is a read only variable
23 # restart: --ngram_token_size=0
24 select * from performance_schema.global_variables where variable_name='ngram_token_size';
25 VARIABLE_NAME VARIABLE_VALUE
26 ngram_token_size 1
27 # restart: --ngram_token_size=-1
28 select * from performance_schema.global_variables where variable_name='ngram_token_size';
29 VARIABLE_NAME VARIABLE_VALUE
30 ngram_token_size 1
31 # restart: --ngram_token_size=11
32 select * from performance_schema.global_variables where variable_name='ngram_token_size';
33 VARIABLE_NAME VARIABLE_VALUE
34 ngram_token_size 10
35 # restart: --ngram_token_size=10
36 select * from performance_schema.global_variables where variable_name='ngram_token_size';
37 VARIABLE_NAME VARIABLE_VALUE
38 ngram_token_size 10
39 # restart: