summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_compress.test
diff options
context:
space:
mode:
authorunknown <ramil@mysql.com>2006-04-13 16:19:21 +0500
committerunknown <ramil@mysql.com>2006-04-13 16:19:21 +0500
commit5c87b55f7e48780d59f32b2867b119ae732c6680 (patch)
treebd732f89d94100171262ccf27f6cf2ebf21aa37f /mysql-test/t/func_compress.test
parentd7caa2a02aedec5a294bbb0c64aed048f23dc6be (diff)
downloadmariadb-git-5c87b55f7e48780d59f32b2867b119ae732c6680.tar.gz
Fix for bug #18643: crazy UNCOMPRESS().
mysql-test/r/func_compress.result: Fix for bug #18643: crazy UNCOMPRESS(). - test-case mysql-test/t/func_compress.test: Fix for bug #18643: crazy UNCOMPRESS(). - test-case sql/item_strfunc.cc: Fix for bug #18643: crazy UNCOMPRESS(). - set null_value.
Diffstat (limited to 'mysql-test/t/func_compress.test')
-rw-r--r--mysql-test/t/func_compress.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/func_compress.test b/mysql-test/t/func_compress.test
index 6b85062b9fa..0f3c3cab307 100644
--- a/mysql-test/t/func_compress.test
+++ b/mysql-test/t/func_compress.test
@@ -45,4 +45,13 @@ set @@max_allowed_packet=1048576*100;
--replace_result "''" XXX "'1'" XXX
eval select compress(repeat('aaaaaaaaaa', IF('$LOW_MEMORY', 10, 10000000))) is null;
+#
+# Bug #18643: problem with null values
+#
+
+create table t1(a blob);
+insert into t1 values(NULL), (compress('a'));
+select uncompress(a), uncompressed_length(a) from t1;
+drop table t1;
+
# End of 4.1 tests