fixed up mysql-test - will not push this yet, as more clean up/testing is to follow

1 files changed, 17 insertions, 0 deletions

diff --git a/mysql-test/t/sel000003.test b/mysql-test/t/sel000003.test
new file mode 100644
index 00000000000..cef82ab2596
--- /dev/null
+++ b/mysql-test/t/sel000003.test
@@ -0,0 +1,17 @@
+# sel000003
+#
+# Versions
+# --------
+#   3.22
+#   3.23
+#
+# Description
+# -----------
+# This test is just a simple select.
+# Testing count() function and GROUP BY clause.
+#
+
+DROP TABLE IF EXISTS t;
+CREATE TABLE t (name CHAR(20) NOT NULL PRIMARY KEY, score SMALLINT NOT NULL, KEY(score));
+INSERT INTO t VALUES ('Sasha', 20), ('Matt', 20), ('Monty', 10), ('David', 10), ('Tim', 10), ('Jeremy', 10);
+@r/sel000003.result SELECT COUNT(*) as n, score FROM t GROUP BY score;