Bug #53695 Test "func_compress" exceeds platform capabilities: Data too large
Submitted: 17 May 2010 10:36
Reporter: Joerg Bruehe Email Updates:
Status: Verified Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.0 OS:HP/UX (HP-PA 32 bit)
Assigned to: CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[17 May 2010 10:36] Joerg Bruehe
Description:
This bug report is for documentation only, I don't expect this to be fixed in 5.0.

This test failure occurs since at least times of 5.0.72, but never got reported. The occurrence reported here is of the 5.0.91 build:

=====
func_compress                  [ fail ]

mysqltest: At line NNN: query 'select compress(repeat('aaaaaaaaaa', IF('$LOW_MEMORY', 10, 10000000))) is null' failed: 5: Out of memory (Needed 120000024 bytes)

The result from queries just before the failure was:
< snip >
create table t1 (a text);
insert t1 values (compress(null)), ('A\0\0\0BBBBBBBB'), (compress(space(50000))), (space(50000));
select length(a) from t1;
length(a)
NULL
12
76
50000
select length(uncompress(a)) from t1;
length(uncompress(a))
NULL
NULL
50000
NULL
Warnings:
Error   1259    ZLIB: Input data corrupted
Error   1256    Uncompressed data size too large; the maximum size is 1048576 (probably, length of uncompressed data was corrupted)
drop table t1;
set @@global.max_allowed_packet=1048576*100;
select compress(repeat('aaaaaaaaaa', IF(XXX, 10, 10000000))) is null;

More results from queries before failure can be found in /PATH/mysql-test/var/log/func_compress.log

Stopping All Servers
=====

This happens in debug builds only; in optimized ones, the test passes.

It occurs in "community" and "enterprise" configurations, but not in "classic" or "cluster" - so it might be coupled to InnoDB being configured, but I haven't done any analysis why this might be related.

How to repeat:
Build + run tests.

Suggested fix:
None - 5.0 is in extended maintenance, and the problem is specific to "debug" builds.
[18 May 2010 10:05] Joerg Bruehe
This bug was seen in 5.0 only, not in 5.1.
In 5.5, the platform (HP-UX HPPA) is discontinued.