diff options
| author | unknown <mwagner@evoq.home.mwagner.org> | 2000-10-13 02:46:16 -0500 |
|---|---|---|
| committer | unknown <mwagner@evoq.home.mwagner.org> | 2000-10-13 02:46:16 -0500 |
| commit | 1ab26c6051ce20d6e4a15835d09e6c4b1c318b59 (patch) | |
| tree | 101062933657af60c8d3355cc2c13f70f30f0052 /mysql-test/xml | |
| parent | 30a7cbdacf5ffaaef71b217dcd89eecb58a2ee7c (diff) | |
| download | mariadb-git-1ab26c6051ce20d6e4a15835d09e6c4b1c318b59.tar.gz | |
sel000002.xml BitKeeper file /home/mwagner/work/bk/mysql/mysql-test/xml/tests/sel000002.xml
sel000003.xml BitKeeper file /home/mwagner/work/bk/mysql/mysql-test/xml/tests/sel000003.xml
Diffstat (limited to 'mysql-test/xml')
| -rw-r--r-- | mysql-test/xml/tests/sel000002.xml | 20 | ||||
| -rw-r--r-- | mysql-test/xml/tests/sel000003.xml | 21 |
2 files changed, 41 insertions, 0 deletions
diff --git a/mysql-test/xml/tests/sel000002.xml b/mysql-test/xml/tests/sel000002.xml new file mode 100644 index 00000000000..902233cbbf0 --- /dev/null +++ b/mysql-test/xml/tests/sel000002.xml @@ -0,0 +1,20 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000002"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>This test is just a simple select.</description> + + <sql>DROP TABLE IF EXISTS t</sql> + <sql>CREATE TABLE t (n INT)</sql> + <sql>INSERT INTO t VALUES (1), (2), (3)</sql> + + <resultfile name="r/3.23/sel000002.result"> + <sql>SELECT * FROM t</sql> + </resultfile> + +</test> diff --git a/mysql-test/xml/tests/sel000003.xml b/mysql-test/xml/tests/sel000003.xml new file mode 100644 index 00000000000..c9334c972d8 --- /dev/null +++ b/mysql-test/xml/tests/sel000003.xml @@ -0,0 +1,21 @@ +<?xml version="1.0" standalone="no"?> + +<!-- This file is maintained by matt@mysql.com --> + +<test name="sel000003"> + + <version value="3.22"/> + <version value="3.23"/> + + <description>This test is just a simple select.</description> + <description>Testing count() function and GROUP BY clause.</description> + + <sql>DROP TABLE IF EXISTS t</sql> + <sql>CREATE TABLE t (name CHAR(20) NOT NULL PRIMARY KEY, score SMALLINT NOT NULL, KEY(score))</sql> + <sql>INSERT INTO t VALUES ('Sasha', 20), ('Matt', 20), ('Monty', 10), ('David', 10), ('Tim', 10), ('Jeremy', 10)</sql> + + <resultfile name="r/3.23/sel000003.result"> + <sql>SELECT COUNT(*) as n, score FROM t GROUP BY score</sql> + </resultfile> + +</test> |