index join reverse tests