Kouhei Sutou
null+****@clear*****
Tue Dec 24 13:43:30 JST 2013
Kouhei Sutou 2013-12-24 13:43:30 +0900 (Tue, 24 Dec 2013) New Revision: 5823033ba9103144cbf36b657b2e9ddab3196edd https://github.com/mroonga/mroonga/commit/5823033ba9103144cbf36b657b2e9ddab3196edd Message: test: remove needless SQLs Modified files: mysql-test/mroonga/storage/optimization/order_limit/optimized/year/r/between.result mysql-test/mroonga/storage/optimization/order_limit/optimized/year/t/between.test Modified: mysql-test/mroonga/storage/optimization/order_limit/optimized/year/r/between.result (+0 -17) =================================================================== --- mysql-test/mroonga/storage/optimization/order_limit/optimized/year/r/between.result 2013-12-24 13:41:32 +0900 (fd5550d) +++ mysql-test/mroonga/storage/optimization/order_limit/optimized/year/r/between.result 2013-12-24 13:43:30 +0900 (11dc6a1) @@ -6,16 +6,6 @@ release_year YEAR, KEY (release_year), FULLTEXT KEY (release_title) ) DEFAULT CHARSET UTF8; -SHOW CREATE TABLE mroonga_releases; -Table Create Table -mroonga_releases CREATE TABLE `mroonga_releases` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `release_title` text, - `release_year` year(4) DEFAULT NULL, - PRIMARY KEY (`id`), - KEY `release_year` (`release_year`), - FULLTEXT KEY `release_title` (`release_title`) -) ENGINE=mroonga DEFAULT CHARSET=utf8 INSERT INTO mroonga_releases (release_title, release_year) VALUES ("Groonga storage engine 0.1 has been released", "10"); INSERT INTO mroonga_releases (release_title, release_year) @@ -26,13 +16,6 @@ INSERT INTO mroonga_releases (release_title, release_year) VALUES ("Mroonga 3.0 has been released", "13"); INSERT INTO mroonga_releases (release_title, release_year) VALUES ("Mroonga 4.0 will be released", "2014"); -SELECT * FROM mroonga_releases; -id release_title release_year -1 Groonga storage engine 0.1 has been released 2010 -2 Rename Groonga storage engine to Mroonga 2011 -3 Mroonga 2.0 has been released 2012 -4 Mroonga 3.0 has been released 2013 -5 Mroonga 4.0 will be released 2014 SELECT * FROM mroonga_releases WHERE release_year BETWEEN "11" AND "2013" AND MATCH(release_title) AGAINST("Mroonga" IN BOOLEAN MODE) Modified: mysql-test/mroonga/storage/optimization/order_limit/optimized/year/t/between.test (+0 -3) =================================================================== --- mysql-test/mroonga/storage/optimization/order_limit/optimized/year/t/between.test 2013-12-24 13:41:32 +0900 (73aff64) +++ mysql-test/mroonga/storage/optimization/order_limit/optimized/year/t/between.test 2013-12-24 13:43:30 +0900 (bf74eed) @@ -27,7 +27,6 @@ CREATE TABLE mroonga_releases ( KEY (release_year), FULLTEXT KEY (release_title) ) DEFAULT CHARSET UTF8; -SHOW CREATE TABLE mroonga_releases; INSERT INTO mroonga_releases (release_title, release_year) VALUES ("Groonga storage engine 0.1 has been released", "10"); @@ -40,8 +39,6 @@ INSERT INTO mroonga_releases (release_title, release_year) INSERT INTO mroonga_releases (release_title, release_year) VALUES ("Mroonga 4.0 will be released", "2014"); -SELECT * FROM mroonga_releases; - SELECT * FROM mroonga_releases WHERE release_year BETWEEN "11" AND "2013" AND MATCH(release_title) AGAINST("Mroonga" IN BOOLEAN MODE) -------------- next part -------------- HTML����������������������������...Download