diff options
| author | unknown <vva@eagle.mysql.r18.ru> | 2003-04-22 18:41:47 -0400 |
|---|---|---|
| committer | unknown <vva@eagle.mysql.r18.ru> | 2003-04-22 18:41:47 -0400 |
| commit | 5ab46afca6cf1e0ad7a298db54f3971234cb8f6c (patch) | |
| tree | 82a6ee88ce718a01374afecdb2710ee9c420cd6e /mysql-test | |
| parent | 7c87a3f140ac801c0922b3a24e59381f627f105a (diff) | |
| download | mariadb-git-5ab46afca6cf1e0ad7a298db54f3971234cb8f6c.tar.gz | |
small compress/uncompress modification after monty's review
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_compress.result | 17 | ||||
| -rw-r--r-- | mysql-test/t/func_compress.test | 9 |
2 files changed, 19 insertions, 7 deletions
diff --git a/mysql-test/r/func_compress.result b/mysql-test/r/func_compress.result index ac48c8b9494..c4d2eacf363 100644 --- a/mysql-test/r/func_compress.result +++ b/mysql-test/r/func_compress.result @@ -7,11 +7,6 @@ length(@test_compress_string) select uncompress(compress(@test_compress_string)); uncompress(compress(@test_compress_string)) string for test compress function aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa -select uncompress(@test_compress_string); -uncompress(@test_compress_string) -NULL -Warnings: -Error 1254 Too big size of uncompressed data. The maximum size is 8192. (probably, length of uncompressed data was corrupted) select uncompressed_length(compress(@test_compress_string))=length(@test_compress_string); uncompressed_length(compress(@test_compress_string))=length(@test_compress_string) 1 @@ -33,3 +28,15 @@ select concat('|',c,'|') from t1; concat('|',c,'|') |d| drop table t1; +select compress(""); +compress("") + +select uncompress(""); +uncompress("") + +select uncompress(compress("")); +uncompress(compress("")) + +select uncompressed_length(""); +uncompressed_length("") +0 diff --git a/mysql-test/t/func_compress.test b/mysql-test/t/func_compress.test index 2f86a414792..826721a4053 100644 --- a/mysql-test/t/func_compress.test +++ b/mysql-test/t/func_compress.test @@ -7,7 +7,6 @@ select @test_compress_string:='string for test compress function aaaaaaaaaaaaaaa select length(@test_compress_string); select uncompress(compress(@test_compress_string)); -select uncompress(@test_compress_string); select uncompressed_length(compress(@test_compress_string))=length(@test_compress_string); select uncompressed_length(compress(@test_compress_string)); select length(compress(@test_compress_string))<length(@test_compress_string); @@ -17,4 +16,10 @@ insert into t1 (a,b,c) values (compress(@test_compress_string),compress(@test_co select uncompress(a) from t1; select uncompress(b) from t1; select concat('|',c,'|') from t1; -drop table t1;
\ No newline at end of file +drop table t1; + +select compress(""); +select uncompress(""); +select uncompress(compress("")); +select uncompressed_length(""); + |