mysql-test/suite/innodb/r/snapshot.result
raw| 1 | START TRANSACTION WITH CONSISTENT SNAPSHOT; |
| 2 | connect con1,localhost,root,,test; |
| 3 | CREATE TABLE IF NOT EXISTS t1 (pk INT PRIMARY KEY, i INT, KEY(i)) ENGINE=InnoDB; |
| 4 | connection default; |
| 5 | UPDATE t1 SET i = 0; |
| 6 | ERROR HY000: Table definition has changed, please retry transaction |
| 7 | UPDATE t1 SET pk = 0; |
| 8 | ERROR HY000: Table definition has changed, please retry transaction |
| 9 | commit; |
| 10 | drop table t1; |