cmp2.x jdbc2 pm: missing a join in a collection path translating "member of"

There is one missing join in the where clause translating "member of" which should tie the main table and the table in subselect. I am committing a test that shows the problem.