Debian Codegraph @

mysql-test/suite/sys_vars/r/max_allowed_packet_func.result

raw
1 SET @start_max_allowed_packet= @@global.max_allowed_packet;
2 SET @start_value= @@global.net_buffer_length;
3 drop table if exists t1;
4 ## Creating new table t1 ##
5 CREATE TABLE t1
6 (
7 id INT NOT NULL auto_increment,
8 PRIMARY KEY (id),
9 name BLOB
10 );
11 '#--------------------FN_DYNVARS_070_01-------------------------#'
12 ## Setting value of max_allowed packet and net_buffer_length to 1024 ##
13 SET @@session.max_allowed_packet = 1024;
14 ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
15 SELECT @@session.max_allowed_packet;
16 @@session.max_allowed_packet
17 67108864
18 SET @@session.net_buffer_length = 1024;
19 ERROR HY000: SESSION variable 'net_buffer_length' is read-only. Use SET GLOBAL to assign the value
20 SELECT @@session.net_buffer_length;
21 @@session.net_buffer_length
22 16384
23 '#--------------------FN_DYNVARS_070_02-------------------------#'
24 ## Setting value of max_allowed packet and net_buffer_length to 1024 ##
25 SET @@global.max_allowed_packet = 1024;
26 Warnings:
27 Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
28 SET @@global.net_buffer_length = 1024;
29 SELECT @@global.max_allowed_packet;
30 @@global.max_allowed_packet
31 1024
32 SELECT @@global.net_buffer_length;
33 @@global.net_buffer_length
34 1024
35 ## Creating new connection test_con1 ##
36 ## Inserting and fetching data of length greater than 1024 ##
37 INSERT into t1(name) values("aaassssssssddddddddffffffgggggggg, askdlfjalsdkjfalksdjflaksdjfalkjdflaksjdflakjdflajsflajflajdfalsjfdlajfladjslfajdflajdsflajsflakjsdfla;kjflsdjkf;aljfa;lkdsfjla;sjlkajffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllakjsdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffa;;;;;;;;;;;;;;;;;;;;;;;;;;;dsklfjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjkljffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdkskkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");
38 drop table t1;
39 SET @@global.max_allowed_packet= @start_max_allowed_packet;
40 SET @@global.net_buffer_length= @start_value;