Kouhei Sutou
null+****@clear*****
Wed Jan 22 18:34:45 JST 2014
Kouhei Sutou 2014-01-22 18:34:45 +0900 (Wed, 22 Jan 2014) New Revision: fcc1f60d64d85791cc0d9dcd679cb68b13866f1c https://github.com/mroonga/mroonga/commit/fcc1f60d64d85791cc0d9dcd679cb68b13866f1c Message: test: make select result stable by ordering Modified files: mysql-test/mroonga/storage/select/r/secondary_key.result mysql-test/mroonga/storage/select/t/secondary_key.test Modified: mysql-test/mroonga/storage/select/r/secondary_key.result (+8 -8) =================================================================== --- mysql-test/mroonga/storage/select/r/secondary_key.result 2014-01-22 18:15:43 +0900 (e772808) +++ mysql-test/mroonga/storage/select/r/secondary_key.result 2014-01-22 18:34:45 +0900 (1c24089) @@ -38,18 +38,18 @@ insert into t1 values('bc','ghi',"ka ki ku ke ko"); insert into t1 values('cd','efg',"sa si su se so"); insert into t1 values('de','cde',"ta ti tu te to"); insert into t1 values('ef','abc',"aa ii uu ee oo"); -select * from t1 force index(idx1) where c2 < 'e'; +select * from t1 force index(idx1) where c2 < 'e' order by c1 asc; c1 c2 c3 -ef abc aa ii uu ee oo de cde ta ti tu te to -select * from t1 force index(idx1) where c2 > 'e'; +ef abc aa ii uu ee oo +select * from t1 force index(idx1) where c2 > 'e' order by c1 asc; c1 c2 c3 -cd efg sa si su se so -bc ghi ka ki ku ke ko ab ijk aa ii uu ee oo -select * from t1 force index(idx1) where c2 between 'c' and 'h'; -c1 c2 c3 -de cde ta ti tu te to +bc ghi ka ki ku ke ko cd efg sa si su se so +select * from t1 force index(idx1) where c2 between 'c' and 'h' order by c1 asc; +c1 c2 c3 bc ghi ka ki ku ke ko +cd efg sa si su se so +de cde ta ti tu te to drop table t1; Modified: mysql-test/mroonga/storage/select/t/secondary_key.test (+3 -3) =================================================================== --- mysql-test/mroonga/storage/select/t/secondary_key.test 2014-01-22 18:15:43 +0900 (4712e2c) +++ mysql-test/mroonga/storage/select/t/secondary_key.test 2014-01-22 18:34:45 +0900 (aad81c7) @@ -43,9 +43,9 @@ insert into t1 values('bc','ghi',"ka ki ku ke ko"); insert into t1 values('cd','efg',"sa si su se so"); insert into t1 values('de','cde',"ta ti tu te to"); insert into t1 values('ef','abc',"aa ii uu ee oo"); -select * from t1 force index(idx1) where c2 < 'e'; -select * from t1 force index(idx1) where c2 > 'e'; -select * from t1 force index(idx1) where c2 between 'c' and 'h'; +select * from t1 force index(idx1) where c2 < 'e' order by c1 asc; +select * from t1 force index(idx1) where c2 > 'e' order by c1 asc; +select * from t1 force index(idx1) where c2 between 'c' and 'h' order by c1 asc; drop table t1; --source ../../../include/mroonga/have_mroonga_deinit.inc -------------- next part -------------- HTML����������������������������...Descargar
