summaryrefslogtreecommitdiff
path: root/mysql-test/main/column_compression.test
diff options
context:
space:
mode:
authorSergey Vojtovich <svoj@mariadb.org>2018-04-03 18:34:46 +0400
committerSergey Vojtovich <svoj@mariadb.org>2018-04-20 17:05:28 +0400
commit38c799c9a5e5aadd3f4df157a4151dd1f71d5bcb (patch)
treede40f9f47e38832c87e314ab32cb38255bf7d0a1 /mysql-test/main/column_compression.test
parent3dec6c48bce84a6c804f2a714aa899aef8c45f93 (diff)
downloadmariadb-git-38c799c9a5e5aadd3f4df157a4151dd1f71d5bcb.tar.gz
MDEV-15763 - VARCHAR(1) COMPRESSED crashes the server
Storing 1 byte long string in VARCHAR() COMPRESSED column may trigger integer overflow when calculating available space for zlib output.
Diffstat (limited to 'mysql-test/main/column_compression.test')
-rw-r--r--mysql-test/main/column_compression.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/main/column_compression.test b/mysql-test/main/column_compression.test
index af1886e0a54..84f17076494 100644
--- a/mysql-test/main/column_compression.test
+++ b/mysql-test/main/column_compression.test
@@ -102,3 +102,13 @@ INSERT INTO t1 VALUES('a');
INSERT INTO t1 VALUES(' ');
SELECT LENGTH(a) FROM t1;
DROP TABLE t1;
+
+
+--echo #
+--echo # MDEV-15763 - VARCHAR(1) COMPRESSED crashes the server
+--echo #
+CREATE TABLE t1(a VARCHAR(1) COMPRESSED);
+SET column_compression_threshold=0;
+INSERT INTO t1 VALUES('a');
+SET column_compression_threshold=DEFAULT;
+DROP TABLE t1;