mysql-test/suite/rpl/t/rpl_update.test
raw| 1 | source include/master-slave.inc; |
| 2 | |
| 3 | # |
| 4 | # MDEV-13417 UPDATE produces wrong values if an updated column is later used as an update source |
| 5 | # |
| 6 | set sql_mode=simultaneous_assignment; |
| 7 | create table t1 (a int, b int); |
| 8 | insert into t1 values(1, 2); |
| 9 | update t1 set a=b, b=a; |
| 10 | select * from t1; |
| 11 | sync_slave_with_master; |
| 12 | select * from t1; |
| 13 | connection master; |
| 14 | drop table t1; |
| 15 | source include/rpl_end.inc; |