diff options
| author | halfspawn <j.brauge@qualiac.com> | 2017-09-26 11:52:31 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2017-10-03 20:23:34 +0200 |
| commit | 1a74d12da674d49304ffdc62e100ba8d19f90f13 (patch) | |
| tree | c7cfd2b8f5a65ab3a4d38cb8ae1710eba821da14 /mysql-test/t/subselect.test | |
| parent | 26ff92f7ac2dc373769b8053e936e4593a2ee302 (diff) | |
| download | mariadb-git-1a74d12da674d49304ffdc62e100ba8d19f90f13.tar.gz | |
MDEV-12874 UPDATE statements with the same source and target
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 2 |
1 files changed, 0 insertions, 2 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 7412eae8ecf..5e1e1494fee 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -325,8 +325,6 @@ create table t2 (a int NOT NULL, b int, primary key (a)); insert into t1 values (0, 10),(1, 11),(2, 12); insert into t2 values (1, 21),(2, 22),(3, 23); select * from t1; --- error ER_UPDATE_TABLE_USED -update t1 set b= (select b from t1); -- error ER_SUBQUERY_NO_1_ROW update t1 set b= (select b from t2); update t1 set b= (select b from t2 where t1.a = t2.a); |