storage/mroonga/mysql-test/mroonga/storage/r/variable_boolean_mode_syntax_flags_syntax_script.result


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

SET @mroonga_boolean_mode_syntax_flags_backup =
@@mroonga_boolean_mode_syntax_flags;
SET mroonga_boolean_mode_syntax_flags = "SYNTAX_SCRIPT";
SET NAMES UTF8;
CREATE TABLE diaries (
title TEXT,
FULLTEXT KEY (title)
) DEFAULT CHARSET=utf8;
INSERT INTO diaries VALUES("Re:Mroonga");
SELECT * FROM diaries
WHERE MATCH(title) AGAINST("title @ 'Re:Mroonga'" IN BOOLEAN MODE);
title
Re:Mroonga
DROP TABLE diaries;
SET mroonga_boolean_mode_syntax_flags =
@mroonga_boolean_mode_syntax_flags_backup;