Debian Codegraph @

mysql-test/suite/sys_vars/t/max_allowed_packet_func.test

raw
1 ################## mysql-test\t\max_allowed_packet_func.test ##################
2 # #
3 # Variable Name: max_allowed_packet #
4 # Scope: GLOBAL | SESSION #
5 # Access Type: Dynamic #
6 # Data Type: numeric #
7 # Default Value:4194304 #
8 # Range:1024-1073741824 #
9 # #
10 # #
11 # Creation Date: 2008-03-07 #
12 # Author: Salman Rawala #
13 # #
14 # Description: Test Cases of Dynamic System Variable max_allowed_packet #
15 # that checks the functionality of this variable #
16 # #
17 # Reference: #
18 # http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html #
19 # #
20 ###############################################################################
21
22 #due to lost connection on win64
23 --source include/not_windows.inc
24
25 SET @start_max_allowed_packet= @@global.max_allowed_packet;
26 SET @start_value= @@global.net_buffer_length;
27
28 --disable_warnings
29 drop table if exists t1;
30 --enable_warnings
31
32 #########################
33 # Creating new table #
34 #########################
35
36 --echo ## Creating new table t1 ##
37 CREATE TABLE t1
38 (
39 id INT NOT NULL auto_increment,
40 PRIMARY KEY (id),
41 name BLOB
42 );
43
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 ###############################################################################
49
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;
54
55 --error ER_VARIABLE_IS_READONLY
56 SET @@session.net_buffer_length = 1024;
57 SELECT @@session.net_buffer_length;
58
59
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 ###############################################################################
65
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;
71
72 --echo ## Creating new connection test_con1 ##
73 connect (test_con1,localhost,root,,);
74 connection test_con1;
75
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");
79
80 disconnect test_con1;
81 connection default;
82 drop table t1;
83 SET @@global.max_allowed_packet= @start_max_allowed_packet;
84 SET @@global.net_buffer_length= @start_value;
85