2
# Fulltext configurable parameters
4
-- source include/engine_not_pbxt.inc # PBXT: Fulltext engine required
7
drop table if exists t1;
10
# Save ft_boolean_syntax variable
11
let $saved_ft_boolean_syntax=`select @@global.ft_boolean_syntax`;
13
show variables like "ft\_%";
15
create table t1 (b text not null);
16
insert t1 values ('aaaaaa bbbbbb cccccc');
17
insert t1 values ('bbbbbb cccccc');
18
insert t1 values ('aaaaaa cccccc');
19
select * from t1 where match b against ('+aaaaaa bbbbbb' in boolean mode);
21
set ft_boolean_syntax=' +-><()~*:""&|';
22
set global ft_boolean_syntax=' +-><()~*:""&|';
23
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);
26
select * from t1 where match b against ('+aaaaaa @bbbbbb' in boolean mode);
28
set global ft_boolean_syntax='@ -><()~*:""@|';
30
set global ft_boolean_syntax='+ -><()~*:""@!|';
33
# Restore ft_boolean_syntax variable
35
eval set global ft_boolean_syntax='$saved_ft_boolean_syntax';