1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/sel000001.test b/mysql-test/t/sel000001.test
new file mode 100644
index 00000000000..7f5fb303984
--- /dev/null
+++ b/mysql-test/t/sel000001.test
@@ -0,0 +1,17 @@
+# sel000001
+#
+# Versions
+# --------
+#   3.22
+#   3.23
+#
+# Description
+# -----------
+# This test is just a simple select.
+# Testing WHERE clause.
+#
+
+DROP TABLE IF EXISTS t;
+CREATE TABLE t (s CHAR(20) PRIMARY KEY, id INT);
+INSERT INTO t VALUES ('cat', 1), ('mouse', 3), ('dog', 2), ('snake', 77);
+@r/sel000001.result SELECT s, id FROM t WHERE s = 'mouse';