2
# Simple test of the transaction log for when a START TRANSACTION ... COMMIT
3
# is issued, but no data modifications actually occurred. Also tested is
4
# a update that does not update anything.
6
# This situation occurs in, for instance, sysbench, which wraps even SELECTs
11
DROP TABLE IF EXISTS t1;
15
id INT NOT NULL PRIMARY KEY
16
, padding VARCHAR(200) NOT NULL
19
INSERT INTO t1 VALUES (1, "I love testing.");
20
INSERT INTO t1 VALUES (2, "I hate testing.");
22
UPDATE t1 SET id=1 WHERE padding='I love testing.';
26
SELECT * FROM t1 WHERE id = 1;
27
SELECT * FROM t1 WHERE id = 2;