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