~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_compress.test

• browse files at revision 511.2.1
• compare with another revision
• download diff
• download tarball
• view history from revision 511.2.1

• reverse the comparison (511.2.1 to 37)
• stop comparing with revision 37

Show diffs side-by-side

added

removed

tests/t/func_compress.test

 

1

#-- source include/have_compress.inc

1

2

#

2

3

# Test for compress and uncompress functions:

3

4

#

15

15

select uncompressed_length(compress(@test_compress_string));

16

16

select length(compress(@test_compress_string))<length(@test_compress_string);

17

17

 

18

 

create table t1 (a text, b char(255), c char(4)) engine=myisam;

 

18

create table t1 (a blob, b blob, c varchar(4));

19

19

insert into t1 (a,b,c) values (compress(@test_compress_string),compress(@test_compress_string),'d ');

20

20

select uncompress(a) from t1;

21

21

select uncompress(b) from t1;

31

31

# errors

32

32

#

33

33

 

34

 

create table t1 (a text);

 

34

create table t1 (a blob);

35

35

insert t1 values (compress(null)), ('A\0\0\0BBBBBBBB'), (compress(space(50000))), (space(50000));

36

36

select length(a) from t1;

37

37

select length(uncompress(a)) from t1;

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1