[Groonga-mysql-commit] mroonga/mroonga [fix-for-visual-studio] added table scan test for _id.

Back to archive index

Tetsuro IKEDA null+****@clear*****
Thu Oct 4 10:22:59 JST 2012


Tetsuro IKEDA	2010-11-18 17:14:58 +0900 (Thu, 18 Nov 2010)

  New Revision: d80373a0883f81a0a62cd65980a2f565b4a01469
  https://github.com/mroonga/mroonga/commit/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 12:33:08 +0900 (3198610)
+++ test/sql/t/select_all.test    2010-11-18 17:14:58 +0900 (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;
-------------- next part --------------
HTML����������������������������...
Download 



More information about the Groonga-mysql-commit mailing list
Back to archive index