am I right in thinking that if the select returns more that 1500
values the statement will fail in some way
I remember that this used to be an issue and I can't find any
reference to it being removed


UPDATE yy SET XX = 2
WHERE id IN(
SELECT zz.id from zza)