private void prepareData(int testNum, int deviceNum) throws SQLException {
    try (Connection connection = EnvFactory.getEnv().getConnection(BaseEnv.TABLE_SQL_DIALECT);
        Statement statement = connection.createStatement()) {
      statement.execute("use test");
      statement.execute(
          String.format(
              "CREATE TABLE IF NOT EXISTS vehicle%d(deviceId STRING TAG, s0 INT32 FIELD, s1 INT64 FIELD, s2 FLOAT FIELD, s3 TEXT FIELD, s4 BOOLEAN FIELD)",
              testNum));

      for (int d = 0; d < deviceNum; d++) {
        // prepare seq file
        for (int i = 201; i <= 300; i++) {
          statement.execute(
              String.format(
                  insertTemplate, testNum, i, d, i, i, (double) i, "'" + i + "'", i % 2 == 0));
        }
      }

      statement.execute("flush");

      for (int d = 0; d < deviceNum; d++) {
        // prepare unseq File
        for (int i = 1; i <= 100; i++) {
          statement.execute(
              String.format(
                  insertTemplate, testNum, i, d, i, i, (double) i, "'" + i + "'", i % 2 == 0));
        }
      }
      statement.execute("flush");

      for (int d = 0; d < deviceNum; d++) {
        // prepare BufferWrite cache
        for (int i = 301; i <= 400; i++) {
          statement.execute(
              String.format(
                  insertTemplate, testNum, i, d, i, i, (double) i, "'" + i + "'", i % 2 == 0));
        }
        // prepare Overflow cache
        for (int i = 101; i <= 200; i++) {
          statement.execute(
              String.format(
                  insertTemplate, testNum, i, d, i, i, (double) i, "'" + i + "'", i % 2 == 0));
        }
      }
    }
  }
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