1 --source include/have_innodb_plugin.inc
2 --source include/have_debug.inc
9 key i2 (f2)) engine=innodb;
12 insert into `t1` (rowid, f1, f2) values (1, 1, 10), (2, 1, NULL);
14 connect (a,localhost,root,,);
15 connect (b,localhost,root,,);
18 start transaction with consistent snapshot;
22 update t1 set f2 = 4 where f1 = 1 and f2 is null;
24 -- echo (b) Number of rows updated:
27 insert into t1 values (3, 1, null);
29 -- echo (b) After update and insert query.
30 select rowid, f1, f2 from t1;
36 -- echo (a) Before the update statement is executed.
37 select rowid, f1, f2 from t1;
39 SET SESSION debug="+d,bug14007649";
40 update t1 set f2 = 6 where f1 = 1 and f2 is null;
42 -- echo (a) Number of rows updated:
45 -- echo (a) After the update statement is executed.
46 select rowid, f1, f2 from t1;
50 --echo "The trx with consistent snapshot ended."
52 select rowid, f1, f2 from t1;