But what does that really mean ? Let’s test the following scenario on MySQL 5.7.20 and 8.0.3:
we create a schema
we create 2 tables (t1 and t2)
we drop 2 tables in one statement but one of the table is not existing (t1 and t3)
we list the tables present in the schema
We can see that as t3 is missing, the statement returns and error ERROR 1051 (42S02): Unknown table 'test_fred.t3' but in 5.7.20, the first table (t1) is deleted anyway. In MySQL 8.0 or the full DDL runs correctly or nothing is applied.
This behavior change can affect some weird workload that I’ve already encountered where multiple tables were dropped if they existed or not. You have been warned, this is way better and safer. Atomic DDLs is the first step of maybe full transactional ones 😉
To find out more, including how to control cookies, see here:
I deeply value the diversity of MySQL developers, users, community and my blog readers. I cannot agree the suffering, oppression, and systemic racism the Black community faces every day. Black lives matter.