diff options
| author | unknown <aelkin@mysql.com> | 2006-04-23 12:32:39 +0300 |
|---|---|---|
| committer | unknown <aelkin@mysql.com> | 2006-04-23 12:32:39 +0300 |
| commit | e0ebbf67a308ca58c99b519861a8d884736cd751 (patch) | |
| tree | d9ace40adfab722a50d0f1aeaf05485ca3f80c0b /mysql-test | |
| parent | 8e28ab1f40e60cbd9837468fc0d357335209f877 (diff) | |
| parent | 8ed06b840e2aaac5d01ca2731f9abd53c339d968 (diff) | |
| download | mariadb-git-e0ebbf67a308ca58c99b519861a8d884736cd751.tar.gz | |
Merge mysql.com:/usr_rh9/home/elkin.rh9/MySQL/BARE/4.1
into mysql.com:/usr_rh9/home/elkin.rh9/MySQL/Merge/5.0
mysql-test/t/func_compress.test:
Auto merged
sql/item_strfunc.cc:
Auto merged
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_compress.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/func_compress.test | 9 |
2 files changed, 16 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; diff --git a/mysql-test/t/func_compress.test b/mysql-test/t/func_compress.test index a78017ddb2f..4ae749f2343 100644 --- a/mysql-test/t/func_compress.test +++ b/mysql-test/t/func_compress.test @@ -47,4 +47,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 |