diff options
author | kaa@polly.(none) <> | 2007-11-26 20:02:04 +0300 |
---|---|---|
committer | kaa@polly.(none) <> | 2007-11-26 20:02:04 +0300 |
commit | bc10c6db95ead366db728168ce2db062889e0cb9 (patch) | |
tree | 5eed6ef46d3faf99f685e03028e6e0512b474523 /mysql-test/t/merge.test | |
parent | d9e48751d16756a4b1969a267d6b4ec613fb3f88 (diff) | |
parent | 8fdd9087f8d1c96fde8ae022b48f329e272b2ca7 (diff) | |
download | mariadb-git-bc10c6db95ead366db728168ce2db062889e0cb9.tar.gz |
Merge polly.(none):/home/kaa/src/opt/bug28837/my50-bug29131
into polly.(none):/home/kaa/src/opt/bug28837/my51-bug29131
Diffstat (limited to 'mysql-test/t/merge.test')
-rw-r--r-- | mysql-test/t/merge.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/t/merge.test b/mysql-test/t/merge.test index fd479276b3b..8f1fdff1321 100644 --- a/mysql-test/t/merge.test +++ b/mysql-test/t/merge.test @@ -511,4 +511,26 @@ SELECT * FROM tm1; CHECK TABLE tm1; DROP TABLE tm1, t1, t2; +# +# Bug #28837: MyISAM storage engine error (134) doing delete with self-join +# + +CREATE TABLE t1 (id INT NOT NULL, ref INT NOT NULL, INDEX (id)) ENGINE=MyISAM; +CREATE TABLE t2 LIKE t1; + +INSERT INTO t2 (id, ref) VALUES (1,3), (2,1), (3,2), (4,5), (4,4); +INSERT INTO t1 SELECT * FROM t2; +INSERT INTO t1 SELECT * FROM t2; + +CREATE TABLE t3 (id INT NOT NULL, ref INT NOT NULL, INDEX (id)) ENGINE=MERGE + UNION(t1); + +SELECT * FROM t3 AS a INNER JOIN t3 AS b USING (id) WHERE a.ref < b.ref; +SELECT * FROM t3; +DELETE FROM a USING t3 AS a INNER JOIN t3 AS b USING (id) WHERE a.ref < b.ref; +SELECT * FROM t3; + +DROP TABLE t1, t2, t3; + + --echo End of 5.0 tests |