/**
* Checks that the search_path is extended and not overwritten so that objects in PUBLIC can still
* be found.
*/
@Test
public void setCurrentSchema() throws Exception {
Connection connection = createDataSource().getConnection();
PostgreSQLDbSupport dbSupport = new PostgreSQLDbSupport(connection);
Schema schema = dbSupport.getSchema("search_path_test");
schema.create();
dbSupport.setCurrentSchema(dbSupport.getSchema("search_path_test"));
String searchPath = dbSupport.getJdbcTemplate().queryForString("SHOW search_path");
assertEquals("search_path_test, \"$user\", public", searchPath);
schema.drop();
JdbcUtils.closeConnection(connection);
}
