Rename test suite that does both ends of IN transformation so can have one that just tests the first.
Add a test that demonstrates the problem.
Don't put WHERE conditions into an inside join unless it's INNER.
merge MMcM: When converting a subquery to a semi-join, be careful about where its WHERE conditions end up

Merge pull request #1236 from MMcM/sql-layer/sql-in-subquery-where-put-where
https://github.com/FoundationDB/sql-layer/pull/1236