Tetsuro IKEDA
null+****@clear*****
Thu Oct 4 10:28:47 JST 2012
Tetsuro IKEDA 2010-11-18 17:16:56 +0900 (Thu, 18 Nov 2010) New Revision: afc77e60cb94136a5a689d4d99ff69a4b4eaf66d https://github.com/mroonga/mroonga/commit/afc77e60cb94136a5a689d4d99ff69a4b4eaf66d Log: added table scan test result for _id. Modified files: test/sql/r/select_all.result Modified: test/sql/r/select_all.result (+23 -0) =================================================================== --- test/sql/r/select_all.result 2010-11-18 17:14:58 +0900 (5212e2d) +++ test/sql/r/select_all.result 2010-11-18 17:16:56 +0900 (1dec8a8) @@ -175,4 +175,27 @@ c1 c2 c3 1 20 hoge 2 50 fuga drop table t1; +create table t1 (_id int, c1 int); +insert into t1 values (null,100); +insert into t1 values (null,100); +insert into t1 values (null,100); +insert into t1 values (null,100); +insert into t1 values (null,100); +select * from t1; +_id c1 +1 100 +2 100 +3 100 +4 100 +5 100 +select * from t1 where _id < 3; +_id c1 +1 100 +2 100 +select * from t1 where _id >= 3; +_id c1 +3 100 +4 100 +5 100 +drop table t1; uninstall plugin groonga; -------------- next part -------------- HTML����������������������������...Download