1
#############################################################
2
# Author: Serge Kozlov <skozlov@mysql.com>
4
# Purpose: testing bug report
5
# Bug#23533: CREATE SELECT max_binlog_cache_size test
7
#############################################################
9
--source include/have_innodb.inc
10
--source include/have_binlog_format_row.inc
11
--source include/master-slave.inc
15
DROP TABLE IF EXISTS t1,t2;
19
SET GLOBAL max_binlog_cache_size=4096;
20
SHOW VARIABLES LIKE 'max_binlog_cache_size';
22
CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b TEXT, PRIMARY KEY(a)) ENGINE=InnoDB;
28
eval INSERT INTO t1 VALUES($i, REPEAT('x', 4096));
33
SELECT COUNT(*) FROM t1;
35
# Copied data from t1 into t2 large than max_binlog_cache_size
38
CREATE TABLE t2 SELECT * FROM t1;
40
SHOW TABLES LIKE 't%';