diff options
| author | unknown <sasha@mysql.sashanet.com> | 2000-12-05 06:12:19 -0700 |
|---|---|---|
| committer | unknown <sasha@mysql.sashanet.com> | 2000-12-05 06:12:19 -0700 |
| commit | cdcc130a3b4c29575e1aa8fd87fc7ba22fa058fa (patch) | |
| tree | 275b86ef0df5939e96bb937021ba5bc17c3ba707 | |
| parent | 357e91d5db6bd67ad4d2a271f1c294afc0b93df5 (diff) | |
| download | mariadb-git-cdcc130a3b4c29575e1aa8fd87fc7ba22fa058fa.tar.gz | |
Added a test case for a coredump bug in SELECT DISTINCT. Have not yet fixed the coredump itself
BitKeeper/etc/ignore:
Added mysql-test/var/lib/test/test1.frm mysql-test/var/lib/test/test1.MYD mysql-test/var/lib/test/test1.MYI mysql-test/var/lib/test/test2.frm mysql-test/var/lib/test/test2.MYD mysql-test/var/lib/test/test2.MYI mysql-test/var/run/mysqld.pid mysql-test/var/tmp/mysql.sock to the ignore list
| -rw-r--r-- | .bzrignore | 8 | ||||
| -rw-r--r-- | mysql-test/r/3.23/sel000100.res | 0 | ||||
| -rw-r--r-- | mysql-test/t/3.23/sel000100.test | 30 |
3 files changed, 38 insertions, 0 deletions
diff --git a/.bzrignore b/.bzrignore index d0f97026511..692355e2022 100644 --- a/.bzrignore +++ b/.bzrignore @@ -392,3 +392,11 @@ Docs/manual.tp Docs/manual.vr Docs/manual_a4.ps Docs/manual_letter.ps +mysql-test/var/lib/test/test1.frm +mysql-test/var/lib/test/test1.MYD +mysql-test/var/lib/test/test1.MYI +mysql-test/var/lib/test/test2.frm +mysql-test/var/lib/test/test2.MYD +mysql-test/var/lib/test/test2.MYI +mysql-test/var/run/mysqld.pid +mysql-test/var/tmp/mysql.sock diff --git a/mysql-test/r/3.23/sel000100.res b/mysql-test/r/3.23/sel000100.res new file mode 100644 index 00000000000..e69de29bb2d --- /dev/null +++ b/mysql-test/r/3.23/sel000100.res diff --git a/mysql-test/t/3.23/sel000100.test b/mysql-test/t/3.23/sel000100.test new file mode 100644 index 00000000000..20d5a3e2e3a --- /dev/null +++ b/mysql-test/t/3.23/sel000100.test @@ -0,0 +1,30 @@ +DROP TABLE IF EXISTS test1; +DROP TABLE IF EXISTS test2; + +CREATE TABLE test1 ( + ID int(11) NOT NULL auto_increment, + NAME varchar(75) DEFAULT '' NOT NULL, + LINK_ID int(11) DEFAULT '0' NOT NULL, + PRIMARY KEY (ID), + KEY NAME (NAME), + KEY LINK_ID (LINK_ID) +); + +INSERT INTO test1 (ID, NAME, LINK_ID) VALUES (1,'Mike',0); +INSERT INTO test1 (ID, NAME, LINK_ID) VALUES (2,'Jack',0); +INSERT INTO test1 (ID, NAME, LINK_ID) VALUES (3,'Bill',0); + +CREATE TABLE test2 ( + ID int(11) NOT NULL auto_increment, + NAME varchar(150) DEFAULT '' NOT NULL, + PRIMARY KEY (ID), + KEY NAME (NAME) +); + +@r/3.23/sel000100.res SELECT DISTINCT + test2.id AS key_link_id, + test2.name AS link +FROM test1 +LEFT JOIN test2 ON test1.link_id=test2.id +GROUP BY test1.id +ORDER BY link; |