2
drop table if exists t1;
3
## Creating new table t1 ##
6
id INT NOT NULL auto_increment,
10
'#--------------------FN_DYNVARS_070_01-------------------------#'
11
## Setting value of max_allowed packet and net_buffer_length to 1024 ##
12
SET @@session.max_allowed_packet = 1024;
13
ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value
14
SELECT @@session.max_allowed_packet;
15
@@session.max_allowed_packet
17
SET @@session.net_buffer_length = 1024;
18
ERROR HY000: SESSION variable 'net_buffer_length' is read-only. Use SET GLOBAL to assign the value
19
SELECT @@session.net_buffer_length;
20
@@session.net_buffer_length
22
'#--------------------FN_DYNVARS_070_02-------------------------#'
23
## Setting value of max_allowed packet and net_buffer_length to 1024 ##
24
SET @@global.max_allowed_packet = 1024;
25
SET @@global.net_buffer_length = 1024;
26
SELECT @@global.max_allowed_packet;
27
@@global.max_allowed_packet
29
SELECT @@global.net_buffer_length;
30
@@global.net_buffer_length
32
## Creating new connection test_con1 ##
33
## Inserting and fetching data of length greater than 1024 ##
34
INSERT into t1(name) values("aaassssssssddddddddffffffgggggggg, askdlfjalsdkjfalksdjflaksdjfalkjdflaksjdflakjdflajsflajflajdfalsjfdlajfladjslfajdflajdsflajsflakjsdfla;kjflsdjkf;aljfa;lkdsfjla;sjlkajffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllakjsdffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffa;;;;;;;;;;;;;;;;;;;;;;;;;;;dsklfjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjkljffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdkskkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");
36
SET @@global.max_allowed_packet = 1048576;
37
## Server disconnects after this case and error occurs that Server ##