@Test
  public void testUnsupportedValueFilter() throws SQLException {
    try (Connection connection = EnvFactory.getEnv().getConnection(BaseEnv.TABLE_SQL_DIALECT);
        Statement statement = connection.createStatement()) {
      statement.execute("use test");
      statement.execute(
          "CREATE TABLE vehicle1(deviceId STRING TAG, s0 INT32 FIELD, s1 INT64 FIELD, s2 FLOAT FIELD, s3 TEXT FIELD, s4 BOOLEAN FIELD, attr1 ATTRIBUTE)");

      statement.execute("insert into vehicle1(time, deviceId, s0) values (10, 'd0', 310)");
      statement.execute("insert into vehicle1(time, deviceId, s3) values (10, 'd0','text')");
      statement.execute("insert into vehicle1(time, deviceId, s4) values (10, 'd0',true)");

      try {
        statement.execute("DELETE FROM vehicle1  WHERE s0 <= 300 AND s0 > 0");
        fail("should not reach here!");
      } catch (SQLException e) {
        assertEquals("701: The column 's0' does not exist or is not a tag column", e.getMessage());
      }

      try {
        statement.execute("DELETE FROM vehicle1  WHERE s1 = 'text'");
        fail("should not reach here!");
      } catch (SQLException e) {
        assertEquals("701: The column 's1' does not exist or is not a tag column", e.getMessage());
      }

      try {
        statement.execute("DELETE FROM vehicle1  WHERE attr1 = 'text'");
        fail("should not reach here!");
      } catch (SQLException e) {
        assertEquals(
            "701: The column 'attr1' does not exist or is not a tag column", e.getMessage());
      }

      try {
        statement.execute("DELETE FROM vehicle1  WHERE s3 = 'text'");
        fail("should not reach here!");
      } catch (SQLException e) {
        assertEquals("701: The column 's3' does not exist or is not a tag column", e.getMessage());
      }

      try {
        statement.execute("DELETE FROM vehicle1  WHERE s4 != true");
        fail("should not reach here!");
      } catch (SQLException e) {
        assertEquals("701: The column 's4' does not exist or is not a tag column", e.getMessage());
      }

      try {
        statement.execute("DELETE FROM vehicle1  WHERE time < 10 and deviceId > 'd0'");
        fail("should not reach here!");
      } catch (SQLException e) {
        assertEquals("701: The operator of tag predicate must be '=' for 'd0'", e.getMessage());
      }

      try {
        statement.execute("DELETE FROM vehicle1  WHERE time < 10 and deviceId is not null");
        fail("should not reach here!");
      } catch (SQLException e) {
        assertEquals(
            "701: Unsupported expression: (deviceId IS NOT NULL) in ((time < 10) AND (deviceId IS NOT NULL))",
            e.getMessage());
      }

      try {
        statement.execute("DELETE FROM vehicle1  WHERE time < 10 and deviceId = null");
        fail("should not reach here!");
      } catch (SQLException e) {
        assertEquals(
            "701: The right hand value of tag predicate cannot be null with '=' operator, please use 'IS NULL' instead",
            e.getMessage());
      }

      try {
        statement.execute("DELETE FROM vehicle1 WHERE true");
        fail("should not reach here!");
      } catch (SQLException e) {
        assertEquals("701: Unsupported expression: true in true", e.getMessage());
      }

      try {
        statement.execute("DELETE FROM vehicleNonExist");
        fail("should not reach here!");
      } catch (SQLException e) {
        assertEquals("701: Table vehiclenonexist not found", e.getMessage());
      }

      try (ResultSet set = statement.executeQuery("SELECT s0 FROM vehicle1")) {
        int cnt = 0;
        while (set.next()) {
          cnt++;
        }
        assertEquals(1, cnt);
      }

      try (ResultSet set = statement.executeQuery("SELECT s3 FROM vehicle1")) {
        int cnt = 0;
        while (set.next()) {
          cnt++;
        }
        assertEquals(1, cnt);
      }

      try (ResultSet set = statement.executeQuery("SELECT s4 FROM vehicle1")) {
        int cnt = 0;
        while (set.next()) {
          cnt++;
        }
        assertEquals(1, cnt);
      }
    }
  }
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