2
# Simple test of the transaction log for when a START TRANSACTION ... COMMIT
3
# is issued, but no data modifications actually occurred.
5
# This situation occurs in, for instance, sysbench, which wraps even SELECTs
10
DROP TABLE IF EXISTS t1;
15
, padding VARCHAR(200) NOT NULL
18
INSERT INTO t1 VALUES (1, "I love testing.");
19
INSERT INTO t1 VALUES (2, "I hate testing.");
23
SELECT * FROM t1 WHERE id = 1;
24
SELECT * FROM t1 WHERE id = 2;