summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_compress.test
diff options
context:
space:
mode:
authorunknown <ramil/ram@mysql.com/myoffice.izhnet.ru>2006-10-13 19:09:22 +0500
committerunknown <ramil/ram@mysql.com/myoffice.izhnet.ru>2006-10-13 19:09:22 +0500
commit0ace2b44ba0410e901d18c5315837647c8436c1d (patch)
treedfd90ca34ee2693bbfa69db04a88e72bebbfb5ca /mysql-test/t/func_compress.test
parenta4f01a94b4d6fdf3d1c79446c7f1a36f50903d1d (diff)
parent60a21d16975de436d57c9e29f237234b71fd5601 (diff)
downloadmariadb-git-0ace2b44ba0410e901d18c5315837647c8436c1d.tar.gz
Merge mysql.com:/usr/home/ram/work/bug23254/my41-bug23254
into mysql.com:/usr/home/ram/work/bug23254/my50-bug23254 sql/item_strfunc.cc: Auto merged mysql-test/r/func_compress.result: SCCS merged mysql-test/t/func_compress.test: SCCS merged
Diffstat (limited to 'mysql-test/t/func_compress.test')
-rw-r--r--mysql-test/t/func_compress.test14
1 files changed, 13 insertions, 1 deletions
diff --git a/mysql-test/t/func_compress.test b/mysql-test/t/func_compress.test
index eeb5d509b94..68f07f258bf 100644
--- a/mysql-test/t/func_compress.test
+++ b/mysql-test/t/func_compress.test
@@ -56,7 +56,19 @@ insert into t1 values(NULL), (compress('a'));
select uncompress(a), uncompressed_length(a) from t1;
drop table t1;
-# End of 4.1 tests
+#
+# Bug #23254: problem with compress(NULL)
+#
+
+create table t1(a blob);
+insert into t1 values ('0'), (NULL), ('0');
+--disable_result_log
+select compress(a), compress(a) from t1;
+--enable_result_log
+select compress(a) is null from t1;
+drop table t1;
+
+--echo End of 4.1 tests
#
# Bug #18539: uncompress(d) is null: impossible?