Kouhei Sutou
null+****@clear*****
Sat Nov 17 13:18:08 JST 2012
Kouhei Sutou 2012-11-17 13:18:08 +0900 (Sat, 17 Nov 2012) New Revision: e228ce3cb0a3132419f93c2e8c73c5ddbd6fb6d2 https://github.com/mroonga/mroonga/commit/e228ce3cb0a3132419f93c2e8c73c5ddbd6fb6d2 Log: test: force use index Modified files: test/sql/suite/mroonga/storage/index/primary/char/r/short.result test/sql/suite/mroonga/storage/index/primary/char/t/short.test Modified: test/sql/suite/mroonga/storage/index/primary/char/r/short.result (+2 -2) =================================================================== --- test/sql/suite/mroonga/storage/index/primary/char/r/short.result 2012-11-17 13:17:57 +0900 (0f33168) +++ test/sql/suite/mroonga/storage/index/primary/char/r/short.result 2012-11-17 13:18:08 +0900 (386edf0) @@ -5,12 +5,12 @@ id CHAR(6) CHARACTER SET LATIN1 PRIMARY KEY INSERT INTO ids VALUES("abcdef"); INSERT INTO ids VALUES( "cdef"); INSERT INTO ids VALUES( "ef"); -SELECT * FROM ids ORDER BY id; +SELECT * FROM ids FORCE INDEX(PRIMARY) ORDER BY id; id abcdef cdef ef -SELECT * FROM ids WHERE id = "cdef"; +SELECT * FROM ids FORCE INDEX(PRIMARY) WHERE id = "cdef"; id cdef DROP TABLE ids; Modified: test/sql/suite/mroonga/storage/index/primary/char/t/short.test (+2 -2) =================================================================== --- test/sql/suite/mroonga/storage/index/primary/char/t/short.test 2012-11-17 13:17:57 +0900 (f39d6d0) +++ test/sql/suite/mroonga/storage/index/primary/char/t/short.test 2012-11-17 13:18:08 +0900 (b7bb40d) @@ -28,9 +28,9 @@ INSERT INTO ids VALUES("abcdef"); INSERT INTO ids VALUES( "cdef"); INSERT INTO ids VALUES( "ef"); -SELECT * FROM ids ORDER BY id; +SELECT * FROM ids FORCE INDEX(PRIMARY) ORDER BY id; -SELECT * FROM ids WHERE id = "cdef"; +SELECT * FROM ids FORCE INDEX(PRIMARY) WHERE id = "cdef"; DROP TABLE ids; -------------- next part -------------- HTML����������������������������...Télécharger
