diff options
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_different_match.test')
-rw-r--r-- | storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_different_match.test | 44 |
1 files changed, 0 insertions, 44 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_different_match.test b/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_different_match.test deleted file mode 100644 index dc97db87487..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_different_match.test +++ /dev/null @@ -1,44 +0,0 @@ -# Copyright(C) 2012 Kouhei Sutou -# -# This library is free software; you can redistribute it and/or -# modify it under the terms of the GNU Lesser General Public -# License as published by the Free Software Foundation; either -# version 2.1 of the License, or (at your option) any later version. -# -# This library is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU -# Lesser General Public License for more details. -# -# You should have received a copy of the GNU Lesser General Public -# License along with this library; if not, write to the Free Software -# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - ---source ../../include/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS diaries; ---enable_warnings - -SET NAMES UTF8; -CREATE TABLE diaries( - title TEXT, - body TEXT, - FULLTEXT KEY (title), - FULLTEXT KEY (body) -) DEFAULT CHARSET=utf8; - -INSERT INTO diaries VALUES("Start groonga", "I read groonga's tutorial."); -INSERT INTO diaries VALUES("Start mroonga", "I read mroonga's tutorial."); -INSERT INTO diaries VALUES("Start groonga and Ruby", "I installed rroonga."); - -SELECT * FROM diaries; - -SELECT *, MATCH(body) AGAINST("groonga" IN BOOLEAN MODE) AS score - FROM diaries - WHERE MATCH(title) AGAINST("groonga" IN BOOLEAN MODE) - ORDER BY MATCH(body) AGAINST("groonga" IN BOOLEAN MODE); - -DROP TABLE diaries; - ---source ../../include/mroonga/have_mroonga_deinit.inc |