@Test
  public void testSetBindVariables() throws Exception {
    GenericSqlParser parser = new GenericSqlParser();

    Map<String, Object> properties = new HashMap<String, Object>();

    properties.put("var1", 1);
    properties.put("var2", 2);

    assertTrue(
        "select * from dual".equals(parser.setBindVariables("select * from dual", properties)));

    assertTrue(
        "select * from dual where x = 1 and y = 2"
            .equals(
                parser.setBindVariables(
                    "select * from dual where x = :var1 and y = :var2", properties)));
  }