Skip to content

When DROP TABLE with multiple tables listed, and one of them does not exist, TiDB still drops all the remaining tables #64218

@kennytm

Description

@kennytm

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

use test;

create table aa(a bigint primary key); create table cc like aa;
drop table aa, bb, cc;
-- ✅ ERROR 1051 (42S02): Unknown table 'test.bb'
show tables;

2. What did you expect to see? (Required)

+----------------+
| Tables_in_test |
+----------------+
| aa             |
| cc             |
...
+----------------+

3. What did you see instead (Required)

Tables aa and cc are gone

4. What is your TiDB version? (Required)

Reproduced on v6.5.5, v8.5.3 and master

Metadata

Metadata

Assignees

No one assigned

    Labels

    compatibility-mysql8This is a compatibility issue with MySQL 8.0(but NOT 5.7)compatibility-mysql80This is a compatibility issue with MySQL 8.0(but NOT 5.7)component/ddlThis issue is related to DDL of TiDB.type/compatibility

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions