@Test
  public void testDeviceIdWithNull() throws SQLException {
    int testNum = 14;
    try (Connection connection = EnvFactory.getEnv().getConnection(BaseEnv.TABLE_SQL_DIALECT);
        Statement statement = connection.createStatement()) {
      statement.execute("use test");
      statement.execute(
          "create table t" + testNum + " (tag1 string tag, tag2 string tag, s1 int32 field)");
      // tag1 is null for this record
      statement.execute("insert into t" + testNum + " (time, tag2, s1) values (1, '1', 1)");
      statement.execute("insert into t" + testNum + " (time, tag2, s1) values (2, '', 2)");
      statement.execute("insert into t" + testNum + " (time, tag2, s1) values (3, NULL, 3)");
      statement.execute("flush");

      statement.execute("delete from t" + testNum + " where tag1 is NULL and time <= 1");
      try (ResultSet set = statement.executeQuery("SELECT * FROM t" + testNum + " order by time")) {
        assertTrue(set.next());
        assertEquals(2, set.getLong("time"));
        assertTrue(set.next());
        assertEquals(3, set.getLong("time"));
        assertFalse(set.next());
      }

      statement.execute("delete from t" + testNum + " where tag2 is NULL");
      try (ResultSet set = statement.executeQuery("SELECT * FROM t" + testNum + " order by time")) {
        assertTrue(set.next());
        assertEquals(2, set.getLong("time"));
        assertFalse(set.next());
      }

      statement.execute("delete from t" + testNum);
      try (ResultSet set = statement.executeQuery("SELECT * FROM t" + testNum + " order by time")) {
        assertFalse(set.next());
      }

      statement.execute("drop table t" + 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