diff options
| author | unknown <vva@eagle.mysql.r18.ru> | 2003-04-09 20:50:30 -0400 |
|---|---|---|
| committer | unknown <vva@eagle.mysql.r18.ru> | 2003-04-09 20:50:30 -0400 |
| commit | f82e15baaabde8259ae3b1a34dccff4d4b19f7c6 (patch) | |
| tree | bd0630d1e16baaeb815da46e7de6032c9f3d82e7 /mysql-test/r/func_compress.result | |
| parent | d835f4ef4cff0b55ca60bded986ecff18bd483a4 (diff) | |
| download | mariadb-git-f82e15baaabde8259ae3b1a34dccff4d4b19f7c6.tar.gz | |
added compress/uncompress function
sql/mysql_priv.h:
added have_compress variable
sql/mysqld.cc:
added have_compress variable
sql/set_var.cc:
added have_compress variable
Diffstat (limited to 'mysql-test/r/func_compress.result')
| -rw-r--r-- | mysql-test/r/func_compress.result | 35 |
1 files changed, 35 insertions, 0 deletions
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; |