improved test implementation for subquery,join and update