diff options
| author | Andrei Elkin <aelkin@mysql.com> | 2010-05-04 22:31:49 +0300 |
|---|---|---|
| committer | Andrei Elkin <aelkin@mysql.com> | 2010-05-04 22:31:49 +0300 |
| commit | efcc90b6eb3e20a0bfb787e94236416090e77d4d (patch) | |
| tree | 5638f53c399d053c27ed8b69bebdecb0d14fb7bc /mysql-test/extra | |
| parent | 95e712b0b781ea07de7ec3993daca207dba5f363 (diff) | |
| download | mariadb-git-efcc90b6eb3e20a0bfb787e94236416090e77d4d.tar.gz | |
Bug #50942 mix_innodb_myisam_side_effects.test is not deterministic
The test was used to fail because of
UPDATE t3,t4 SET t3.a=t4.a + bug27417(1);
did not prescribe the order of two row operations implied by the update.
Fixed with forcing the order with adding a where condition w/o
affecting the former bug fixes logics.
mysql-test/extra/binlog_tests/mix_innodb_myisam_side_effects.test:
implemented the bug page suggestion to make a test deterministic.
mysql-test/suite/binlog/r/binlog_row_mix_innodb_myisam.result:
results are updated and (!) corrected.
mysql-test/suite/binlog/r/binlog_stm_mix_innodb_myisam.result:
results are updated
Diffstat (limited to 'mysql-test/extra')
| -rw-r--r-- | mysql-test/extra/binlog_tests/mix_innodb_myisam_side_effects.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/extra/binlog_tests/mix_innodb_myisam_side_effects.test b/mysql-test/extra/binlog_tests/mix_innodb_myisam_side_effects.test index 26a70c4319e..68aa949a7c7 100644 --- a/mysql-test/extra/binlog_tests/mix_innodb_myisam_side_effects.test +++ b/mysql-test/extra/binlog_tests/mix_innodb_myisam_side_effects.test @@ -214,7 +214,7 @@ CREATE TABLE t5 (a int, PRIMARY KEY (a)) ENGINE=InnoDB; # execute --error ER_DUP_ENTRY - UPDATE t3,t4 SET t3.a=t4.a + bug27417(1); + UPDATE t3,t4 SET t3.a = t4.a + bug27417(1) where t3.a = 1; # check select count(*) from t1 /* must be 1 */; |