MySQL error code
MySQL error 3978
MySQL server error 3978 is ER_FOREIGN_KEY_WITH_ATOMIC_CREATE_SELECT, reported with SQLSTATE HY000.
Foreign key creation is not allowed with CREATE TABLE as SELECT and CREATE TABLE with START TRANSACTION statement.
| Error | 3978 |
|---|---|
| Name | ER_FOREIGN_KEY_WITH_ATOMIC_CREATE_SELECT |
| SQLSTATE | HY000 |
| Group | Server errors |
Source: MySQL 8.4 Error Reference