1# Copyright(C) 2010 Tetsuro IKEDA
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 t1, t2, t3;
21--enable_warnings
22
23create table t1(c1 int primary key, c2 int, c3 int);
24insert into t1 values (1, 10, 100);
25insert into t1 values (2, 30, 500);
26insert into t1 values (5, 20, 200);
27insert into t1 values (3, 60, 300);
28insert into t1 values (4, 50, 600);
29insert into t1 values (6, 40, 400);
30
31select * from t1 where c1=1;
32select * from t1 where c1=2;
33select * from t1 where c1=3;
34select * from t1 where c1=4;
35select * from t1 where c1=5;
36select * from t1 where c1=6;
37
38drop table t1;
39
40--source ../../include/mroonga/have_mroonga_deinit.inc
41