summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/innodb/t/snapshot.test
blob: 8e3dc76fe54dc9e7e3c16b328635a5723e942600 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
--source include/have_log_bin.inc
--source include/have_binlog_format_row.inc
--source include/have_innodb.inc

START TRANSACTION WITH CONSISTENT SNAPSHOT;

--connect (con1,localhost,root,,test)
CREATE TABLE IF NOT EXISTS t1 (pk INT PRIMARY KEY, i INT, KEY(i)) ENGINE=InnoDB;

--connection default
--error 1412
UPDATE t1 SET i = 0;
--error 1412
UPDATE t1 SET pk = 0;
commit;

drop table t1;