@Test
public void testPartitionedSql() throws Exception {
factory.setColumnNames("foo, bar");
factory.setTableName("baz");
factory.setPartitionClause("WHERE foo BETWEEN 17 AND 42");
DataSource dataSource = new SingleConnectionDataSource("jdbc:hsqldb:mem:test", "sa", "", false);
factory.setDataSource(dataSource);
factory.afterPropertiesSet();
assertEquals("Partitioned SQL", "SELECT foo, bar FROM baz WHERE foo BETWEEN 17 AND 42",
ReflectionTestUtils.getField(factory, "sql"));
}