summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_compress.result
diff options
context:
space:
mode:
authorunknown <ramil/ram@myoffice.izhnet.ru>2006-10-13 19:33:28 +0500
committerunknown <ramil/ram@myoffice.izhnet.ru>2006-10-13 19:33:28 +0500
commit20a2a9978962c9af3cf69aebd66009992835d9ea (patch)
tree9c9c91382f581214dcf7193aded0343de592ac99 /mysql-test/r/func_compress.result
parent53f3a0e2ddb2716f531927750d5ba52ab7631cee (diff)
parent0ace2b44ba0410e901d18c5315837647c8436c1d (diff)
downloadmariadb-git-20a2a9978962c9af3cf69aebd66009992835d9ea.tar.gz
Merge mysql.com:/usr/home/ram/work/bug23254/my50-bug23254
into mysql.com:/usr/home/ram/work/bug23254/my51-bug23254 mysql-test/r/func_compress.result: Auto merged sql/item_strfunc.cc: Auto merged
Diffstat (limited to 'mysql-test/r/func_compress.result')
-rw-r--r--mysql-test/r/func_compress.result10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/func_compress.result b/mysql-test/r/func_compress.result
index 1a5e64978e6..715f319198c 100644
--- a/mysql-test/r/func_compress.result
+++ b/mysql-test/r/func_compress.result
@@ -79,6 +79,16 @@ uncompress(a) uncompressed_length(a)
NULL NULL
a 1
drop table t1;
+create table t1(a blob);
+insert into t1 values ('0'), (NULL), ('0');
+select compress(a), compress(a) from t1;
+select compress(a) is null from t1;
+compress(a) is null
+0
+1
+0
+drop table t1;
+End of 4.1 tests
create table t1 (a varchar(32) not null);
insert into t1 values ('foo');
explain select * from t1 where uncompress(a) is null;