Tetsuro IKEDA
null+****@clear*****
Thu Oct 4 10:20:49 JST 2012
Tetsuro IKEDA 2010-07-02 13:46:54 +0900 (Fri, 02 Jul 2010) New Revision: 871b2a98881ac004696cd031b4ad29fb40d29d78 https://github.com/mroonga/mroonga/commit/871b2a98881ac004696cd031b4ad29fb40d29d78 Log: added primary key EQ search. Added files: test/sql/r/select_pkey.result test/sql/t/select_pkey.test Added: test/sql/r/select_pkey.result (+30 -0) 100644 =================================================================== --- /dev/null +++ test/sql/r/select_pkey.result 2010-07-02 13:46:54 +0900 (5db9704) @@ -0,0 +1,30 @@ +install plugin mroonga soname 'libmroonga.so'; +set storage_engine=mroonga; +drop table if exists t1, t2, t3; +create table t1(c1 int primary key, 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 where c1=1; +c1 c2 c3 +1 10 100 +select * from t1 where c1=2; +c1 c2 c3 +2 30 500 +select * from t1 where c1=3; +c1 c2 c3 +3 60 300 +select * from t1 where c1=4; +c1 c2 c3 +4 50 600 +select * from t1 where c1=5; +c1 c2 c3 +5 20 200 +select * from t1 where c1=6; +c1 c2 c3 +6 40 400 +drop table t1; +uninstall plugin mroonga; Added: test/sql/t/select_pkey.test (+26 -0) 100644 =================================================================== --- /dev/null +++ test/sql/t/select_pkey.test 2010-07-02 13:46:54 +0900 (35c41c2) @@ -0,0 +1,26 @@ +--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 primary key, 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 where c1=1; +select * from t1 where c1=2; +select * from t1 where c1=3; +select * from t1 where c1=4; +select * from t1 where c1=5; +select * from t1 where c1=6; + +drop table t1; + +--disable_warnings +uninstall plugin mroonga; +--enable_warnings -------------- next part -------------- HTML����������������������������...下載
