1# Copyright(C) 2013 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
23FLUSH STATUS;
24
25SET NAMES UTF8;
26CREATE TABLE diaries (
27  id INT UNSIGNED NOT NULL,
28  year INT UNSIGNED,
29  month INT UNSIGNED,
30  day INT UNSIGNED,
31  title VARCHAR(255),
32  content TEXT,
33  FULLTEXT INDEX(content),
34  KEY(month),
35  KEY(day)
36) DEFAULT CHARSET UTF8;
37
38INSERT INTO diaries VALUES(1, 2011, 11, 9, "Hello", "今日からはじめました。");
39INSERT INTO diaries VALUES(2, 2011, 11, 10, "天気", "明日の富士山の天気について");
40INSERT INTO diaries VALUES(3, 2011, 11, 11, "富士山", "今日も天気がよくてきれいに見える。");
41INSERT INTO diaries VALUES(4, 2011, 11, 12, "帰り道", "今日は天気がよくてよかった。");
42INSERT INTO diaries VALUES(5, 2011, 11, 13, "はれ", "天気がよいのは今日までみたい。");
43INSERT INTO diaries VALUES(6, 2011, 12, 1, "久しぶり", "天気が悪いからずっと留守番。");
44INSERT INTO diaries VALUES(7, 2011, 12, 2, "初雪", "今日の天気は雪！");
45
46SELECT * FROM diaries
47         WHERE MATCH(content) AGAINST("今日" IN BOOLEAN MODE) AND
48               day > 10
49         ORDER BY day LIMIT 1,2;
50
51SHOW STATUS LIKE 'mroonga_fast_order_limit';
52
53DROP TABLE diaries;
54
55--source ../../include/mroonga/have_mroonga_deinit.inc
56