@Test public void testCloneSchema()
throws ClassNotFoundException, SQLException {
final OptiqConnection connection = OptiqAssert.getConnection(false);
final SchemaPlus rootSchema = connection.getRootSchema();
final SchemaPlus foodmart = rootSchema.getSubSchema("foodmart");
rootSchema.add("foodmart2", new CloneSchema(foodmart));
Statement statement = connection.createStatement();
ResultSet resultSet =
statement.executeQuery(
"select count(*) from \"foodmart2\".\"time_by_day\"");
assertTrue(resultSet.next());