@Test
  public void testDelMultipleFlushingMemTable() throws SQLException {
    int testNum = 8;
    int deviceId = 0;
    try (Connection connection = EnvFactory.getEnv().getConnection(BaseEnv.TABLE_SQL_DIALECT);
        Statement statement = connection.createStatement()) {
      statement.execute("use test");
      statement.execute(
          String.format(
              "CREATE TABLE vehicle%d(deviceId STRING TAG, s0 INT32 FIELD, s1 INT64 FIELD, s2 FLOAT FIELD, s3 TEXT FIELD, s4 BOOLEAN FIELD)",
              testNum));

      for (int i = 1; i <= 1000; i++) {
        statement.execute(
            String.format(
                insertTemplate, testNum, i, deviceId, i, i, (double) i, "'" + i + "'", i % 2 == 0));
      }

      statement.execute("DELETE FROM vehicle8 WHERE time > 150 and time <= 300");
      statement.execute("DELETE FROM vehicle8 WHERE time > 300 and time <= 400");
      for (int i = 1001; i <= 2000; i++) {
        statement.execute(
            String.format(
                insertTemplate, testNum, i, deviceId, i, i, (double) i, "'" + i + "'", i % 2 == 0));
      }

      statement.execute("DELETE FROM vehicle8 WHERE time > 500 and time <= 800");
      statement.execute("DELETE FROM vehicle8 WHERE time > 900 and time <= 1100");
      statement.execute("DELETE FROM vehicle8 WHERE time > 1500 and time <= 1650");
      statement.execute("flush");
      try (ResultSet set = statement.executeQuery("SELECT s0 FROM vehicle8")) {
        int cnt = 0;
        while (set.next()) {
          cnt++;
        }
        assertEquals(1100, cnt);
      }
      cleanData(testNum);
    }
  }
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