There definitely were changes in Derby 10.3 with respect to IN clause compilation and execution, in particular DERBY-47: https://issues.apache.org/jira/browse/Derby-47
So it's certainly possible that something changed for the worse. Can you provide a complete standalone script with test data which reproduces the problem? thanks, bryan
