summaryrefslogtreecommitdiff
path: root/mysql-test/r/subselect.result
diff options
context:
space:
mode:
authorhalfspawn <j.brauge@qualiac.com>2017-09-26 11:52:31 +0200
committerSergei Golubchik <serg@mariadb.org>2017-10-03 20:23:34 +0200
commit1a74d12da674d49304ffdc62e100ba8d19f90f13 (patch)
treec7cfd2b8f5a65ab3a4d38cb8ae1710eba821da14 /mysql-test/r/subselect.result
parent26ff92f7ac2dc373769b8053e936e4593a2ee302 (diff)
downloadmariadb-git-1a74d12da674d49304ffdc62e100ba8d19f90f13.tar.gz
MDEV-12874 UPDATE statements with the same source and target
Diffstat (limited to 'mysql-test/r/subselect.result')
-rw-r--r--mysql-test/r/subselect.result2
1 files changed, 0 insertions, 2 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result
index 919693efffb..7ba8b545e6a 100644
--- a/mysql-test/r/subselect.result
+++ b/mysql-test/r/subselect.result
@@ -583,8 +583,6 @@ a b
0 10
1 11
2 12
-update t1 set b= (select b from t1);
-ERROR HY000: Table 't1' is specified twice, both as a target for 'UPDATE' and as a separate source for data
update t1 set b= (select b from t2);
ERROR 21000: Subquery returns more than 1 row
update t1 set b= (select b from t2 where t1.a = t2.a);