MySQL Error 4112 – ER_CREATE_SELECT_WITH_GIPK_DISALLOWED_IN_SBR

MySQL Error Message

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.

Reason for the Error

ER_CREATE_SELECT_WITH_GIPK_DISALLOWED_IN_SBR
was added in 8.0.30.