1SET @start_global_value = @@global.max_allowed_packet; 2SELECT @start_global_value; 3@start_global_value 44194304 5SET @@global.max_allowed_packet = DEFAULT; 6'#--------------------FN_DYNVARS_070_01-------------------------#' 7SET @@global.max_allowed_packet = 1000; 8Warnings: 9Warning 1292 Truncated incorrect max_allowed_packet value: '1000' 10Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length' 11SET @@global.max_allowed_packet = DEFAULT; 12SELECT @@global.max_allowed_packet; 13@@global.max_allowed_packet 144194304 15SET @@session.max_allowed_packet = 20000; 16ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value 17SET @@session.max_allowed_packet = DEFAULT; 18ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value 19SELECT @@session.max_allowed_packet; 20@@session.max_allowed_packet 214194304 22'#--------------------FN_DYNVARS_070_02-------------------------#' 23SET @@global.max_allowed_packet = DEFAULT; 24SELECT @@global.max_allowed_packet = 4194304; 25@@global.max_allowed_packet = 4194304 261 27'#--------------------FN_DYNVARS_070_03-------------------------#' 28SET @@global.max_allowed_packet = 1024; 29Warnings: 30Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length' 31SELECT @@global.max_allowed_packet; 32@@global.max_allowed_packet 331024 34SET @@global.max_allowed_packet = 1025; 35Warnings: 36Warning 1292 Truncated incorrect max_allowed_packet value: '1025' 37Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length' 38SELECT @@global.max_allowed_packet; 39@@global.max_allowed_packet 401024 41SET @@global.max_allowed_packet = 1073741824; 42SELECT @@global.max_allowed_packet; 43@@global.max_allowed_packet 441073741824 45SET @@global.max_allowed_packet = 1073741823; 46Warnings: 47Warning 1292 Truncated incorrect max_allowed_packet value: '1073741823' 48SELECT @@global.max_allowed_packet; 49@@global.max_allowed_packet 501073740800 51'#--------------------FN_DYNVARS_070_04-------------------------#' 52SET @@session.max_allowed_packet = 1024; 53ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value 54SELECT @@session.max_allowed_packet; 55@@session.max_allowed_packet 564194304 57SET @@session.max_allowed_packet = 1025; 58ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value 59SELECT @@session.max_allowed_packet; 60@@session.max_allowed_packet 614194304 62SET @@session.max_allowed_packet = 65535; 63ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value 64SELECT @@session.max_allowed_packet; 65@@session.max_allowed_packet 664194304 67SET @@session.max_allowed_packet = 1073741824; 68ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value 69SELECT @@session.max_allowed_packet; 70@@session.max_allowed_packet 714194304 72SET @@session.max_allowed_packet = 1073741823; 73ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value 74SELECT @@session.max_allowed_packet; 75@@session.max_allowed_packet 764194304 77'#------------------FN_DYNVARS_070_05-----------------------#' 78SET @@global.max_allowed_packet = 0; 79Warnings: 80Warning 1292 Truncated incorrect max_allowed_packet value: '0' 81Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length' 82SELECT @@global.max_allowed_packet; 83@@global.max_allowed_packet 841024 85SET @@global.max_allowed_packet = -1024; 86Warnings: 87Warning 1292 Truncated incorrect max_allowed_packet value: '-1024' 88Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length' 89SELECT @@global.max_allowed_packet; 90@@global.max_allowed_packet 911024 92SET @@global.max_allowed_packet = 1023; 93Warnings: 94Warning 1292 Truncated incorrect max_allowed_packet value: '1023' 95Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length' 96SELECT @@global.max_allowed_packet; 97@@global.max_allowed_packet 981024 99SET @@global.max_allowed_packet = 10737418241; 100Warnings: 101Warning 1292 Truncated incorrect max_allowed_packet value: '10737418241' 102SELECT @@global.max_allowed_packet; 103@@global.max_allowed_packet 1041073741824 105SET @@global.max_allowed_packet = 1073741826; 106Warnings: 107Warning 1292 Truncated incorrect max_allowed_packet value: '1073741826' 108SELECT @@global.max_allowed_packet; 109@@global.max_allowed_packet 1101073741824 111SET @@global.max_allowed_packet = 65530.34; 112ERROR 42000: Incorrect argument type to variable 'max_allowed_packet' 113SELECT @@global.max_allowed_packet; 114@@global.max_allowed_packet 1151073741824 116SET @@global.max_allowed_packet = test; 117ERROR 42000: Incorrect argument type to variable 'max_allowed_packet' 118SELECT @@global.max_allowed_packet; 119@@global.max_allowed_packet 1201073741824 121SET @@global.max_allowed_packet = ' '; 122ERROR 42000: Incorrect argument type to variable 'max_allowed_packet' 123SELECT @@global.max_allowed_packet; 124@@global.max_allowed_packet 1251073741824 126SET @@session.max_allowed_packet = 0; 127ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value 128SELECT @@session.max_allowed_packet; 129@@session.max_allowed_packet 1304194304 131SET @@session.max_allowed_packet = 1023; 132ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value 133SELECT @@session.max_allowed_packet; 134@@session.max_allowed_packet 1354194304 136SET @@session.max_allowed_packet = -2; 137ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value 138SELECT @@session.max_allowed_packet; 139@@session.max_allowed_packet 1404194304 141SET @@session.max_allowed_packet = 65530.34; 142ERROR 42000: Incorrect argument type to variable 'max_allowed_packet' 143SET @@session.max_allowed_packet = 10737418241; 144ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value 145SELECT @@session.max_allowed_packet; 146@@session.max_allowed_packet 1474194304 148SET @@session.max_allowed_packet = test; 149ERROR 42000: Incorrect argument type to variable 'max_allowed_packet' 150SELECT @@session.max_allowed_packet; 151@@session.max_allowed_packet 1524194304 153SET @@session.max_allowed_packet = ' '; 154ERROR 42000: Incorrect argument type to variable 'max_allowed_packet' 155SELECT @@session.max_allowed_packet; 156@@session.max_allowed_packet 1574194304 158'#------------------FN_DYNVARS_070_06-----------------------#' 159SELECT @@global.max_allowed_packet = VARIABLE_VALUE 160FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 161WHERE VARIABLE_NAME='max_allowed_packet'; 162@@global.max_allowed_packet = VARIABLE_VALUE 1631 164'#------------------FN_DYNVARS_070_07-----------------------#' 165SELECT @@session.max_allowed_packet = VARIABLE_VALUE 166FROM INFORMATION_SCHEMA.SESSION_VARIABLES 167WHERE VARIABLE_NAME='max_allowed_packet'; 168@@session.max_allowed_packet = VARIABLE_VALUE 1691 170'#------------------FN_DYNVARS_070_08-----------------------#' 171SET @@global.max_allowed_packet = TRUE; 172Warnings: 173Warning 1292 Truncated incorrect max_allowed_packet value: '1' 174Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length' 175SELECT @@global.max_allowed_packet; 176@@global.max_allowed_packet 1771024 178SET @@global.max_allowed_packet = FALSE; 179Warnings: 180Warning 1292 Truncated incorrect max_allowed_packet value: '0' 181Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length' 182SELECT @@global.max_allowed_packet; 183@@global.max_allowed_packet 1841024 185'#---------------------FN_DYNVARS_070_09----------------------#' 186SET @@global.max_allowed_packet = 2048; 187Warnings: 188Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length' 189SELECT @@max_allowed_packet = @@global.max_allowed_packet; 190@@max_allowed_packet = @@global.max_allowed_packet 1910 192'#---------------------FN_DYNVARS_070_10----------------------#' 193SET @@max_allowed_packet = 100000; 194ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value 195SELECT @@max_allowed_packet = @@local.max_allowed_packet; 196@@max_allowed_packet = @@local.max_allowed_packet 1971 198SELECT @@local.max_allowed_packet = @@session.max_allowed_packet; 199@@local.max_allowed_packet = @@session.max_allowed_packet 2001 201'#---------------------FN_DYNVARS_070_11----------------------#' 202SET max_allowed_packet = 1024; 203ERROR HY000: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value 204SELECT @@max_allowed_packet; 205@@max_allowed_packet 2064194304 207SELECT local.max_allowed_packet; 208ERROR 42S02: Unknown table 'local' in field list 209SELECT session.max_allowed_packet; 210ERROR 42S02: Unknown table 'session' in field list 211SELECT max_allowed_packet = @@session.max_allowed_packet; 212ERROR 42S22: Unknown column 'max_allowed_packet' in 'field list' 213SET @@global.max_allowed_packet = @start_global_value; 214SELECT @@global.max_allowed_packet; 215@@global.max_allowed_packet 2164194304 217SELECT @@session.max_allowed_packet; 218@@session.max_allowed_packet 2194194304 220