diff options
| author | Alexey Kopytov <Alexey.Kopytov@sun.com> | 2009-03-18 11:27:49 +0300 |
|---|---|---|
| committer | Alexey Kopytov <Alexey.Kopytov@sun.com> | 2009-03-18 11:27:49 +0300 |
| commit | 2b2533955f94397396153b09952d1a54e6098a63 (patch) | |
| tree | 6a13287a1d7f06de2d228e4f5268a61034a81630 /mysql-test/t | |
| parent | 89fbca28135f6e0bc4998381c08a9028f671ca1d (diff) | |
| parent | 73a7d99331d8fd0819fb9f7a10081e393590a94d (diff) | |
| download | mariadb-git-2b2533955f94397396153b09952d1a54e6098a63.tar.gz | |
Manual merge.
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/mysql.test | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/t/mysql.test b/mysql-test/t/mysql.test index 40e87ee1cb0..434db51fc6d 100644 --- a/mysql-test/t/mysql.test +++ b/mysql-test/t/mysql.test @@ -332,6 +332,33 @@ EOF remove_file $MYSQLTEST_VARDIR/tmp/bug31060.sql; +# +# Bug #41486: extra character appears in BLOB for every ~40Mb after +# mysqldump/import +# + +# Have to change the global variable as the mysql client will use +# a separate session +set @old_max_allowed_packet = @@global.max_allowed_packet; +# 2 MB blob length + some space for the rest of INSERT query +set @@global.max_allowed_packet = 2 * 1024 * 1024 + 1024; +set @@max_allowed_packet = @@global.max_allowed_packet; + +CREATE TABLE t1(data LONGBLOB); +INSERT INTO t1 SELECT REPEAT('1', 2*1024*1024); + +--exec $MYSQL_DUMP test t1 >$MYSQLTEST_VARDIR/tmp/bug41486.sql +# Check that the mysql client does not insert extra newlines when loading +# strings longer than client's max_allowed_packet +--exec $MYSQL --max_allowed_packet=1M test < $MYSQLTEST_VARDIR/tmp/bug41486.sql 2>&1 +SELECT LENGTH(data) FROM t1; + +remove_file $MYSQLTEST_VARDIR/tmp/bug41486.sql; +DROP TABLE t1; + +set @@global.max_allowed_packet = @old_max_allowed_packet; +set @@max_allowed_packet = @@global.max_allowed_packet; + --echo End of 5.0 tests # |