Kenji Maruyama
null+****@clear*****
Sat Oct 26 02:09:27 JST 2013
Kenji Maruyama 2013-10-26 02:09:27 +0900 (Sat, 26 Oct 2013) New Revision: c6ad8e874236834e279a7cb75afc1187ab303ba7 https://github.com/mroonga/mroonga/commit/c6ad8e874236834e279a7cb75afc1187ab303ba7 Message: test: multi range read disk sweep refs #1959 [groonga-dev,01715] Reported by Kimura. Thanks!!! Added files: mysql-test/mroonga/wrapper/multi_range_read/t/disk_sweep.test Added: mysql-test/mroonga/wrapper/multi_range_read/t/disk_sweep.test (+42 -0) 100644 =================================================================== --- /dev/null +++ mysql-test/mroonga/wrapper/multi_range_read/t/disk_sweep.test 2013-10-26 02:09:27 +0900 (9cb45a8) @@ -0,0 +1,42 @@ +# Copyright(C) 2013 Kenji Maruyama <mmmaru777 �� gmail.com> +# +# This library is free software; you can redistribute it and/or +# modify it under the terms of the GNU Lesser General Public +# License as published by the Free Software Foundation; either +# version 2.1 of the License, or (at your option) any later version. +# +# This library is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +# Lesser General Public License for more details. +# +# You should have received a copy of the GNU Lesser General Public +# License along with this library; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/have_innodb.inc +--source ../../../include/mroonga/have_mroonga.inc + +--disable_warnings +DROP TABLE IF EXISTS many_records; +--enable_warnings + +SET optimizer_switch='mrr_cost_based=off'; + +CREATE TABLE many_records ( + 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 + WHERE value IN (0, 2); + +SELECT * FROM many_records + WHERE value IN (0, 2); + +DROP TABLE many_records; + +--source ../../../include/mroonga/have_mroonga_deinit.inc -------------- next part -------------- HTML����������������������������...Télécharger
