[#2055] MySQL's UPDATE [t1] JOIN [t2] syntax can cause syntax errors as
column references are not fully qualified - Fixed unit tests