diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb-enlarge-blob.result | 38 | ||||
| -rw-r--r-- | mysql-test/suite/innodb/t/innodb-enlarge-blob.opt | 6 | ||||
| -rw-r--r-- | mysql-test/suite/innodb/t/innodb-enlarge-blob.test | 50 |
3 files changed, 94 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb-enlarge-blob.result b/mysql-test/suite/innodb/r/innodb-enlarge-blob.result new file mode 100644 index 00000000000..e74e954e360 --- /dev/null +++ b/mysql-test/suite/innodb/r/innodb-enlarge-blob.result @@ -0,0 +1,38 @@ +CREATE TABLE t1 (a LONGTEXT) ENGINE=INNODB DEFAULT CHARSET=UTF8 ROW_FORMAT=DYNAMIC; +SHOW WARNINGS; +Level Code Message +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B'); +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +UPDATE t1 SET a=CONCAT(a, RAND(), a); +UPDATE t1 SET a=CONCAT(a, RAND(), a); +UPDATE t1 SET a=CONCAT(a, RAND(), a); +SELECT * from t1; +DROP TABLE t1; +CREATE TABLE t1 (a LONGTEXT) ENGINE=INNODB DEFAULT CHARSET=UTF8 ROW_FORMAT=REDUNDANT; +SHOW WARNINGS; +Level Code Message +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B'); +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +UPDATE t1 SET a=CONCAT(a, RAND(), a); +UPDATE t1 SET a=CONCAT(a, RAND(), a); +UPDATE t1 SET a=CONCAT(a, RAND(), a); +SELECT * from t1; +DROP TABLE t1; diff --git a/mysql-test/suite/innodb/t/innodb-enlarge-blob.opt b/mysql-test/suite/innodb/t/innodb-enlarge-blob.opt new file mode 100644 index 00000000000..4c2cd9b3e3c --- /dev/null +++ b/mysql-test/suite/innodb/t/innodb-enlarge-blob.opt @@ -0,0 +1,6 @@ +--innodb-file-per-table +--innodb-file-format='Barracuda' +--innodb-buffer-pool-size=32M +--innodb-log-file-size=32M +--innodb-strict-mode=OFF + diff --git a/mysql-test/suite/innodb/t/innodb-enlarge-blob.test b/mysql-test/suite/innodb/t/innodb-enlarge-blob.test new file mode 100644 index 00000000000..84c23465a5c --- /dev/null +++ b/mysql-test/suite/innodb/t/innodb-enlarge-blob.test @@ -0,0 +1,50 @@ +--source include/have_innodb.inc +--source include/innodb_page_size.inc + +# +# MDEV-13227: Assertion failure len < 16384 in file rem0rec.cc line 1285 +# Crashes with innodb_page_size=64K. Does not crash at <= 32K. +# +CREATE TABLE t1 (a LONGTEXT) ENGINE=INNODB DEFAULT CHARSET=UTF8 ROW_FORMAT=DYNAMIC; +SHOW WARNINGS; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B'); +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +UPDATE t1 SET a=CONCAT(a, RAND(), a); +UPDATE t1 SET a=CONCAT(a, RAND(), a); +UPDATE t1 SET a=CONCAT(a, RAND(), a); +# random data no output we are only interested if fails +--disable_result_log +SELECT * from t1; +--enable_result_log +DROP TABLE t1; + +CREATE TABLE t1 (a LONGTEXT) ENGINE=INNODB DEFAULT CHARSET=UTF8 ROW_FORMAT=REDUNDANT; +SHOW WARNINGS; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B'); +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1; +UPDATE t1 SET a=CONCAT(a, RAND(), a); +UPDATE t1 SET a=CONCAT(a, RAND(), a); +UPDATE t1 SET a=CONCAT(a, RAND(), a); +# random data no output we are only interested if fails +--disable_result_log +SELECT * from t1; +--enable_result_log +DROP TABLE t1; |