-- 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 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; select compress(""); select uncompress(""); select uncompress(compress("")); select uncompressed_length("");