Debian Codegraph @

mysql-test/suite/innodb_fts/r/fulltext_var.result

raw
1 drop table if exists t1;
2 show variables like "ft\_%";
3 Variable_name Value
4 ft_boolean_syntax + -><()~*:""&|
5 ft_max_word_len 84
6 ft_min_word_len 4
7 ft_query_expansion_limit 20
8 ft_stopword_file (built-in)
9 create table t1 (b text not null, fulltext(b)) engine = innodb;
10 insert t1 values ('aaaaaa bbbbbb cccccc');
11 insert t1 values ('bbbbbb cccccc');
12 insert t1 values ('aaaaaa cccccc');
13 select * from t1 where match b against ('+aaaaaa bbbbbb' in boolean mode);
14 b
15 aaaaaa bbbbbb cccccc
16 aaaaaa cccccc
17 set ft_boolean_syntax=' +-><()~*:""&|';
18 ERROR HY000: Variable 'ft_boolean_syntax' is a GLOBAL variable and should be set with SET GLOBAL
19 set global ft_boolean_syntax=' +-><()~*:""&|';
20 select * from t1 where match b against ('+aaaaaa bbbbbb' in boolean mode);
21 b
22 aaaaaa bbbbbb cccccc
23 aaaaaa cccccc
24 set global ft_boolean_syntax='@ -><()~*:""&|';
25 select * from t1 where match b against ('+aaaaaa bbbbbb' in boolean mode);
26 b
27 aaaaaa bbbbbb cccccc
28 aaaaaa cccccc
29 select * from t1 where match b against ('+aaaaaa @bbbbbb' in boolean mode);
30 ERROR 42000: syntax error, unexpected '@', expecting $end
31 set global ft_boolean_syntax='@ -><()~*:""@|';
32 ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '@ -><()~*:""@|'
33 set global ft_boolean_syntax='+ -><()~*:""@!|';
34 ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '+ -><()~*:""@!|'
35 drop table t1;