@Test
  public void testMultiDevicePartialDeletionMultiExecution() throws SQLException {
    int testNum = 17;
    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 d0[10, 400] d1[10, 400] d2[1, 400] d3[1, 400] d4[1, 400]
      statement.execute(
          "DELETE FROM vehicle"
              + testNum
              + " WHERE time < 10 and (deviceId = 'd0' or deviceId = 'd1')");
      int[] expectedPointNumOfDevice = new int[] {391, 391, 400, 400, 400};
      checkDevicePoint(expectedPointNumOfDevice, statement, testNum);

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

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

      // remain d0[101, 150] d1[50, 150] d2[101, 150] d3[101, 150] d4[101, 150]
      statement.execute(
          "DELETE FROM vehicle"
              + testNum
              + " WHERE time > 150 and (deviceId = 'd2' or deviceId = 'd3' or deviceId = 'd4' or deviceId = 'd0' or deviceId = 'd1')");
      expectedPointNumOfDevice = new int[] {50, 101, 50, 50, 50};
      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