Tetsuro IKEDA
null+****@clear*****
Thu Oct 4 10:20:20 JST 2012
Tetsuro IKEDA 2010-03-31 10:34:38 +0900 (Wed, 31 Mar 2010) New Revision: 316fb6f5ea1d79c58e5391323ea7eb18a702c625 https://github.com/mroonga/mroonga/commit/316fb6f5ea1d79c58e5391323ea7eb18a702c625 Log: added test case for SELECT without index. Added files: test/sql/r/select_all.result test/sql/t/select_all.test Modified files: test/sql/t/drop_database.test test/sql/t/drop_table.test Added: test/sql/r/select_all.result (+0 -0) 100644 =================================================================== (Binary files differ) Modified: test/sql/t/drop_database.test (+1 -0) =================================================================== --- test/sql/t/drop_database.test 2010-03-30 18:47:17 +0900 (d5fb167) +++ test/sql/t/drop_database.test 2010-03-31 10:34:38 +0900 (f9247a5) @@ -1,5 +1,6 @@ --disable_warnings install plugin mroonga soname 'libmroonga.so'; +set storage_engine=mroonga; drop database if exists mroonga; --enable_warnings Modified: test/sql/t/drop_table.test (+1 -0) =================================================================== --- test/sql/t/drop_table.test 2010-03-30 18:47:17 +0900 (968447a) +++ test/sql/t/drop_table.test 2010-03-31 10:34:38 +0900 (c785419) @@ -1,5 +1,6 @@ --disable_warnings install plugin mroonga soname 'libmroonga.so'; +set storage_engine=mroonga; drop table if exists t1, t2, t3; --enable_warnings Added: test/sql/t/select_all.test (+46 -0) 100644 =================================================================== --- /dev/null +++ test/sql/t/select_all.test 2010-03-31 10:34:38 +0900 (95af0f7) @@ -0,0 +1,46 @@ +--disable_warnings +install plugin mroonga soname 'libmroonga.so'; +set storage_engine=mroonga; +drop table if exists t1, t2, t3; +--enable_warnings + +create table t1(c1 int, c2 int, c3 int); +insert into t1 values (1, 10, 100); +insert into t1 values (2, 30, 500); +insert into t1 values (5, 20, 200); +insert into t1 values (3, 60, 300); +insert into t1 values (4, 50, 600); +insert into t1 values (6, 40, 400); + +select * from t1; +select c1 from t1; +select c2 from t1; +select c3 from t1; + +select * from t1 where c1 <= 3; +select * from t1 where c2 > 40; +select * from t1 where c3 = 300; + + +select * from t1 order by c1; +select * from t1 order by c2 desc; +select * from t1 order by c3, c1; + +drop table t1; + +create table t1 (c1 int, c2 text); +insert into t1 values(1, "hoge"); +insert into t1 values(4, "hoge"); +insert into t1 values(2, "hoge"); +insert into t1 values(5, "hoge"); +insert into t1 values(3, "hoge"); + +select * from t1; +select * from t1 order by c1; +select * from t1 order by c1 desc; + +drop table t1; + +--disable_warnings +uninstall plugin mroonga; +--enable_warnings -------------- next part -------------- HTML����������������������������...Download