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

      // init [1, 400]

      // remain [151, 400]
      statement.execute("DELETE FROM vehicle" + testId + " WHERE time <= 150");
      try (ResultSet set = statement.executeQuery("SELECT * FROM vehicle" + testId)) {
        int cnt = 0;
        while (set.next()) {
          cnt++;
        }
        assertEquals(250, cnt);
      }

      // remain [301, 400]
      statement.execute("DELETE FROM vehicle" + testId + " WHERE time <= 300");

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

      // remain [351, 400]
      statement.execute("DELETE FROM vehicle" + testId + " WHERE time <= 350");

      try (ResultSet set = statement.executeQuery("SELECT s1,s2,s3 FROM vehicle" + testId)) {
        int cnt = 0;
        while (set.next()) {
          cnt++;
        }
        assertEquals(50, cnt);
      }

      // remain [361, 380]
      statement.execute("DELETE FROM vehicle" + testId + "  WHERE time <= 360 or time > 380");
      try (ResultSet set = statement.executeQuery("SELECT s1,s2,s3 FROM vehicle" + testId)) {
        int cnt = 0;
        while (set.next()) {
          cnt++;
        }
        assertEquals(20, cnt);
      }
    }
    cleanData(testId);
  }
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