mysql-test/suite/innodb/t/snapshot.test
raw| 1 | |
| 2 | --source include/have_log_bin.inc |
| 3 | --source include/have_binlog_format_row.inc |
| 4 | --source include/have_innodb.inc |
| 5 | |
| 6 | START TRANSACTION WITH CONSISTENT SNAPSHOT; |
| 7 | |
| 8 | --connect (con1,localhost,root,,test) |
| 9 | CREATE TABLE IF NOT EXISTS t1 (pk INT PRIMARY KEY, i INT, KEY(i)) ENGINE=InnoDB; |
| 10 | |
| 11 | --connection default |
| 12 | --error 1412 |
| 13 | UPDATE t1 SET i = 0; |
| 14 | --error 1412 |
| 15 | UPDATE t1 SET pk = 0; |
| 16 | commit; |
| 17 | |
| 18 | drop table t1; |