1# Copyright(C) 2014 Kouhei Sutou <kou@clear-code.com> 2# 3# This library is free software; you can redistribute it and/or 4# modify it under the terms of the GNU Lesser General Public 5# License as published by the Free Software Foundation; either 6# version 2.1 of the License, or (at your option) any later version. 7# 8# This library is distributed in the hope that it will be useful, 9# but WITHOUT ANY WARRANTY; without even the implied warranty of 10# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU 11# Lesser General Public License for more details. 12# 13# You should have received a copy of the GNU Lesser General Public 14# License along with this library; if not, write to the Free Software 15# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA 16 17# TODO: Remove the check after MariaDB 5.5.42 and MariaDB 10.0.17 are released. 18--source ../../include/mroonga/have_mysql.inc 19 20--source ../../include/mroonga/have_mroonga.inc 21 22SET @mroonga_boolean_mode_syntax_flags_backup = 23 @@mroonga_boolean_mode_syntax_flags; 24 25SET mroonga_boolean_mode_syntax_flags = "SYNTAX_SCRIPT"; 26 27SET NAMES UTF8; 28 29CREATE TABLE diaries ( 30 title TEXT, 31 FULLTEXT KEY (title) 32) DEFAULT CHARSET=utf8; 33 34INSERT INTO diaries VALUES("Re:Mroonga"); 35 36SELECT * FROM diaries 37 WHERE MATCH(title) AGAINST("title @ 'Re:Mroonga'" IN BOOLEAN MODE); 38 39DROP TABLE diaries; 40 41SET mroonga_boolean_mode_syntax_flags = 42 @mroonga_boolean_mode_syntax_flags_backup; 43 44--source ../../include/mroonga/have_mroonga_deinit.inc 45