Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.6.10
-
None
Description
Hello
The table with composed primary key compose on 3 varchar(256) we alter it on a replica to add invisible serial and move the primary to unique and this break the replicas on row based event
Last_SQL_Error Column 0 of table 'varchar(765 octets)' to type 'bigint(20) unsigned
|
I would suggest that if a column is invisible it should be ignored from the replica in mapping a row event array to column name of the table when the event have less column count than the destination columns
I think it may not be a bug but a documentation issue as what about auto_increment if it is affected on the replica than it's not on the leader and would produce data divergence
Attachments
Issue Links
- relates to
-
MDEV-24001 Implement hidden PK for RBR of no-unique key table
- Open