diff options
author | Sergey Vojtovich <svoj@mariadb.org> | 2018-04-03 16:19:37 +0400 |
---|---|---|
committer | Sergey Vojtovich <svoj@mariadb.org> | 2018-04-20 17:05:28 +0400 |
commit | 3dec6c48bce84a6c804f2a714aa899aef8c45f93 (patch) | |
tree | 97bcb6b0a8a6c2e2c9588fe35e5853def16e0b2c /mysql-test/main/column_compression.test | |
parent | 43ab88f0ea4169f5b1a4681320c4fa5f5423585e (diff) | |
download | mariadb-git-3dec6c48bce84a6c804f2a714aa899aef8c45f93.tar.gz |
MDEV-15762 - VARCHAR(0) COMPRESSED crashes the server
Character set safe truncation is done when storing non-empty string in
VARCHAR(0) COMPRESSED column, so that string becomes empty. The code
didn't expect empty string after truncation.
Fixed by moving empty string check after truncation.
Diffstat (limited to 'mysql-test/main/column_compression.test')
-rw-r--r-- | mysql-test/main/column_compression.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/main/column_compression.test b/mysql-test/main/column_compression.test index 6d6ed3d3993..af1886e0a54 100644 --- a/mysql-test/main/column_compression.test +++ b/mysql-test/main/column_compression.test @@ -91,3 +91,14 @@ SET SESSION optimizer_switch = 'derived_merge=off'; SELECT * FROM ( SELECT * FROM t1 ) AS sq ORDER BY b; SET SESSION optimizer_switch=DEFAULT; DROP TABLE t1; + + +--echo # +--echo # MDEV-15762 - VARCHAR(0) COMPRESSED crashes the server +--echo # +CREATE TABLE t1(a VARCHAR(0) COMPRESSED); +--error ER_DATA_TOO_LONG +INSERT INTO t1 VALUES('a'); +INSERT INTO t1 VALUES(' '); +SELECT LENGTH(a) FROM t1; +DROP TABLE t1; |