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.