summaryrefslogtreecommitdiff
path: root/mysql-test/r/variables-notembedded.result
diff options
context:
space:
mode:
authorGeorgi Kodinov <Georgi.Kodinov@Oracle.com>2011-03-28 13:25:03 +0300
committerGeorgi Kodinov <Georgi.Kodinov@Oracle.com>2011-03-28 13:25:03 +0300
commita3ab0d92defbafb462c7c5c50bab324521558971 (patch)
tree6d6bba5a1dabaf67b23c65bb2cb8b73ce8cd9ebe /mysql-test/r/variables-notembedded.result
parent29015489116a317843114d30912c1c506787d625 (diff)
downloadmariadb-git-a3ab0d92defbafb462c7c5c50bab324521558971.tar.gz
Fixed a test failure in embedded because of the fix for BUG#11766769
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..8056af49090 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 1105 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 1105 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