Why would contain fail to create a join?

Can someone at least tell me whether I’m doing something wrong or if this supposed to work and there is a bug somewhere?