1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
# transaction_log_large_blob.test
# test of how the transaction log captures larger blob values
# Ignore startup/shutdown events
--disable_query_log
--source ../plugin/transaction_log/tests/t/truncate_log.inc
--enable_query_log
--echo LARGE BLOB INSERT
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b BLOB, PRIMARY KEY (a));
# We place the INSERTs in the include file for readability / maintainability
# we include a 100k character string for INSERTing
--source ../plugin/transaction_log/tests/t/large_blob_load.inc
# check transaction log contents
--source ../plugin/transaction_log/tests/t/check_transaction_log.inc
--echo
DROP TABLE t1;
# Truncate the log file to reset for the next test
--source ../plugin/transaction_log/tests/t/truncate_log.inc
|