1
################## mysql-test\t\max_allowed_packet_func.test ##################
3
# Variable Name: max_allowed_packet #
4
# Scope: GLOBAL | SESSION #
5
# Access Type: Dynamic #
7
# Default Value:1048576 #
8
# Range:1024-1073741824 #
11
# Creation Date: 2008-03-07 #
12
# Author: Salman Rawala #
14
# Description: Test Cases of Dynamic System Variable max_allowed_packet #
15
# that checks the functionality of this variable #
17
# Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
18
# server-system-variables.html #
20
###############################################################################
22
#due to lost connection on win64
23
--source include/not_windows.inc
25
let $start_global_value = `SELECT @@global.max_allowed_packet`;
26
--echo $start_global_value
29
drop table if exists t1;
32
#########################
33
# Creating new table #
34
#########################
36
--echo ## Creating new table t1 ##
39
id INT NOT NULL auto_increment,
44
--echo '#--------------------FN_DYNVARS_070_01-------------------------#'
45
###############################################################################
46
# Setting initial value of max_allowed_packet to 1024 at session level
47
# should result in an error (session variable is readonly)
48
###############################################################################
50
--echo ## Setting value of max_allowed packet and net_buffer_length to 1024 ##
51
--error ER_VARIABLE_IS_READONLY
52
SET @@session.max_allowed_packet = 1024;
53
SELECT @@session.max_allowed_packet;
55
--error ER_VARIABLE_IS_READONLY
56
SET @@session.net_buffer_length = 1024;
57
SELECT @@session.net_buffer_length;
60
--echo '#--------------------FN_DYNVARS_070_02-------------------------#'
61
###############################################################################
62
# Setting value of max_allowed_packet to 1024 at global level and
63
# verifying its behavior after inserting data greater than 1024 bytes
64
###############################################################################
66
--echo ## Setting value of max_allowed packet and net_buffer_length to 1024 ##
67
SET @@global.max_allowed_packet = 1024;
68
SET @@global.net_buffer_length = 1024;
69
SELECT @@global.max_allowed_packet;
70
SELECT @@global.net_buffer_length;
72
--echo ## Creating new connection test_con1 ##
73
connect (test_con1,localhost,root,,);
76
--echo ## Inserting and fetching data of length greater than 1024 ##
77
--Error 0,ER_NET_PACKET_TOO_LARGE
78
INSERT into t1(name) values("aaassssssssddddddddffffffgggggggg, askdlfjalsdkjfalksdjflaksdjfalkjdflaksjdflakjdflajsflajflajdfalsjfdlajfladjslfajdflajdsflajsflakjsdfla;kjflsdjkf;aljfa;lkdsfjla;sjlkajffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllakjsdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffa;;;;;;;;;;;;;;;;;;;;;;;;;;;dsklfjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjkljffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdkskkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");
83
eval SET @@global.max_allowed_packet = $start_global_value;
85
--echo ## Server disconnects after this case and error occurs that Server ##
86
--echo ## has gone away ##