1# Copyright(C) 2012-2016 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--source ../../include/mroonga/have_mroonga.inc 18 19--disable_warnings 20DROP TABLE IF EXISTS diaries; 21--enable_warnings 22 23# MySQL <= 5.5 reports a wrong warning. :< 24# It has been fixed in MySQL >= 5.6 and MariaDB >= 5.3. 25--disable_warnings 26SET GLOBAL mroonga_match_escalation_threshold = -1; 27--enable_warnings 28 29CREATE TABLE diaries ( 30 id INT PRIMARY KEY AUTO_INCREMENT, 31 title TEXT, 32 tags TEXT, 33 FULLTEXT INDEX tags_index (tags) COMMENT 'tokenizer "TokenDelimit"' 34) DEFAULT CHARSET=UTF8; 35 36INSERT INTO diaries (title, tags) VALUES ("Hello Groonga!", "groonga install"); 37INSERT INTO diaries (title, tags) VALUES ("Hello Mroonga!", "mroonga install"); 38 39disable_query_log; 40CONNECT (new_connection, localhost, root, ,); 41CONNECTION new_connection; 42enable_query_log; 43 44SELECT * FROM diaries WHERE MATCH (tags) AGAINST ("+install" IN BOOLEAN MODE); 45 46SELECT * FROM diaries WHERE MATCH (tags) AGAINST ("+gr" IN BOOLEAN MODE); 47 48SET GLOBAL mroonga_match_escalation_threshold = 0; 49SELECT * FROM diaries WHERE MATCH (tags) AGAINST ("+gr" IN BOOLEAN MODE); 50 51SET mroonga_match_escalation_threshold = 0; 52SELECT * FROM diaries WHERE MATCH (tags) AGAINST ("+gr" IN BOOLEAN MODE); 53 54disable_query_log; 55CONNECTION default; 56DISCONNECT new_connection; 57enable_query_log; 58 59DROP TABLE diaries; 60 61--source ../../include/mroonga/have_mroonga_deinit.inc 62