@Test
public void testBlockSQLCommentsRemoval() {

  String sql_with_block_comments =
      "CREATE/* ! COMMENTS ! */UNIQUE /* ANOTHER COMMENTS ! */INDEX unique_index\n"
          + "ON `my_db`.`my_table` (`col1`, `col2`)";
  String sql_with_comments_in_multi_lines =
      "CREATE UNIQUE /*\n"
          + "COMMENT Line1  \n"
          + "COMMENT Line 2\n"
          + "*/\n"
          + "INDEX ON `my_db`.`my_table` (`col1`, `col2`)";
  String expected_sql =
      "CREATE UNIQUE INDEX unique_index\nON `my_db`.`my_table` (`col1`, `col2`)";
  String stripped_sql = MysqlSchemaUtil.removeCommentsFromDDL(sql_with_block_comments);
  assertEquals(expected_sql, stripped_sql);
  stripped_sql = MysqlSchemaUtil.removeCommentsFromDDL(sql_with_comments_in_multi_lines);
  expected_sql = "CREATE UNIQUE \nINDEX ON `my_db`.`my_table` (`col1`, `col2`)";
  assertEquals(expected_sql, stripped_sql);
}