search

midenok / mariadb

MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry.
GNU General Public License v2.0
0 stars 0 forks source link

MDEV-28254 Wrong position for row_start, row_end after adding column to implicit versioned table #105

Open midenok opened 2 years ago

midenok commented 2 years ago

Reproduce

--source include/have_binlog_format_row.inc
--source include/master-slave.inc

--let TMP= $MYSQLTEST_VARDIR/tmp
set @@system_versioning_alter_history= keep;

create table t1 (x int) with system versioning;
alter table t1 add column y int;
# --source include/show_binlog_events.inc
--exec $MYSQL_DUMP --databases test > $TMP/dump.sql

--sync_slave_with_master
drop table t1;
--exec $MYSQL_SLAVE test < $TMP/dump.sql
show create table t1;

--connection master
insert t1 values (1, 1);
--sync_slave_with_master

--connection master
drop table t1;
--source include/rpl_end.inc