null+****@clear*****
null+****@clear*****
2011年 9月 25日 (日) 09:45:06 JST
Kouhei Sutou 2011-09-25 00:45:06 +0000 (Sun, 25 Sep 2011)
New Revision: 50ae90e3798ebd2ff5723285f69909015aa5fc23
Log:
[storage][test] split insert values test for fulltext index table.
Added files:
test/sql/groonga_storage/r/fulltext_insert_values.result
test/sql/groonga_storage/t/fulltext_insert_values.test
Modified files:
test/sql/groonga_storage/r/fulltext.result
test/sql/groonga_storage/t/fulltext.test
Modified: test/sql/groonga_storage/r/fulltext.result (+0 -24)
===================================================================
--- test/sql/groonga_storage/r/fulltext.result 2011-09-25 00:40:34 +0000 (f9241b4)
+++ test/sql/groonga_storage/r/fulltext.result 2011-09-25 00:45:06 +0000 (5888f32)
@@ -1,28 +1,4 @@
drop table if exists t1, t2, t3;
-create table t1 (c1 int primary key, c2 text, fulltext index ft (c2));
-show create table t1;
-Table Create Table
-t1 CREATE TABLE `t1` (
- `c1` int(11) NOT NULL,
- `c2` text,
- PRIMARY KEY (`c1`),
- FULLTEXT KEY `ft` (`c2`)
-) ENGINE=groonga DEFAULT CHARSET=latin1
-insert into t1 values (1, "hoge hoge");
-insert into t1 values (2, "fuga fuga");
-insert into t1 values (3, "moge moge");
-select * from t1;
-c1 c2
-1 hoge hoge
-2 fuga fuga
-3 moge moge
-flush tables;
-select * from t1;
-c1 c2
-1 hoge hoge
-2 fuga fuga
-3 moge moge
-drop table t1;
create table t1 (c1 int primary key, c2 int, c3 text, fulltext index ft(c3));
insert into t1 values(1,10,"aa ii uu ee oo");
insert into t1 values(2,20,"ka ki ku ke ko");
Added: test/sql/groonga_storage/r/fulltext_insert_values.result (+25 -0) 100644
===================================================================
--- /dev/null
+++ test/sql/groonga_storage/r/fulltext_insert_values.result 2011-09-25 00:45:06 +0000 (4b6dd0e)
@@ -0,0 +1,25 @@
+drop table if exists t1, t2, t3;
+create table t1 (c1 int primary key, c2 text, fulltext index ft (c2));
+show create table t1;
+Table Create Table
+t1 CREATE TABLE `t1` (
+ `c1` int(11) NOT NULL,
+ `c2` text,
+ PRIMARY KEY (`c1`),
+ FULLTEXT KEY `ft` (`c2`)
+) ENGINE=groonga DEFAULT CHARSET=latin1
+insert into t1 values (1, "hoge hoge");
+insert into t1 values (2, "fuga fuga");
+insert into t1 values (3, "moge moge");
+select * from t1;
+c1 c2
+1 hoge hoge
+2 fuga fuga
+3 moge moge
+flush tables;
+select * from t1;
+c1 c2
+1 hoge hoge
+2 fuga fuga
+3 moge moge
+drop table t1;
Modified: test/sql/groonga_storage/t/fulltext.test (+0 -10)
===================================================================
--- test/sql/groonga_storage/t/fulltext.test 2011-09-25 00:40:34 +0000 (a530d22)
+++ test/sql/groonga_storage/t/fulltext.test 2011-09-25 00:45:06 +0000 (25b382c)
@@ -20,16 +20,6 @@
drop table if exists t1, t2, t3;
--enable_warnings
-create table t1 (c1 int primary key, c2 text, fulltext index ft (c2));
-show create table t1;
-insert into t1 values (1, "hoge hoge");
-insert into t1 values (2, "fuga fuga");
-insert into t1 values (3, "moge moge");
-select * from t1;
-flush tables;
-select * from t1;
-drop table t1;
-
create table t1 (c1 int primary key, c2 int, c3 text, fulltext index ft(c3));
insert into t1 values(1,10,"aa ii uu ee oo");
insert into t1 values(2,20,"ka ki ku ke ko");
Added: test/sql/groonga_storage/t/fulltext_insert_values.test (+33 -0) 100644
===================================================================
--- /dev/null
+++ test/sql/groonga_storage/t/fulltext_insert_values.test 2011-09-25 00:45:06 +0000 (51d7864)
@@ -0,0 +1,33 @@
+# Copyright(C) 2010 Tetsuro IKEDA
+#
+# 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 suite/groonga_include/groonga_init.inc
+
+--disable_warnings
+drop table if exists t1, t2, t3;
+--enable_warnings
+
+create table t1 (c1 int primary key, c2 text, fulltext index ft (c2));
+show create table t1;
+insert into t1 values (1, "hoge hoge");
+insert into t1 values (2, "fuga fuga");
+insert into t1 values (3, "moge moge");
+select * from t1;
+flush tables;
+select * from t1;
+drop table t1;
+
+--source suite/groonga_include/groonga_deinit.inc