summaryrefslogtreecommitdiff
path: root/storage/mroonga/mysql-test/mroonga
diff options
context:
space:
mode:
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga')
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_different_against.result23
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_different_match.result24
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_no_where.result22
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/fulltext_order_same_match_against.result22
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_asc.result16
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_desc.result15
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_or_equal_asc.result16
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/index_range_greater_than_or_equal_desc.result16
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_asc.result16
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_desc.result16
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_or_equal_asc.result16
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/index_range_less_than_or_equal_desc.result16
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/information_schema_plugins.result4
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_TODO_SPLIT_ME.result106
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_after_insert_multithread.result19
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_after_insert_single_thread.result19
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_disabled.result32
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/optimization_skip_count_index_view.result28
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/r/variable_version.result3
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_different_against.test42
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_different_match.test44
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_no_where.test41
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/fulltext_order_same_match_against.test42
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_asc.test39
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_desc.test39
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_or_equal_asc.test39
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/index_range_greater_than_or_equal_desc.test39
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_asc.test39
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_desc.test39
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_or_equal_asc.test39
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/index_range_less_than_or_equal_desc.test39
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_TODO_SPLIT_ME.test61
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_after_insert_multithread.test45
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_after_insert_single_thread.test40
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_disabled.test51
-rw-r--r--storage/mroonga/mysql-test/mroonga/storage/t/optimization_skip_count_index_view.test56
-rw-r--r--storage/mroonga/mysql-test/mroonga/wrapper/r/function_last_insert_grn_id.result17
-rw-r--r--storage/mroonga/mysql-test/mroonga/wrapper/r/version_55_performance_schema.result38
-rw-r--r--storage/mroonga/mysql-test/mroonga/wrapper/r/version_56_or_later_performance_schema.result73
-rw-r--r--storage/mroonga/mysql-test/mroonga/wrapper/t/function_last_insert_grn_id.test52
-rw-r--r--storage/mroonga/mysql-test/mroonga/wrapper/t/version_55_performance_schema.test41
-rw-r--r--storage/mroonga/mysql-test/mroonga/wrapper/t/version_56_or_later_performance_schema.test42
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