summaryrefslogtreecommitdiff
path: root/mysql-test/r/merge.result
diff options
context:
space:
mode:
authorunknown <istruewing@stella.local>2007-10-09 14:18:10 +0200
committerunknown <istruewing@stella.local>2007-10-09 14:18:10 +0200
commit0249c0a54002052cf19331b2fb3eedccfd930682 (patch)
tree4d5a1d04a6aadc767478926398505f2748429d98 /mysql-test/r/merge.result
parent89568a9d2ae7db3d18f183a33bf7bdd6e0bbc549 (diff)
parent659c47785d9bbf51cdd46d52f559b2d2c08dde02 (diff)
downloadmariadb-git-0249c0a54002052cf19331b2fb3eedccfd930682.tar.gz
Merge stella.local:/home2/mydev/mysql-5.0-bug15522
into stella.local:/home2/mydev/mysql-5.1-bug15522 mysql-test/r/merge.result: Auto merged mysql-test/t/merge.test: Auto merged
Diffstat (limited to 'mysql-test/r/merge.result')
-rw-r--r--mysql-test/r/merge.result5
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/merge.result b/mysql-test/r/merge.result
index 5aa4288500c..d6e19107ec4 100644
--- a/mysql-test/r/merge.result
+++ b/mysql-test/r/merge.result
@@ -879,4 +879,9 @@ CHECK TABLE tm1;
Table Op Msg_type Msg_text
test.tm1 check status OK
DROP TABLE tm1, t1, t2;
+CREATE TABLE t1(c1 INT);
+CREATE TABLE t2 (c1 INT) ENGINE=MERGE UNION=(t1) INSERT_METHOD=FIRST;
+CREATE TABLE IF NOT EXISTS t1 SELECT * FROM t2;
+ERROR HY000: You can't specify target table 't1' for update in FROM clause
+DROP TABLE t1, t2;
End of 5.0 tests