diff options
| author | unknown <ramil/ram@mysql.com/myoffice.izhnet.ru> | 2006-10-13 21:12:07 +0500 |
|---|---|---|
| committer | unknown <ramil/ram@mysql.com/myoffice.izhnet.ru> | 2006-10-13 21:12:07 +0500 |
| commit | e767ab6df8c44656e04cbe15ab0b8608cace848a (patch) | |
| tree | c1e94cbcba3cd63296d881f8b4679882ed354215 /mysql-test | |
| parent | be831d7306a0b1537ee1ed48768814c9811f0b39 (diff) | |
| parent | 60a21d16975de436d57c9e29f237234b71fd5601 (diff) | |
| download | mariadb-git-e767ab6df8c44656e04cbe15ab0b8608cace848a.tar.gz | |
Merge rkalimullin@bk-internal.mysql.com:/home/bk/mysql-4.1-maint
into mysql.com:/usr/home/ram/work/bug23254/my41-bug23254
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_compress.result | 10 | ||||
| -rw-r--r-- | mysql-test/t/func_compress.test | 14 |
2 files changed, 23 insertions, 1 deletions
diff --git a/mysql-test/r/func_compress.result b/mysql-test/r/func_compress.result index 8d6fa9927ce..ed8d66e9327 100644 --- a/mysql-test/r/func_compress.result +++ b/mysql-test/r/func_compress.result @@ -79,3 +79,13 @@ 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 diff --git a/mysql-test/t/func_compress.test b/mysql-test/t/func_compress.test index 0f3c3cab307..223a5540f38 100644 --- a/mysql-test/t/func_compress.test +++ b/mysql-test/t/func_compress.test @@ -54,4 +54,16 @@ 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 |