~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/t/func_compress.test

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

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

Show diffs side-by-side

added

removed

mysql-test/t/func_compress.test

1

 

#-- source include/have_compress.inc

 

1

-- source include/have_compress.inc

2

2

#

3

3

# Test for compress and uncompress functions:

4

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 blob, b blob, c varchar(4));

 

18

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

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 blob);

 

34

create table t1 (a text);

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