← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/r/variables-notembedded.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/variables-notembedded.result
108
108
ERROR HY000: Variable 'slave_skip_errors' is a read only variable
109
109
SET @@global.slave_skip_errors= 7;
110
110
ERROR HY000: Variable 'slave_skip_errors' is a read only variable
 
111
#
 
112
# Bug #11766769 : 59959: SMALL VALUES OF --MAX-ALLOWED-PACKET 
 
113
#   ARE NOT BEING HONORED
 
114
#
 
115
CREATE TABLE t1 (a MEDIUMTEXT);
 
116
SET GLOBAL max_allowed_packet=2048;
 
117
Warnings:
 
118
Warning 1105    The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
 
119
SET GLOBAL net_buffer_length=4096;
 
120
Warnings:
 
121
Warning 1105    The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
 
122
SHOW SESSION VARIABLES LIKE 'max_allowed_packet';
 
123
Variable_name   Value
 
124
max_allowed_packet      2048
 
125
SHOW SESSION VARIABLES LIKE 'net_buffer_length';
 
126
Variable_name   Value
 
127
net_buffer_length       4096
 
128
ERROR 08S01: Got a packet bigger than 'max_allowed_packet' bytes
 
129
SELECT LENGTH(a) FROM t1;
 
130
LENGTH(a)
 
131
SET GLOBAL max_allowed_packet=default;
 
132
SET GLOBAL net_buffer_length=default;
 
133
DROP TABLE t1;
 
134
End of 5.1 tests