diff options
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga')
42 files changed, 0 insertions, 1426 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_different_against.result b/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_different_against.result deleted file mode 100644 index d1f0d6bc0ab..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_different_against.result +++ /dev/null @@ -1,23 +0,0 @@ -DROP TABLE IF EXISTS diaries; -SET NAMES UTF8; -CREATE TABLE diaries( -title TEXT, -FULLTEXT KEY (title) -) DEFAULT CHARSET=utf8; -INSERT INTO diaries VALUES("Start groonga"); -INSERT INTO diaries VALUES("Start mroonga"); -INSERT INTO diaries VALUES("Start groonga and Ruby"); -SELECT * FROM diaries; -title -Start groonga -Start mroonga -Start groonga and Ruby -SELECT *, MATCH(title) AGAINST("groonga" IN BOOLEAN MODE) AS score -FROM diaries -WHERE MATCH(title) AGAINST("groonga mroonga" IN BOOLEAN MODE) -ORDER BY MATCH(title) AGAINST("groonga" IN BOOLEAN MODE); -title score -Start mroonga 0 -Start groonga 1 -Start groonga and Ruby 1 -DROP TABLE diaries; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_different_match.result b/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_different_match.result deleted file mode 100644 index b4a07cd0b66..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_different_match.result +++ /dev/null @@ -1,24 +0,0 @@ -DROP TABLE IF EXISTS diaries; -SET NAMES UTF8; -CREATE TABLE diaries( -title TEXT, -body TEXT, -FULLTEXT KEY (title), -FULLTEXT KEY (body) -) DEFAULT CHARSET=utf8; -INSERT INTO diaries VALUES("Start groonga", "I read groonga's tutorial."); -INSERT INTO diaries VALUES("Start mroonga", "I read mroonga's tutorial."); -INSERT INTO diaries VALUES("Start groonga and Ruby", "I installed rroonga."); -SELECT * FROM diaries; -title body -Start groonga I read groonga's tutorial. -Start mroonga I read mroonga's tutorial. -Start groonga and Ruby I installed rroonga. -SELECT *, MATCH(body) AGAINST("groonga" IN BOOLEAN MODE) AS score -FROM diaries -WHERE MATCH(title) AGAINST("groonga" IN BOOLEAN MODE) -ORDER BY MATCH(body) AGAINST("groonga" IN BOOLEAN MODE); -title body score -Start groonga and Ruby I installed rroonga. 0 -Start groonga I read groonga's tutorial. 1 -DROP TABLE diaries; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_no_where.result b/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_no_where.result deleted file mode 100644 index 125b35fb96e..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_no_where.result +++ /dev/null @@ -1,22 +0,0 @@ -DROP TABLE IF EXISTS diaries; -SET NAMES UTF8; -CREATE TABLE diaries( -title TEXT, -FULLTEXT KEY (title) -) DEFAULT CHARSET=utf8; -INSERT INTO diaries VALUES("Start groonga"); -INSERT INTO diaries VALUES("Start mroonga"); -INSERT INTO diaries VALUES("Start groonga and Ruby"); -SELECT * FROM diaries; -title -Start groonga -Start mroonga -Start groonga and Ruby -SELECT *, MATCH(title) AGAINST("groonga" IN BOOLEAN MODE) AS score -FROM diaries -ORDER BY MATCH(title) AGAINST("groonga" IN BOOLEAN MODE); -title score -Start mroonga 0 -Start groonga 1 -Start groonga and Ruby 1 -DROP TABLE diaries; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_same_match_against.result b/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_same_match_against.result deleted file mode 100644 index a3a668c4445..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_same_match_against.result +++ /dev/null @@ -1,22 +0,0 @@ -DROP TABLE IF EXISTS diaries; -SET NAMES UTF8; -CREATE TABLE diaries( -title TEXT, -FULLTEXT KEY (title) -) DEFAULT CHARSET=utf8; -INSERT INTO diaries VALUES("Start groonga"); -INSERT INTO diaries VALUES("Start mroonga"); -INSERT INTO diaries VALUES("Start groonga and Ruby"); -SELECT * FROM diaries; -title -Start groonga -Start mroonga -Start groonga and Ruby -SELECT *, MATCH(title) AGAINST("groonga" IN BOOLEAN MODE) AS score -FROM diaries -WHERE MATCH(title) AGAINST("groonga" IN BOOLEAN MODE) -ORDER BY MATCH(title) AGAINST("groonga" IN BOOLEAN MODE); -title score -Start groonga 1 -Start groonga and Ruby 1 -DROP TABLE diaries; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_asc.result b/storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_asc.result deleted file mode 100644 index 1ca4b145f54..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_asc.result +++ /dev/null @@ -1,16 +0,0 @@ -DROP TABLE IF EXISTS ids; -SET NAMES UTF8; -CREATE TABLE ids ( -id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -SELECT * FROM ids WHERE ids.id > 1 ORDER BY ids.id ASC LIMIT 3; -id -2 -3 -4 -DROP TABLE ids; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_desc.result b/storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_desc.result deleted file mode 100644 index 80dcb25ffe6..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_desc.result +++ /dev/null @@ -1,15 +0,0 @@ -DROP TABLE IF EXISTS ids; -SET NAMES UTF8; -CREATE TABLE ids ( -id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -SELECT * FROM ids WHERE ids.id > 3 ORDER BY ids.id DESC LIMIT 3; -id -5 -4 -DROP TABLE ids; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_or_equal_asc.result b/storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_or_equal_asc.result deleted file mode 100644 index 4c1ff997d79..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_or_equal_asc.result +++ /dev/null @@ -1,16 +0,0 @@ -DROP TABLE IF EXISTS ids; -SET NAMES UTF8; -CREATE TABLE ids ( -id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -SELECT * FROM ids WHERE ids.id >= 2 ORDER BY ids.id ASC LIMIT 3; -id -2 -3 -4 -DROP TABLE ids; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_or_equal_desc.result b/storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_or_equal_desc.result deleted file mode 100644 index 4998725aef5..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_or_equal_desc.result +++ /dev/null @@ -1,16 +0,0 @@ -DROP TABLE IF EXISTS ids; -SET NAMES UTF8; -CREATE TABLE ids ( -id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -SELECT * FROM ids WHERE ids.id >= 3 ORDER BY ids.id DESC LIMIT 3; -id -5 -4 -3 -DROP TABLE ids; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_asc.result b/storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_asc.result deleted file mode 100644 index 8b142f30610..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_asc.result +++ /dev/null @@ -1,16 +0,0 @@ -DROP TABLE IF EXISTS ids; -SET NAMES UTF8; -CREATE TABLE ids ( -id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -SELECT * FROM ids WHERE ids.id < 4 ORDER BY ids.id ASC LIMIT 3; -id -1 -2 -3 -DROP TABLE ids; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_desc.result b/storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_desc.result deleted file mode 100644 index eaf5b87e62c..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_desc.result +++ /dev/null @@ -1,16 +0,0 @@ -DROP TABLE IF EXISTS ids; -SET NAMES UTF8; -CREATE TABLE ids ( -id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -SELECT * FROM ids WHERE ids.id < 4 ORDER BY ids.id DESC LIMIT 3; -id -3 -2 -1 -DROP TABLE ids; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_or_equal_asc.result b/storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_or_equal_asc.result deleted file mode 100644 index e1e96c9ca8b..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_or_equal_asc.result +++ /dev/null @@ -1,16 +0,0 @@ -DROP TABLE IF EXISTS ids; -SET NAMES UTF8; -CREATE TABLE ids ( -id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -SELECT * FROM ids WHERE ids.id <= 4 ORDER BY ids.id ASC LIMIT 3; -id -1 -2 -3 -DROP TABLE ids; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_or_equal_desc.result b/storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_or_equal_desc.result deleted file mode 100644 index e8124ca14c0..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_or_equal_desc.result +++ /dev/null @@ -1,16 +0,0 @@ -DROP TABLE IF EXISTS ids; -SET NAMES UTF8; -CREATE TABLE ids ( -id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -SELECT * FROM ids WHERE ids.id <= 4 ORDER BY ids.id DESC LIMIT 3; -id -4 -3 -2 -DROP TABLE ids; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/information_schema_plugins.result b/storage/mroonga/mysql-test/mroonga/storage/r/information_schema_plugins.result deleted file mode 100644 index 63ecb8c669a..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/information_schema_plugins.result +++ /dev/null @@ -1,4 +0,0 @@ -select PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_TYPE -from information_schema.plugins where plugin_name = "Mroonga"; -PLUGIN_NAME PLUGIN_VERSION PLUGIN_TYPE -Mroonga 5.0 STORAGE ENGINE diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_TODO_SPLIT_ME.result b/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_TODO_SPLIT_ME.result deleted file mode 100644 index b66801094bd..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_TODO_SPLIT_ME.result +++ /dev/null @@ -1,106 +0,0 @@ -drop table if exists t1, t2, t3; -flush status; -create table t1 (c1 int primary key, c2 int, c3 text, key idx1(c2), fulltext index ft(c3)); -insert into t1 values(1,10,"aa ii uu ee oo"); -insert into t1 values(2,20,"ka ki ku ke ko"); -insert into t1 values(3,30,"sa si su se so"); -insert into t1 values(4,40,"ta ti tu te to"); -insert into t1 values(5,50,"aa ii uu ee oo"); -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 0 -select * from t1; -c1 c2 c3 -1 10 aa ii uu ee oo -2 20 ka ki ku ke ko -3 30 sa si su se so -4 40 ta ti tu te to -5 50 aa ii uu ee oo -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 0 -select count(*) from t1; -count(*) -5 -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 0 -select * from t1 force index(primary) where c1 between 2 and 4; -c1 c2 c3 -2 20 ka ki ku ke ko -3 30 sa si su se so -4 40 ta ti tu te to -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 0 -select count(*) from t1 force index(primary) where c1 between 2 and 4; -count(*) -3 -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 1 -select c1 from t1 force index(primary) where c1 < 3; -c1 -1 -2 -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 1 -select count(c1) from t1 force index(primary) where c1 < 3; -count(c1) -2 -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 1 -select 1 from t1 force index(primary) where c1 > 3; -1 -1 -1 -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 1 -select count(1) from t1 force index(primary) where c1 > 3; -count(1) -2 -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 2 -select * from t1 where match(c3) against("su"); -c1 c2 c3 -3 30 sa si su se so -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 2 -select count(*) from t1 where match(c3) against("su"); -count(*) -1 -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 3 -select * from t1 where match(c3) against("+su" in boolean mode); -c1 c2 c3 -3 30 sa si su se so -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 3 -select count(*) from t1 where match(c3) against("+su" in boolean mode); -count(*) -1 -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 4 -select * from t1 force index(idx1) where c2 between 20 and 40; -c1 c2 c3 -2 20 ka ki ku ke ko -3 30 sa si su se so -4 40 ta ti tu te to -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 4 -select count(*) from t1 force index(idx1) where c2 between 20 and 40; -count(*) -3 -show status like 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 5 -drop table t1; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_after_insert_multithread.result b/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_after_insert_multithread.result deleted file mode 100644 index c09ec340ccb..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_after_insert_multithread.result +++ /dev/null @@ -1,19 +0,0 @@ -DROP TABLE IF EXISTS diaries; -FLUSH STATUS; -CREATE TABLE diaries ( -title TEXT, -FULLTEXT INDEX ft(title) -); -INSERT INTO diaries VALUES("Hello mroonga!"); -INSERT INTO diaries VALUES("It's funny."); -INSERT INTO diaries VALUES("Happy birthday!"); -SHOW STATUS LIKE 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 0 -SELECT COUNT(*) FROM diaries WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE); -COUNT(*) -1 -SHOW STATUS LIKE 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 1 -DROP TABLE diaries; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_after_insert_single_thread.result b/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_after_insert_single_thread.result deleted file mode 100644 index c09ec340ccb..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_after_insert_single_thread.result +++ /dev/null @@ -1,19 +0,0 @@ -DROP TABLE IF EXISTS diaries; -FLUSH STATUS; -CREATE TABLE diaries ( -title TEXT, -FULLTEXT INDEX ft(title) -); -INSERT INTO diaries VALUES("Hello mroonga!"); -INSERT INTO diaries VALUES("It's funny."); -INSERT INTO diaries VALUES("Happy birthday!"); -SHOW STATUS LIKE 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 0 -SELECT COUNT(*) FROM diaries WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE); -COUNT(*) -1 -SHOW STATUS LIKE 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 1 -DROP TABLE diaries; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_disabled.result b/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_disabled.result deleted file mode 100644 index 9971d21e386..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_disabled.result +++ /dev/null @@ -1,32 +0,0 @@ -DROP TABLE IF EXISTS diaries; -FLUSH STATUS; -SET NAMES UTF8; -CREATE TABLE diaries ( -id INT UNSIGNED NOT NULL, -title VARCHAR(255), -content TEXT, -FULLTEXT INDEX(content) -) DEFAULT CHARSET UTF8; -SHOW CREATE TABLE diaries; -Table Create Table -diaries CREATE TABLE `diaries` ( - `id` int(10) unsigned NOT NULL, - `title` varchar(255) DEFAULT NULL, - `content` text, - FULLTEXT KEY `content` (`content`) -) ENGINE=Mroonga DEFAULT CHARSET=utf8 -INSERT INTO diaries VALUES(1, "Hello", "今日からはじめました。"); -INSERT INTO diaries VALUES(2, "天気", "明日の富士山の天気について"); -INSERT INTO diaries VALUES(3, "富士山", "今日も天気がよくてきれいに見える。"); -INSERT INTO diaries VALUES(4, "帰り道", "今日は天気がよくてよかった。"); -INSERT INTO diaries VALUES(5, "はれ", "天気がよいのは今日までみたい。"); -SET mroonga_enable_optimization=FALSE; -SELECT COUNT(*) FROM diaries -WHERE MATCH(content) AGAINST("今日" IN BOOLEAN MODE); -COUNT(*) -4 -SHOW STATUS LIKE 'mroonga_count_skip'; -Variable_name Value -Mroonga_count_skip 0 -SET mroonga_enable_optimization=TRUE; -DROP TABLE diaries; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_index_view.result b/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_index_view.result deleted file mode 100644 index 407347a4fa2..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_index_view.result +++ /dev/null @@ -1,28 +0,0 @@ -DROP TABLE IF EXISTS diaries, users; -CREATE TABLE diaries ( -id INT PRIMARY KEY AUTO_INCREMENT, -user_id INT NOT NULL, -title VARCHAR(45) NOT NULL, -KEY (user_id), -FULLTEXT INDEX title_index (title) -) DEFAULT CHARSET=UTF8; -CREATE TABLE users ( -id INT PRIMARY KEY AUTO_INCREMENT, -name VARCHAR(45) NOT NULL, -INDEX (name) -) ENGINE=InnoDB DEFAULT CHARSET=UTF8; -INSERT INTO users (id, name) VALUES (1, "Alice"), (2, "Bob"); -INSERT INTO diaries (user_id, title) VALUES (1, "survey"); -INSERT INTO diaries (user_id, title) VALUES (2, "groonga (1)"); -INSERT INTO diaries (user_id, title) VALUES (2, "groonga (2)"); -CREATE VIEW articles AS -SELECT diaries.user_id AS user_id, -diaries.title AS title, -users.name AS name -FROM diaries, users -WHERE diaries.user_id = users.id; -SELECT COUNT(*) FROM articles WHERE name = 'Bob'; -COUNT(*) -2 -DROP VIEW articles; -DROP TABLE diaries, users; diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/variable_version.result b/storage/mroonga/mysql-test/mroonga/storage/r/variable_version.result deleted file mode 100644 index 9b99165c047..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/r/variable_version.result +++ /dev/null @@ -1,3 +0,0 @@ -show variables like 'mroonga_version'; -Variable_name Value -mroonga_version 5.00 diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_different_against.test b/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_different_against.test deleted file mode 100644 index f2859f99dba..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_different_against.test +++ /dev/null @@ -1,42 +0,0 @@ -# Copyright(C) 2012 Kouhei Sutou -# -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS diaries; ---enable_warnings - -SET NAMES UTF8; -CREATE TABLE diaries( - title TEXT, - FULLTEXT KEY (title) -) DEFAULT CHARSET=utf8; - -INSERT INTO diaries VALUES("Start groonga"); -INSERT INTO diaries VALUES("Start mroonga"); -INSERT INTO diaries VALUES("Start groonga and Ruby"); - -SELECT * FROM diaries; - -SELECT *, MATCH(title) AGAINST("groonga" IN BOOLEAN MODE) AS score - FROM diaries - WHERE MATCH(title) AGAINST("groonga mroonga" IN BOOLEAN MODE) - ORDER BY MATCH(title) AGAINST("groonga" IN BOOLEAN MODE); - -DROP TABLE diaries; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_different_match.test b/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_different_match.test deleted file mode 100644 index dc97db87487..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_different_match.test +++ /dev/null @@ -1,44 +0,0 @@ -# Copyright(C) 2012 Kouhei Sutou -# -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS diaries; ---enable_warnings - -SET NAMES UTF8; -CREATE TABLE diaries( - title TEXT, - body TEXT, - FULLTEXT KEY (title), - FULLTEXT KEY (body) -) DEFAULT CHARSET=utf8; - -INSERT INTO diaries VALUES("Start groonga", "I read groonga's tutorial."); -INSERT INTO diaries VALUES("Start mroonga", "I read mroonga's tutorial."); -INSERT INTO diaries VALUES("Start groonga and Ruby", "I installed rroonga."); - -SELECT * FROM diaries; - -SELECT *, MATCH(body) AGAINST("groonga" IN BOOLEAN MODE) AS score - FROM diaries - WHERE MATCH(title) AGAINST("groonga" IN BOOLEAN MODE) - ORDER BY MATCH(body) AGAINST("groonga" IN BOOLEAN MODE); - -DROP TABLE diaries; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_no_where.test b/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_no_where.test deleted file mode 100644 index 50dd652e2d0..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_no_where.test +++ /dev/null @@ -1,41 +0,0 @@ -# Copyright(C) 2012 Kouhei Sutou -# -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS diaries; ---enable_warnings - -SET NAMES UTF8; -CREATE TABLE diaries( - title TEXT, - FULLTEXT KEY (title) -) DEFAULT CHARSET=utf8; - -INSERT INTO diaries VALUES("Start groonga"); -INSERT INTO diaries VALUES("Start mroonga"); -INSERT INTO diaries VALUES("Start groonga and Ruby"); - -SELECT * FROM diaries; - -SELECT *, MATCH(title) AGAINST("groonga" IN BOOLEAN MODE) AS score - FROM diaries - ORDER BY MATCH(title) AGAINST("groonga" IN BOOLEAN MODE); - -DROP TABLE diaries; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_same_match_against.test b/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_same_match_against.test deleted file mode 100644 index 0873849a1e7..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_same_match_against.test +++ /dev/null @@ -1,42 +0,0 @@ -# Copyright(C) 2012 Kouhei Sutou -# -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS diaries; ---enable_warnings - -SET NAMES UTF8; -CREATE TABLE diaries( - title TEXT, - FULLTEXT KEY (title) -) DEFAULT CHARSET=utf8; - -INSERT INTO diaries VALUES("Start groonga"); -INSERT INTO diaries VALUES("Start mroonga"); -INSERT INTO diaries VALUES("Start groonga and Ruby"); - -SELECT * FROM diaries; - -SELECT *, MATCH(title) AGAINST("groonga" IN BOOLEAN MODE) AS score - FROM diaries - WHERE MATCH(title) AGAINST("groonga" IN BOOLEAN MODE) - ORDER BY MATCH(title) AGAINST("groonga" IN BOOLEAN MODE); - -DROP TABLE diaries; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_asc.test b/storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_asc.test deleted file mode 100644 index a622dfbf70d..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_asc.test +++ /dev/null @@ -1,39 +0,0 @@ -# Copyright(C) 2012 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 -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS ids; ---enable_warnings - -SET NAMES UTF8; - -CREATE TABLE ids ( - id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; - -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); - -SELECT * FROM ids WHERE ids.id > 1 ORDER BY ids.id ASC LIMIT 3; - -DROP TABLE ids; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_desc.test b/storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_desc.test deleted file mode 100644 index 63dc820ccfd..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_desc.test +++ /dev/null @@ -1,39 +0,0 @@ -# Copyright(C) 2012 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 -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS ids; ---enable_warnings - -SET NAMES UTF8; - -CREATE TABLE ids ( - id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; - -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); - -SELECT * FROM ids WHERE ids.id > 3 ORDER BY ids.id DESC LIMIT 3; - -DROP TABLE ids; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_or_equal_asc.test b/storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_or_equal_asc.test deleted file mode 100644 index a51e6c5da47..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_or_equal_asc.test +++ /dev/null @@ -1,39 +0,0 @@ -# Copyright(C) 2012 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 -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS ids; ---enable_warnings - -SET NAMES UTF8; - -CREATE TABLE ids ( - id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; - -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); - -SELECT * FROM ids WHERE ids.id >= 2 ORDER BY ids.id ASC LIMIT 3; - -DROP TABLE ids; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_or_equal_desc.test b/storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_or_equal_desc.test deleted file mode 100644 index ea5c150bf0f..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_or_equal_desc.test +++ /dev/null @@ -1,39 +0,0 @@ -# Copyright(C) 2012 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 -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS ids; ---enable_warnings - -SET NAMES UTF8; - -CREATE TABLE ids ( - id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; - -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); - -SELECT * FROM ids WHERE ids.id >= 3 ORDER BY ids.id DESC LIMIT 3; - -DROP TABLE ids; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_asc.test b/storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_asc.test deleted file mode 100644 index 12761c0f4d8..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_asc.test +++ /dev/null @@ -1,39 +0,0 @@ -# Copyright(C) 2012 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 -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS ids; ---enable_warnings - -SET NAMES UTF8; - -CREATE TABLE ids ( - id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; - -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); - -SELECT * FROM ids WHERE ids.id < 4 ORDER BY ids.id ASC LIMIT 3; - -DROP TABLE ids; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_desc.test b/storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_desc.test deleted file mode 100644 index a4f4a781ead..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_desc.test +++ /dev/null @@ -1,39 +0,0 @@ -# Copyright(C) 2012 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 -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS ids; ---enable_warnings - -SET NAMES UTF8; - -CREATE TABLE ids ( - id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; - -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); - -SELECT * FROM ids WHERE ids.id < 4 ORDER BY ids.id DESC LIMIT 3; - -DROP TABLE ids; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_or_equal_asc.test b/storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_or_equal_asc.test deleted file mode 100644 index 2fba0d13f5f..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_or_equal_asc.test +++ /dev/null @@ -1,39 +0,0 @@ -# Copyright(C) 2012 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 -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS ids; ---enable_warnings - -SET NAMES UTF8; - -CREATE TABLE ids ( - id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; - -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); - -SELECT * FROM ids WHERE ids.id <= 4 ORDER BY ids.id ASC LIMIT 3; - -DROP TABLE ids; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_or_equal_desc.test b/storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_or_equal_desc.test deleted file mode 100644 index e4661fc7047..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_or_equal_desc.test +++ /dev/null @@ -1,39 +0,0 @@ -# Copyright(C) 2012 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 -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS ids; ---enable_warnings - -SET NAMES UTF8; - -CREATE TABLE ids ( - id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT -) ENGINE=Mroonga DEFAULT CHARSET=utf8; - -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); -INSERT INTO ids VALUES(); - -SELECT * FROM ids WHERE ids.id <= 4 ORDER BY ids.id DESC LIMIT 3; - -DROP TABLE ids; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_TODO_SPLIT_ME.test b/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_TODO_SPLIT_ME.test deleted file mode 100644 index 669868c6c7f..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_TODO_SPLIT_ME.test +++ /dev/null @@ -1,61 +0,0 @@ -# Copyright(C) 2010 Kentoku SHIBA -# -# 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/mroonga/have_mroonga.inc - ---disable_warnings -drop table if exists t1, t2, t3; ---enable_warnings - -flush status; -create table t1 (c1 int primary key, c2 int, c3 text, key idx1(c2), fulltext index ft(c3)); -insert into t1 values(1,10,"aa ii uu ee oo"); -insert into t1 values(2,20,"ka ki ku ke ko"); -insert into t1 values(3,30,"sa si su se so"); -insert into t1 values(4,40,"ta ti tu te to"); -insert into t1 values(5,50,"aa ii uu ee oo"); -show status like 'mroonga_count_skip'; -select * from t1; -show status like 'mroonga_count_skip'; -select count(*) from t1; -show status like 'mroonga_count_skip'; -select * from t1 force index(primary) where c1 between 2 and 4; -show status like 'mroonga_count_skip'; -select count(*) from t1 force index(primary) where c1 between 2 and 4; -show status like 'mroonga_count_skip'; -select c1 from t1 force index(primary) where c1 < 3; -show status like 'mroonga_count_skip'; -select count(c1) from t1 force index(primary) where c1 < 3; -show status like 'mroonga_count_skip'; -select 1 from t1 force index(primary) where c1 > 3; -show status like 'mroonga_count_skip'; -select count(1) from t1 force index(primary) where c1 > 3; -show status like 'mroonga_count_skip'; -select * from t1 where match(c3) against("su"); -show status like 'mroonga_count_skip'; -select count(*) from t1 where match(c3) against("su"); -show status like 'mroonga_count_skip'; -select * from t1 where match(c3) against("+su" in boolean mode); -show status like 'mroonga_count_skip'; -select count(*) from t1 where match(c3) against("+su" in boolean mode); -show status like 'mroonga_count_skip'; -select * from t1 force index(idx1) where c2 between 20 and 40; -show status like 'mroonga_count_skip'; -select count(*) from t1 force index(idx1) where c2 between 20 and 40; -show status like 'mroonga_count_skip'; -drop table t1; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_after_insert_multithread.test b/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_after_insert_multithread.test deleted file mode 100644 index bca2311ffbc..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_after_insert_multithread.test +++ /dev/null @@ -1,45 +0,0 @@ -# Copyright(C) 2012 Kentoku SHIBA -# Copyright(C) 2012 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 -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS diaries; ---enable_warnings - -FLUSH STATUS; -CREATE TABLE diaries ( - title TEXT, - FULLTEXT INDEX ft(title) -); - -INSERT INTO diaries VALUES("Hello mroonga!"); -INSERT INTO diaries VALUES("It's funny."); - -CONNECT (thread2, localhost, root, ,); -CONNECTION thread2; -INSERT INTO diaries VALUES("Happy birthday!"); -DISCONNECT thread2; -CONNECTION default; - -SHOW STATUS LIKE 'mroonga_count_skip'; -SELECT COUNT(*) FROM diaries WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE); -SHOW STATUS LIKE 'mroonga_count_skip'; - -DROP TABLE diaries; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_after_insert_single_thread.test b/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_after_insert_single_thread.test deleted file mode 100644 index fa960be850f..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_after_insert_single_thread.test +++ /dev/null @@ -1,40 +0,0 @@ -# Copyright(C) 2012 Kentoku SHIBA -# Copyright(C) 2012 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 -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS diaries; ---enable_warnings - -FLUSH STATUS; -CREATE TABLE diaries ( - title TEXT, - FULLTEXT INDEX ft(title) -); - -INSERT INTO diaries VALUES("Hello mroonga!"); -INSERT INTO diaries VALUES("It's funny."); -INSERT INTO diaries VALUES("Happy birthday!"); - -SHOW STATUS LIKE 'mroonga_count_skip'; -SELECT COUNT(*) FROM diaries WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE); -SHOW STATUS LIKE 'mroonga_count_skip'; - -DROP TABLE diaries; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_disabled.test b/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_disabled.test deleted file mode 100644 index e94702e8159..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_disabled.test +++ /dev/null @@ -1,51 +0,0 @@ -# Copyright(C) 2012 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 -# 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/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS diaries; ---enable_warnings - -FLUSH STATUS; - -SET NAMES UTF8; -CREATE TABLE diaries ( - id INT UNSIGNED NOT NULL, - title VARCHAR(255), - content TEXT, - FULLTEXT INDEX(content) -) DEFAULT CHARSET UTF8; -SHOW CREATE TABLE diaries; - -INSERT INTO diaries VALUES(1, "Hello", "今日からはじめました。"); -INSERT INTO diaries VALUES(2, "天気", "明日の富士山の天気について"); -INSERT INTO diaries VALUES(3, "富士山", "今日も天気がよくてきれいに見える。"); -INSERT INTO diaries VALUES(4, "帰り道", "今日は天気がよくてよかった。"); -INSERT INTO diaries VALUES(5, "はれ", "天気がよいのは今日までみたい。"); - -SET mroonga_enable_optimization=FALSE; - -SELECT COUNT(*) FROM diaries - WHERE MATCH(content) AGAINST("今日" IN BOOLEAN MODE); - -SHOW STATUS LIKE 'mroonga_count_skip'; - -SET mroonga_enable_optimization=TRUE; - -DROP TABLE diaries; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_index_view.test b/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_index_view.test deleted file mode 100644 index 11457b1e05a..00000000000 --- a/storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_index_view.test +++ /dev/null @@ -1,56 +0,0 @@ -# Copyright(C) 2012 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 -# 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 diaries, users; ---enable_warnings - -CREATE TABLE diaries ( - id INT PRIMARY KEY AUTO_INCREMENT, - user_id INT NOT NULL, - title VARCHAR(45) NOT NULL, - KEY (user_id), - FULLTEXT INDEX title_index (title) -) DEFAULT CHARSET=UTF8; - -CREATE TABLE users ( - id INT PRIMARY KEY AUTO_INCREMENT, - name VARCHAR(45) NOT NULL, - INDEX (name) -) ENGINE=InnoDB DEFAULT CHARSET=UTF8; - -INSERT INTO users (id, name) VALUES (1, "Alice"), (2, "Bob"); -INSERT INTO diaries (user_id, title) VALUES (1, "survey"); -INSERT INTO diaries (user_id, title) VALUES (2, "groonga (1)"); -INSERT INTO diaries (user_id, title) VALUES (2, "groonga (2)"); - -CREATE VIEW articles AS - SELECT diaries.user_id AS user_id, - diaries.title AS title, - users.name AS name - FROM diaries, users - WHERE diaries.user_id = users.id; - - -SELECT COUNT(*) FROM articles WHERE name = 'Bob'; - -DROP VIEW articles; -DROP TABLE diaries, users; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/r/function_last_insert_grn_id.result b/storage/mroonga/mysql-test/mroonga/wrapper/r/function_last_insert_grn_id.result deleted file mode 100644 index 9edbd3c9b3b..00000000000 --- a/storage/mroonga/mysql-test/mroonga/wrapper/r/function_last_insert_grn_id.result +++ /dev/null @@ -1,17 +0,0 @@ -DROP TABLE IF EXISTS ids; -DROP FUNCTION IF EXISTS last_insert_grn_id; -CREATE TABLE ids ( -id int AUTO_INCREMENT PRIMARY KEY -) COMMENT='ENGINE "InnoDB"'; -SELECT last_insert_grn_id(); -last_insert_grn_id() -0 -INSERT INTO ids VALUES(); -SELECT last_insert_grn_id(); -last_insert_grn_id() -0 -SELECT * FROM ids; -id -1 -DROP TABLE ids; -DROP FUNCTION last_insert_grn_id; diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/r/version_55_performance_schema.result b/storage/mroonga/mysql-test/mroonga/wrapper/r/version_55_performance_schema.result deleted file mode 100644 index f6e3bbdca82..00000000000 --- a/storage/mroonga/mysql-test/mroonga/wrapper/r/version_55_performance_schema.result +++ /dev/null @@ -1,38 +0,0 @@ -DROP TABLE IF EXISTS diaries; -SHOW VARIABLES LIKE 'performance_schema'; -Variable_name Value -performance_schema ON -CREATE TABLE diaries ( -id INT PRIMARY KEY AUTO_INCREMENT, -content VARCHAR(255), -FULLTEXT INDEX (content) -) DEFAULT CHARSET UTF8 COMMENT = 'ENGINE "InnoDB"'; -SHOW CREATE TABLE diaries; -Table Create Table -diaries CREATE TABLE `diaries` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `content` varchar(255) DEFAULT NULL, - PRIMARY KEY (`id`), - FULLTEXT KEY `content` (`content`) -) ENGINE=Mroonga DEFAULT CHARSET=utf8 COMMENT='ENGINE "InnoDB"' -INSERT INTO diaries (content) VALUES ("Tommorow will be shiny day!"); -SHOW TABLES FROM performance_schema; -Tables_in_performance_schema -cond_instances -events_waits_current -events_waits_history -events_waits_history_long -events_waits_summary_by_instance -events_waits_summary_by_thread_by_event_name -events_waits_summary_global_by_event_name -file_instances -file_summary_by_event_name -file_summary_by_instance -mutex_instances -performance_timers -rwlock_instances -setup_consumers -setup_instruments -setup_timers -threads -DROP TABLE diaries; diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/r/version_56_or_later_performance_schema.result b/storage/mroonga/mysql-test/mroonga/wrapper/r/version_56_or_later_performance_schema.result deleted file mode 100644 index 548dc32707f..00000000000 --- a/storage/mroonga/mysql-test/mroonga/wrapper/r/version_56_or_later_performance_schema.result +++ /dev/null @@ -1,73 +0,0 @@ -DROP TABLE IF EXISTS diaries; -SHOW VARIABLES LIKE 'performance_schema'; -Variable_name Value -performance_schema ON -CREATE TABLE diaries ( -id INT PRIMARY KEY AUTO_INCREMENT, -content VARCHAR(255), -FULLTEXT INDEX (content) -) DEFAULT CHARSET UTF8 COMMENT = 'ENGINE "InnoDB"'; -SHOW CREATE TABLE diaries; -Table Create Table -diaries CREATE TABLE `diaries` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `content` varchar(255) DEFAULT NULL, - PRIMARY KEY (`id`), - FULLTEXT KEY `content` (`content`) -) ENGINE=Mroonga DEFAULT CHARSET=utf8 COMMENT='ENGINE "InnoDB"' -INSERT INTO diaries (content) VALUES ("Tommorow will be shiny day!"); -SHOW TABLES FROM performance_schema; -Tables_in_performance_schema -accounts -cond_instances -events_stages_current -events_stages_history -events_stages_history_long -events_stages_summary_by_account_by_event_name -events_stages_summary_by_host_by_event_name -events_stages_summary_by_thread_by_event_name -events_stages_summary_by_user_by_event_name -events_stages_summary_global_by_event_name -events_statements_current -events_statements_history -events_statements_history_long -events_statements_summary_by_account_by_event_name -events_statements_summary_by_digest -events_statements_summary_by_host_by_event_name -events_statements_summary_by_thread_by_event_name -events_statements_summary_by_user_by_event_name -events_statements_summary_global_by_event_name -events_waits_current -events_waits_history -events_waits_history_long -events_waits_summary_by_account_by_event_name -events_waits_summary_by_host_by_event_name -events_waits_summary_by_instance -events_waits_summary_by_thread_by_event_name -events_waits_summary_by_user_by_event_name -events_waits_summary_global_by_event_name -file_instances -file_summary_by_event_name -file_summary_by_instance -host_cache -hosts -mutex_instances -objects_summary_global_by_type -performance_timers -rwlock_instances -session_account_connect_attrs -session_connect_attrs -setup_actors -setup_consumers -setup_instruments -setup_objects -setup_timers -socket_instances -socket_summary_by_event_name -socket_summary_by_instance -table_io_waits_summary_by_index_usage -table_io_waits_summary_by_table -table_lock_waits_summary_by_table -threads -users -DROP TABLE diaries; diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/t/function_last_insert_grn_id.test b/storage/mroonga/mysql-test/mroonga/wrapper/t/function_last_insert_grn_id.test deleted file mode 100644 index c4961756a26..00000000000 --- a/storage/mroonga/mysql-test/mroonga/wrapper/t/function_last_insert_grn_id.test +++ /dev/null @@ -1,52 +0,0 @@ -# Copyright(C) 2012 Kouhei Sutou <kou@clear-code.com> -# Copyright(C) 2013 Kentoku SHIBA -# -# 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/not_embedded.inc ---source ../../include/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS ids; -DROP FUNCTION IF EXISTS last_insert_grn_id; ---enable_warnings - ---disable_query_log -if ($VERSION_COMPILE_OS_WIN) -{ - CREATE FUNCTION last_insert_grn_id RETURNS integer SONAME 'ha_mroonga.dll'; -} -if (!$VERSION_COMPILE_OS_WIN) -{ - CREATE FUNCTION last_insert_grn_id RETURNS integer SONAME 'ha_mroonga.so'; -} ---enable_query_log - -CREATE TABLE ids ( - id int AUTO_INCREMENT PRIMARY KEY -) COMMENT='ENGINE "InnoDB"'; - -SELECT last_insert_grn_id(); - -INSERT INTO ids VALUES(); -SELECT last_insert_grn_id(); -SELECT * FROM ids; - -DROP TABLE ids; - -DROP FUNCTION last_insert_grn_id; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/t/version_55_performance_schema.test b/storage/mroonga/mysql-test/mroonga/wrapper/t/version_55_performance_schema.test deleted file mode 100644 index 809b6fa29b1..00000000000 --- a/storage/mroonga/mysql-test/mroonga/wrapper/t/version_55_performance_schema.test +++ /dev/null @@ -1,41 +0,0 @@ -# Copyright(C) 2012 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 -# 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/mroonga/have_version_55.inc ---source include/have_innodb.inc ---source include/not_embedded.inc ---source ../../include/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS diaries; ---enable_warnings - -SHOW VARIABLES LIKE 'performance_schema'; - -CREATE TABLE diaries ( - id INT PRIMARY KEY AUTO_INCREMENT, - content VARCHAR(255), - FULLTEXT INDEX (content) -) DEFAULT CHARSET UTF8 COMMENT = 'ENGINE "InnoDB"'; -SHOW CREATE TABLE diaries; - -INSERT INTO diaries (content) VALUES ("Tommorow will be shiny day!"); - -SHOW TABLES FROM performance_schema; - -DROP TABLE diaries; - ---source ../../include/mroonga/have_mroonga_deinit.inc diff --git a/storage/mroonga/mysql-test/mroonga/wrapper/t/version_56_or_later_performance_schema.test b/storage/mroonga/mysql-test/mroonga/wrapper/t/version_56_or_later_performance_schema.test deleted file mode 100644 index 20cb2107ec2..00000000000 --- a/storage/mroonga/mysql-test/mroonga/wrapper/t/version_56_or_later_performance_schema.test +++ /dev/null @@ -1,42 +0,0 @@ -# Copyright(C) 2012 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 -# 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/mroonga/have_version_56_or_later.inc ---source include/have_innodb.inc ---source include/not_embedded.inc ---source include/have_perfschema.inc ---source ../../include/mroonga/have_mroonga.inc - ---disable_warnings -DROP TABLE IF EXISTS diaries; ---enable_warnings - -SHOW VARIABLES LIKE 'performance_schema'; - -CREATE TABLE diaries ( - id INT PRIMARY KEY AUTO_INCREMENT, - content VARCHAR(255), - FULLTEXT INDEX (content) -) DEFAULT CHARSET UTF8 COMMENT = 'ENGINE "InnoDB"'; -SHOW CREATE TABLE diaries; - -INSERT INTO diaries (content) VALUES ("Tommorow will be shiny day!"); - -SHOW TABLES FROM performance_schema; - -DROP TABLE diaries; - ---source ../../include/mroonga/have_mroonga_deinit.inc |