bzr commit into mysql-5.0-bugteam branch (Alexey.Kopytov:2749) Bug#44796

[Alexey Kopytov]

#At file:///Users/kaa/src/bzr/bugteam/bug44796/my50-bug44796/ based on revid:alexey.kopytov@stripped

 2749 Alexey Kopytov	2009-05-21
      Fixed a PB failure introduced by the patch for bug #44796.
      
      Set max_allowed_packet to get a consistent error message.
      modified:
        mysql-test/r/func_compress.result
        mysql-test/t/func_compress.test

=== modified file 'mysql-test/r/func_compress.result'
--- a/mysql-test/r/func_compress.result	2009-05-20 08:30:06 +0000
+++ b/mysql-test/r/func_compress.result	2009-05-21 15:14:56 +0000
@@ -116,6 +116,8 @@ Warnings:
 Error	1259	ZLIB: Input data corrupted
 Error	1259	ZLIB: Input data corrupted
 drop table t1;
+SET @old_max_allowed_packet = @@max_allowed_packet;
+SET @@max_allowed_packet = 1024 * 1024;
 CREATE TABLE t1 (c1 INT);
 INSERT INTO t1 VALUES (1), (1111), (11111);
 SELECT UNCOMPRESS(c1), UNCOMPRESSED_LENGTH(c1) FROM t1;
@@ -128,7 +130,8 @@ Error	1259	ZLIB: Input data corrupted
 Error	1259	ZLIB: Input data corrupted
 Error	1259	ZLIB: Input data corrupted
 Error	1259	ZLIB: Input data corrupted
-Error	1256	Uncompressed data size too large; the maximum size is 104857600 (probably, length of uncompressed data was corrupted)
+Error	1256	Uncompressed data size too large; the maximum size is 1048576 (probably, length of uncompressed data was corrupted)
 EXPLAIN EXTENDED SELECT * FROM (SELECT UNCOMPRESSED_LENGTH(c1) FROM t1) AS s;
+SET @@max_allowed_packet = @old_max_allowed_packet;
 DROP TABLE t1;
 End of 5.0 tests

=== modified file 'mysql-test/t/func_compress.test'
--- a/mysql-test/t/func_compress.test	2009-05-20 08:30:06 +0000
+++ b/mysql-test/t/func_compress.test	2009-05-21 15:14:56 +0000
@@ -87,6 +87,9 @@ drop table t1;
 #             uncompressed_length
 #
 
+SET @old_max_allowed_packet = @@max_allowed_packet;
+SET @@max_allowed_packet = 1024 * 1024;
+
 CREATE TABLE t1 (c1 INT);
 INSERT INTO t1 VALUES (1), (1111), (11111);
 
@@ -97,6 +100,8 @@ SELECT UNCOMPRESS(c1), UNCOMPRESSED_LENG
 EXPLAIN EXTENDED SELECT * FROM (SELECT UNCOMPRESSED_LENGTH(c1) FROM t1) AS s;
 --enable_result_log
 
+SET @@max_allowed_packet = @old_max_allowed_packet;
+
 DROP TABLE t1;
 
 --echo End of 5.0 tests