1
drop table if exists t1;
2
show variables like "ft\_%";
4
ft_boolean_syntax + -><()~*:""&|
7
ft_query_expansion_limit 20
8
ft_stopword_file (built-in)
9
create table t1 (b text not null);
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);
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);
24
set global ft_boolean_syntax='@ -><()~*:""&|';
25
select * from t1 where match b against ('+aaaaaa bbbbbb' in boolean mode);
30
select * from t1 where match b against ('+aaaaaa @bbbbbb' in boolean mode);
34
set global ft_boolean_syntax='@ -><()~*:""@|';
35
ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '@ -><()~*:""@|'
36
set global ft_boolean_syntax='+ -><()~*:""@!|';
37
ERROR 42000: Variable 'ft_boolean_syntax' can't be set to the value of '+ -><()~*:""@!|'