summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_compress.result
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/r/func_compress.result
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/r/func_compress.result')
-rw-r--r--mysql-test/r/func_compress.result7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/func_compress.result b/mysql-test/r/func_compress.result
index 9bc8e417e19..8d6fa9927ce 100644
--- a/mysql-test/r/func_compress.result
+++ b/mysql-test/r/func_compress.result
@@ -72,3 +72,10 @@ set @@max_allowed_packet=1048576*100;
select compress(repeat('aaaaaaaaaa', IF(XXX, 10, 10000000))) is null;
compress(repeat('aaaaaaaaaa', IF(XXX, 10, 10000000))) is null
0
+create table t1(a blob);
+insert into t1 values(NULL), (compress('a'));
+select uncompress(a), uncompressed_length(a) from t1;
+uncompress(a) uncompressed_length(a)
+NULL NULL
+a 1
+drop table t1;