Debian Codegraph @

mysql-test/suite/galera/t/galera_binlog_cache_size.test

raw
1 #
2 # Test that Galera, like the stock MySQL, returns an error on transactions
3 # larger than max_binlog_cache_size
4 #
5
6 --source include/galera_cluster.inc
7 --source include/have_innodb.inc
8
9 CREATE TABLE t1 (f1 VARCHAR(767)) ENGINE=InnoDB;
10 CREATE TABLE ten (f1 INTEGER);
11 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
12
13 --let $max_binlog_cache_size_orig = `SELECT @@max_binlog_cache_size`
14 --let $binlog_cache_size_orig = `SELECT @@binlog_cache_size`
15
16 SET GLOBAL binlog_cache_size=4096;
17 SET GLOBAL max_binlog_cache_size=4096;
18
19 --let $galera_connection_name = node_1a
20 --let $galera_server_number = 1
21 --source include/galera_connect.inc
22 --connection node_1a
23 SET AUTOCOMMIT=ON;
24 START TRANSACTION;
25 INSERT INTO t1 SELECT REPEAT('a', 767) FROM ten;
26 --error ER_TRANS_CACHE_FULL
27 INSERT INTO t1 SELECT REPEAT('a', 767) FROM ten;
28
29 --disable_query_log
30 --eval SET GLOBAL max_binlog_cache_size = $max_binlog_cache_size_orig
31 --eval SET GLOBAL binlog_cache_size = $binlog_cache_size_orig
32 --enable_query_log
33
34 DROP TABLE t1;
35 DROP TABLE ten;