Kouhei Sutou
null+****@clear*****
Fri Nov 15 18:13:31 JST 2013
Kouhei Sutou 2013-11-15 18:13:31 +0900 (Fri, 15 Nov 2013) New Revision: e686733da2118477adb72e36b4a1bba53d965875 https://github.com/mroonga/mroonga/commit/e686733da2118477adb72e36b4a1bba53d965875 Message: test: fix misleading name The table doesn't have many records. So it should be renamed. Modified files: mysql-test/mroonga/wrapper/multi_range_read/r/disk_sweep.result mysql-test/mroonga/wrapper/multi_range_read/t/disk_sweep.test Modified: mysql-test/mroonga/wrapper/multi_range_read/r/disk_sweep.result (+7 -7) =================================================================== --- mysql-test/mroonga/wrapper/multi_range_read/r/disk_sweep.result 2013-11-14 13:35:54 +0900 (5fa898c) +++ mysql-test/mroonga/wrapper/multi_range_read/r/disk_sweep.result 2013-11-15 18:13:31 +0900 (aa7a32d) @@ -1,18 +1,18 @@ -DROP TABLE IF EXISTS many_records; +DROP TABLE IF EXISTS integers; SET optimizer_switch='mrr_cost_based=off'; -CREATE TABLE many_records ( +CREATE TABLE integers ( id INT PRIMARY KEY AUTO_INCREMENT, value INT, KEY (value) ) COMMENT='engine "InnoDB"'; -INSERT INTO many_records (value) VALUES (0), (1), (2), (3); -EXPLAIN SELECT * FROM many_records +INSERT INTO integers (value) VALUES (0), (1), (2), (3); +EXPLAIN SELECT * FROM integers WHERE value IN (0, 2); id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE many_records range value value 5 NULL 2 Using where; Using MRR -SELECT * FROM many_records +1 SIMPLE integers range value value 5 NULL 2 Using where; Using MRR +SELECT * FROM integers WHERE value IN (0, 2); id value 1 0 3 2 -DROP TABLE many_records; +DROP TABLE integers; Modified: mysql-test/mroonga/wrapper/multi_range_read/t/disk_sweep.test (+7 -6) =================================================================== --- mysql-test/mroonga/wrapper/multi_range_read/t/disk_sweep.test 2013-11-14 13:35:54 +0900 (14fe30e) +++ mysql-test/mroonga/wrapper/multi_range_read/t/disk_sweep.test 2013-11-15 18:13:31 +0900 (1babbeb) @@ -1,4 +1,5 @@ # Copyright(C) 2013 Kenji Maruyama <mmmaru777 �� gmail.com> +# Copyright(C) 2013 Kouhei Sutou <kou �� clear-code.com> # # This library is free software; you can redistribute it and/or # modify it under the terms of the GNU Lesser General Public @@ -19,25 +20,25 @@ --source ../../../include/mroonga/have_mroonga.inc --disable_warnings -DROP TABLE IF EXISTS many_records; +DROP TABLE IF EXISTS integers; --enable_warnings SET optimizer_switch='mrr_cost_based=off'; -CREATE TABLE many_records ( +CREATE TABLE integers ( id INT PRIMARY KEY AUTO_INCREMENT, value INT, KEY (value) ) COMMENT='engine "InnoDB"'; -INSERT INTO many_records (value) VALUES (0), (1), (2), (3); +INSERT INTO integers (value) VALUES (0), (1), (2), (3); -EXPLAIN SELECT * FROM many_records +EXPLAIN SELECT * FROM integers WHERE value IN (0, 2); -SELECT * FROM many_records +SELECT * FROM integers WHERE value IN (0, 2); -DROP TABLE many_records; +DROP TABLE integers; --source ../../../include/mroonga/have_mroonga_deinit.inc -------------- next part -------------- HTML����������������������������...Download