Debian Codegraph @

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

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