1 files changed, 15 insertions, 0 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/select_group_by_with_index.result b/storage/mroonga/mysql-test/mroonga/storage/r/select_group_by_with_index.result
new file mode 100644
index 00000000000..400156cec7b
--- /dev/null
+++ b/storage/mroonga/mysql-test/mroonga/storage/r/select_group_by_with_index.result
@@ -0,0 +1,15 @@
+DROP TABLE IF EXISTS users;
+SET NAMES utf8;
+CREATE TABLE users (
+name varchar(40),
+age int,
+KEY (age)
+);
+INSERT INTO users VALUES ("Alice",  20);
+INSERT INTO users VALUES ("Bob",    20);
+INSERT INTO users VALUES ("Charry", 29);
+SELECT *, COUNT(*) FROM users GROUP BY age;
+name	age	COUNT(*)
+Alice	20	2
+Charry	29	1
+DROP TABLE users;