@Test
  public void testSingleDeviceDeletionMultiExecution() throws SQLException {
    int testNum = 13;
    prepareData(testNum, 5);
    try (Connection connection = EnvFactory.getEnv().getConnection(BaseEnv.TABLE_SQL_DIALECT);
        Statement statement = connection.createStatement()) {
      statement.execute("use test");

      // init d0[1, 400] d1[1, 400] d2[1, 400] d3[1, 400] d4[1, 400]

      // remain d1[10, 400] d2[10, 400] d3[10, 400] d4[10, 400]
      statement.execute("DELETE FROM vehicle" + testNum + "  WHERE time < 10 or deviceId = 'd0'");
      int[] expectedPointNumOfDevice = new int[] {0, 391, 391, 391, 391};
      checkDevicePoint(expectedPointNumOfDevice, statement, testNum);

      // remain d1[50, 400] d2[10, 400] d3[10, 400] d4[10, 400]
      statement.execute("DELETE FROM vehicle" + testNum + "  WHERE time < 50 and deviceId = 'd1'");
      expectedPointNumOfDevice = new int[] {0, 351, 391, 391, 391};
      checkDevicePoint(expectedPointNumOfDevice, statement, testNum);

      // remain d1[50, 400] d2[101, 400] d3[10, 400] d4[10, 400]
      statement.execute(
          "DELETE FROM vehicle" + testNum + "  WHERE time <= 100 and deviceId = 'd2'");
      expectedPointNumOfDevice = new int[] {0, 351, 300, 391, 391};
      checkDevicePoint(expectedPointNumOfDevice, statement, testNum);

      // remain d1[50, 400] d2[101, 400] d3[301, 400] d4[10, 400]
      statement.execute(
          "DELETE FROM vehicle" + testNum + "  WHERE time <= 300 and deviceId = 'd3'");
      expectedPointNumOfDevice = new int[] {0, 351, 300, 100, 391};
      checkDevicePoint(expectedPointNumOfDevice, statement, testNum);

      // remain d1[50, 400] d2[101, 400] d3[301, 400] d4[10, 100]
      statement.execute("DELETE FROM vehicle" + testNum + "  WHERE time > 100 and deviceId = 'd4'");
      expectedPointNumOfDevice = new int[] {0, 351, 300, 100, 91};
      checkDevicePoint(expectedPointNumOfDevice, statement, testNum);
    }
    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