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

      statement.execute(
          "DELETE FROM vehicle6 WHERE time <= 300 and time > 150 and deviceId = 'd0'");
      try (ResultSet set = statement.executeQuery("SELECT s0 FROM vehicle6")) {
        int cnt = 0;
        while (set.next()) {
          cnt++;
        }
        assertEquals(250, cnt);
      }

      // Invalid deletion, d1 not exists
      statement.execute("DELETE FROM vehicle6 WHERE time <= 200 and deviceId = 'd1'");
      try (ResultSet set = statement.executeQuery("SELECT s0 FROM vehicle6")) {
        int cnt = 0;
        while (set.next()) {
          cnt++;
        }
        assertEquals(250, cnt);
      }
    }
    cleanData(6);
  }
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