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 > 0;
16 @@session.max_allowed_packet > 0
17 1
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 > 0;
21 @@session.net_buffer_length > 0
22 1
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 connect test_con1,localhost,root,,;
36 connection test_con1;
37 ## Inserting and fetching data of length greater than 1024 ##
38 INSERT into t1(name) values("aaassssssssddddddddffffffgggggggg, askdlfjalsdkjfalksdjflaksdjfalkjdflaksjdflakjdflajsflajflajdfalsjfdlajfladjslfajdflajdsflajsflakjsdfla;kjflsdjkf;aljfa;lkdsfjla;sjlkajffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllakjsdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffa;;;;;;;;;;;;;;;;;;;;;;;;;;;dsklfjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjkljffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdkskkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");
39 disconnect test_con1;
40 connection default;
41 drop table t1;
42 SET @@global.max_allowed_packet= @start_max_allowed_packet;
43 SET @@global.net_buffer_length= @start_value;