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

      statement.execute("DROP TABLE vehicle" + testNum);

      try (ResultSet ignored = statement.executeQuery("SELECT * FROM vehicle" + testNum)) {
        fail("Exception expected");
      } catch (SQLException e) {
        assertEquals("550: Table 'test.vehicle12' does not exist.", e.getMessage());
      }

      statement.execute(
          String.format(
              "CREATE TABLE vehicle%d(deviceId STRING TAG, s0 INT32 FIELD, s1 INT64 FIELD, s2 FLOAT FIELD, s3 TEXT FIELD, s4 BOOLEAN FIELD)",
              testNum));

      try (ResultSet set = statement.executeQuery("SELECT * FROM vehicle" + testNum)) {
        assertFalse(set.next());
      }

      prepareData(testNum, 1);

      statement.execute("DELETE FROM vehicle" + testNum + " WHERE time <= 150");

      try (ResultSet set = statement.executeQuery("SELECT * FROM vehicle" + testNum)) {
        int cnt = 0;
        while (set.next()) {
          cnt++;
        }
        assertEquals(250, cnt);
      }
    }
    cleanData(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