update subquery table should be forbidden

[lysu]

1. What did you do?

prepare two table and a record.

create table a (k int, v int);
create table b (k int, v int);
insert into a values (1, 1);

update b using

update a, (select b.k k, b.v v from b) v set v.v = 3, a.v = 3 where a.k = v.k;

2. What did you expect to see?

ERROR 1288 (HY000): The target table b of the UPDATE is not updatable

3. What did you see instead?

Query OK, 1 row affected (0.11 sec)

4. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?

2.0.5

[longfeiss]

update a, (select b.k k, b.v v from b) v set v.v = 3, a.v = 3 where a.k = v.k1;

update a, (select b.k k, b.v v from b) v set v.v = 3, a.v = 3 where a.k = v.k;