Update with subquery in keyless tables

[jycor]

Update queries where there is a cacheable subquery are getting optimized into update joins, which aren't supported for keyless tables.

Repro:

create table t (i int);
insert into t values (1);
update t set i = 10 where i in (select 1);