MySQL Error 3978 – ER_FOREIGN_KEY_WITH_ATOMIC_CREATE_SELECT

MySQL Error Message

Foreign key creation is not allowed with CREATE TABLE as
SELECT and CREATE TABLE with START TRANSACTION statement.

Reason for the Error

ER_FOREIGN_KEY_WITH_ATOMIC_CREATE_SELECT
was added in 8.0.21.