2
# Tests simple INSERT statements and the transaction log
5
# Ignore startup/shutdown events
7
--source ../plugin/transaction_log/tests/t/truncate_log.inc
11
# Populate log with some records...
12
##--source ../plugin/transaction_log/tests/t/insert.inc
14
# Simple test of the transaction log for single INSERT statements
16
# We create a table and insert some records
19
# We then use the transaction_reader in plugin/transaction_log/utilities to read the events.
23
DROP TABLE IF EXISTS t1;
26
pk int auto_increment primary key,
28
, padding VARCHAR(200) NOT NULL
29
) engine=storage_engine_api_tester;
31
SELECT seapitester_error_inject(1);
34
INSERT INTO t1 (id,padding) values (40, "boo"),(41,"scary");
36
INSERT INTO t1 (id,padding) VALUES (1, "I love testing.");
38
INSERT INTO t1 (id,padding) VALUES (2, "I hate testing.");
39
update t1 set padding="bar" where id=1;
41
INSERT INTO t1 (id,padding) VALUES (2, "I hate testing.");
46
select seapitester_error_inject(0);
47
# Read in the transaction.log.
49
--exec ../plugin/transaction_log/utilities/transaction_reader var/master-data/local/transaction.log
51
# Truncate the log file to reset for the next test
52
--source ../plugin/transaction_log/tests/t/truncate_log.inc