diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/include/have_compress.inc | 4 | ||||
| -rw-r--r-- | mysql-test/r/func_compress.result | 35 | ||||
| -rw-r--r-- | mysql-test/r/have_compress.require | 2 | ||||
| -rw-r--r-- | mysql-test/t/func_compress.test | 20 |
4 files changed, 61 insertions, 0 deletions
diff --git a/mysql-test/include/have_compress.inc b/mysql-test/include/have_compress.inc new file mode 100644 index 00000000000..c042cd7452a --- /dev/null +++ b/mysql-test/include/have_compress.inc @@ -0,0 +1,4 @@ +-- require r/have_compress.require +disable_query_log; +show variables like "have_compress"; +enable_query_log; diff --git a/mysql-test/r/func_compress.result b/mysql-test/r/func_compress.result new file mode 100644 index 00000000000..ac48c8b9494 --- /dev/null +++ b/mysql-test/r/func_compress.result @@ -0,0 +1,35 @@ +select @test_compress_string:='string for test compress function aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa '; +@test_compress_string:='string for test compress function aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa ' +string for test compress function aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa +select length(@test_compress_string); +length(@test_compress_string) +117 +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 +select uncompressed_length(compress(@test_compress_string)); +uncompressed_length(compress(@test_compress_string)) +117 +select length(compress(@test_compress_string))<length(@test_compress_string); +length(compress(@test_compress_string))<length(@test_compress_string) +1 +create table t1 (a text, b char(255), c char(4)) type=myisam; +insert into t1 (a,b,c) values (compress(@test_compress_string),compress(@test_compress_string),'d '); +select uncompress(a) from t1; +uncompress(a) +string for test compress function aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa +select uncompress(b) from t1; +uncompress(b) +string for test compress function aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa +select concat('|',c,'|') from t1; +concat('|',c,'|') +|d| +drop table t1; diff --git a/mysql-test/r/have_compress.require b/mysql-test/r/have_compress.require new file mode 100644 index 00000000000..8bda2190fbe --- /dev/null +++ b/mysql-test/r/have_compress.require @@ -0,0 +1,2 @@ +Variable_name Value +have_compress YES diff --git a/mysql-test/t/func_compress.test b/mysql-test/t/func_compress.test new file mode 100644 index 00000000000..2f86a414792 --- /dev/null +++ b/mysql-test/t/func_compress.test @@ -0,0 +1,20 @@ +-- source include/have_compress.inc +# +# Test for compress and uncompress functions: +# + +select @test_compress_string:='string for test compress function aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa '; +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); + +create table t1 (a text, b char(255), c char(4)) type=myisam; +insert into t1 (a,b,c) values (compress(@test_compress_string),compress(@test_compress_string),'d '); +select uncompress(a) from t1; +select uncompress(b) from t1; +select concat('|',c,'|') from t1; +drop table t1;
\ No newline at end of file |