null+****@clear*****
null+****@clear*****
2010年 11月 18日 (木) 17:16:56 JST
Tetsuro IKEDA 2010-11-18 08:16:56 +0000 (Thu, 18 Nov 2010)
New Revision: 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 08:14:58 +0000 (5212e2d)
+++ test/sql/r/select_all.result 2010-11-18 08:16:56 +0000 (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;