sel000003.test XLST generated.

sel000002.test	XLST generated.
sel000001.test	XLST generated.


mysql-test/t/3.23/sel000001.test:
  XLST generated.
mysql-test/t/3.23/sel000002.test:
  XLST generated.
mysql-test/t/3.23/sel000003.test:
  XLST generated.

3 files changed, 50 insertions, 17 deletions

diff --git a/mysql-test/t/3.23/sel000001.test b/mysql-test/t/3.23/sel000001.test
index cdd7312cb37..233e986ad3c 100644
--- a/mysql-test/t/3.23/sel000001.test
+++ b/mysql-test/t/3.23/sel000001.test
@@ -1,5 +1,17 @@
-use test;
-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/3.23/sel000001.result select s,id from t where s = 'mouse';
+# 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/3.23/sel000001.result SELECT s, id FROM t WHERE s = 'mouse';
diff --git a/mysql-test/t/3.23/sel000002.test b/mysql-test/t/3.23/sel000002.test
index 0617ce9b28e..3a0178a05d4 100644
--- a/mysql-test/t/3.23/sel000002.test
+++ b/mysql-test/t/3.23/sel000002.test
@@ -1,5 +1,16 @@
-use test;
-drop table if exists t;
-create table t (n int);
-insert into t values (1),(2),(3);
-@r/3.23/sel000002.result select * from t;
+# sel000002
+#
+# Versions
+# --------
+#   3.22
+#   3.23
+#
+# Description
+# -----------
+# This test is just a simple select.
+#
+
+DROP TABLE IF EXISTS t;
+CREATE TABLE t (n INT);
+INSERT INTO t VALUES (1), (2), (3);
+@r/3.23/sel000002.result SELECT * FROM t;
diff --git a/mysql-test/t/3.23/sel000003.test b/mysql-test/t/3.23/sel000003.test
index 660405b69a5..883be4fb079 100644
--- a/mysql-test/t/3.23/sel000003.test
+++ b/mysql-test/t/3.23/sel000003.test
@@ -1,7 +1,17 @@
-use test;
-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/3.23/sel000003.result select count(*) as n,score from t group by score;
\ No newline at end of file
+# 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/3.23/sel000003.result SELECT COUNT(*) as n, score FROM t GROUP BY score;