s.find("from Foo foo join foo.foo where foo.foo in ('1','2','3')");
if ( !(getDialect() instanceof HSQLDialect) ) s.find("from Foo foo left join foo.foo where foo.foo in ('1','2','3')");
s.find("select foo.foo from Foo foo where foo.foo in ('1','2','3')");
s.find("select foo.foo.string from Foo foo where foo.foo in ('1','2','3')");
s.find("select foo.foo.string from Foo foo where foo.foo.string in ('1','2','3')");
s.find("select foo.foo.long from Foo foo where foo.foo.string in ('1','2','3')");
s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') or foo.foo.long in (1,2,3)");
s.find("select count(*) from Foo foo where foo.foo.string in ('1','2','3') group by foo.foo.long");
s.find("from Foo foo1 left join foo1.foo foo2 left join foo2.foo where foo1.string is not null");
s.find("from Foo foo1 left join foo1.foo.foo where foo1.string is not null");