null+****@clear*****
null+****@clear*****
2010年 11月 18日 (木) 17:14:58 JST
Tetsuro IKEDA 2010-11-18 08:14:58 +0000 (Thu, 18 Nov 2010)
New Revision: d80373a0883f81a0a62cd65980a2f565b4a01469
Log:
added table scan test for _id.
Modified files:
test/sql/t/select_all.test
Modified: test/sql/t/select_all.test (+11 -0)
===================================================================
--- test/sql/t/select_all.test 2010-11-18 03:33:08 +0000 (3198610)
+++ test/sql/t/select_all.test 2010-11-18 08:14:58 +0000 (f06713e)
@@ -85,6 +85,17 @@ select * from t1 order by c3 asc;
select * from t1 order by c3 desc;
drop table t1;
+# _id
+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;
+select * from t1 where _id < 3;
+select * from t1 where _id >= 3;
+drop table t1;
--disable_warnings
uninstall plugin groonga;