@Test
  public void testRangeDelete() throws SQLException {
    prepareData(4, 1);
    try (Connection connection = EnvFactory.getEnv().getConnection(BaseEnv.TABLE_SQL_DIALECT);
        Statement statement = connection.createStatement()) {
      statement.execute("use test");

      // [1, 400] -> [1, 299]
      statement.execute("DELETE FROM vehicle4 WHERE time >= 300");
      try (ResultSet set = statement.executeQuery("SELECT s0 FROM vehicle4")) {
        int cnt = 0;
        while (set.next()) {
          cnt++;
        }
        assertEquals(299, cnt);
      }

      // [1, 299] -> [151, 299]
      statement.execute("DELETE FROM vehicle4 WHERE time <= 150");
      try (ResultSet set = statement.executeQuery("SELECT s1 FROM vehicle4")) {
        int cnt = 0;
        while (set.next()) {
          cnt++;
        }
        assertEquals(149, cnt);
      }

      // [151, 299] -> [251, 299]
      statement.execute("DELETE FROM vehicle4 WHERE time > 50 and time <= 250");
      try (ResultSet set = statement.executeQuery("SELECT * FROM vehicle4")) {
        int cnt = 0;
        while (set.next()) {
          cnt++;
        }
        assertEquals(49, cnt);
      }
    }
    cleanData(4);
  }
Should delete this case after the deletion value filter feature be implemented
integration-test/src/test/java/org/apache/iotdb/relational/it/db/it/IoTDBDeletionTableIT.java