Invalid conversion triggers ClassCastException

  @Test void bindStringParameter() {
    for (SqlTypeName tpe : SqlTypeName.INT_TYPES) {
      final String sql =
          "with cte as (select cast(100 as " + tpe.getName() + ") as empid)"
              + "select * from cte where empid = ?";

      CalciteAssert.hr()
          .query(sql)
          .consumesPreparedStatement(p -> {
            p.setString(1, "100");
          })
          .returnsUnordered("EMPID=100");
    }
  }