Fix join type override in MySQL test