MySQL error code
MySQL error 4112
MySQL server error 4112 is ER_CREATE_SELECT_WITH_GIPK_DISALLOWED_IN_SBR, reported with SQLSTATE HY000.
Generating an invisible primary key for a table created using CREATE TABLE ... SELECT ... is disallowed when binlog_format=STATEMENT. It cannot be guaranteed that the SELECT retrieves rows in the same order on source and replica. Therefore, it cannot be guaranteed that the value generated for the generated implicit primary key column will be the same on source and replica for all rows. Use binlog_format=ROW or MIXED to execute this statement.
| Error | 4112 |
|---|---|
| Name | ER_CREATE_SELECT_WITH_GIPK_DISALLOWED_IN_SBR |
| SQLSTATE | HY000 |
| Group | Server errors |
Source: MySQL 8.4 Error Reference