summaryrefslogtreecommitdiff
path: root/mysql-test/r/variables-notembedded.result
diff options
context:
space:
mode:
authorGeorgi Kodinov <Georgi.Kodinov@Oracle.com>2011-03-28 13:57:54 +0300
committerGeorgi Kodinov <Georgi.Kodinov@Oracle.com>2011-03-28 13:57:54 +0300
commitb9b40a0c29dfaa74afe85e835b0ee29fadd20433 (patch)
tree8a92672c663f91b40cfeb52671a8c886164ac628 /mysql-test/r/variables-notembedded.result
parentce9074b656521d6621e23dfa8244ff360da2fdb3 (diff)
parent4ed8cb4a76275a28231a842c9112834d384b7b4c (diff)
downloadmariadb-git-b9b40a0c29dfaa74afe85e835b0ee29fadd20433.tar.gz
merge mysql-5.1->mysql-5.5
Diffstat (limited to 'mysql-test/r/variables-notembedded.result')
-rw-r--r--mysql-test/r/variables-notembedded.result24
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/variables-notembedded.result b/mysql-test/r/variables-notembedded.result
index 8c6d54757ed..ceac676589f 100644
--- a/mysql-test/r/variables-notembedded.result
+++ b/mysql-test/r/variables-notembedded.result
@@ -108,3 +108,27 @@ SET @@session.slave_skip_errors= 7;
ERROR HY000: Variable 'slave_skip_errors' is a read only variable
SET @@global.slave_skip_errors= 7;
ERROR HY000: Variable 'slave_skip_errors' is a read only variable
+#
+# Bug #11766769 : 59959: SMALL VALUES OF --MAX-ALLOWED-PACKET
+# ARE NOT BEING HONORED
+#
+CREATE TABLE t1 (a MEDIUMTEXT);
+SET GLOBAL max_allowed_packet=2048;
+Warnings:
+Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
+SET GLOBAL net_buffer_length=4096;
+Warnings:
+Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
+SHOW SESSION VARIABLES LIKE 'max_allowed_packet';
+Variable_name Value
+max_allowed_packet 2048
+SHOW SESSION VARIABLES LIKE 'net_buffer_length';
+Variable_name Value
+net_buffer_length 4096
+ERROR 08S01: Got a packet bigger than 'max_allowed_packet' bytes
+SELECT LENGTH(a) FROM t1;
+LENGTH(a)
+SET GLOBAL max_allowed_packet=default;
+SET GLOBAL net_buffer_length=default;
+DROP TABLE t1;
+End of 5.1 tests