diff options
Diffstat (limited to 'mysql-test/main/mysql-bug41486.result')
-rw-r--r-- | mysql-test/main/mysql-bug41486.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/main/mysql-bug41486.result b/mysql-test/main/mysql-bug41486.result new file mode 100644 index 00000000..d5760dcb --- /dev/null +++ b/mysql-test/main/mysql-bug41486.result @@ -0,0 +1,19 @@ +DROP TABLE IF EXISTS t1; +SET @old_max_allowed_packet= @@global.max_allowed_packet; +SET @@global.max_allowed_packet = 2 * 1024 * 1024 + 1024; +connect con1, localhost, root,,; +CREATE TABLE t1(data LONGBLOB); +INSERT INTO t1 SELECT REPEAT('1', 2*1024*1024); +SELECT COUNT(*) FROM t1; +COUNT(*) +1 +SET @old_general_log = @@global.general_log; +SET @@global.general_log = 0; +SET @@global.general_log = @old_general_log; +SELECT LENGTH(data) FROM t1; +LENGTH(data) +2097152 +DROP TABLE t1; +disconnect con1; +connection default; +SET @@global.max_allowed_packet = @old_max_allowed_packet; |