Debian Codegraph @

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

raw
1
2 #
3 # 2014-11-05 - Added
4 #
5
6 --source include/have_ngram.inc
7
8 #
9 # show the global and session values;
10 #
11 call mtr.add_suppression("option 'ngram-token-size': signed value 0");
12 call mtr.add_suppression("option 'ngram-token-size': signed value -1");
13 call mtr.add_suppression("option 'ngram-token-size': signed value 11");
14
15 select @@global.ngram_token_size;
16 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
17 select @@session.ngram_token_size;
18 show global variables like 'ngram_token_size';
19 show session variables like 'ngram_token_size';
20 --disable_warnings
21 select * from performance_schema.global_variables where variable_name='ngram_token_size';
22 select * from performance_schema.session_variables where variable_name='ngram_token_size';
23 --enable_warnings
24
25 # show it's read-only
26 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
27 set global ngram_token_size = 3;
28
29 # Valid values are from 1 to 10
30 # ngram_token_size = 1 if we try to set ngram_token_size <= 0
31 let $restart_parameters = restart: --ngram_token_size=0;
32 -- source include/restart_mysqld.inc
33 --disable_warnings
34 select * from performance_schema.global_variables where variable_name='ngram_token_size';
35 --enable_warnings
36 let $restart_parameters = restart: --ngram_token_size=-1;
37 -- source include/restart_mysqld.inc
38 --disable_warnings
39 select * from performance_schema.global_variables where variable_name='ngram_token_size';
40 --enable_warnings
41 # ngram_token_size = 10 if we try to set ngram_token_size >= 10
42 let $restart_parameters = restart: --ngram_token_size=11;
43 -- source include/restart_mysqld.inc
44 --disable_warnings
45 select * from performance_schema.global_variables where variable_name='ngram_token_size';
46 --enable_warnings
47 # Boundry value 10
48 let $restart_parameters = restart: --ngram_token_size=10;
49 -- source include/restart_mysqld.inc
50 --disable_warnings
51 select * from performance_schema.global_variables where variable_name='ngram_token_size';
52 --enable_warnings
53
54 # restore default values
55 let $restart_parameters = restart:;
56 source include/restart_mysqld.inc;