1SET @start_value = @@global.slave_max_allowed_packet; 2SELECT @start_value; 3@start_value 41073741824 5'#--------------------FN_DYNVARS_072_01------------------------#' 6SET @@global.slave_max_allowed_packet = 5000; 7Warnings: 8Warning 1292 Truncated incorrect slave_max_allowed_packet value: '5000' 9SET @@global.slave_max_allowed_packet = DEFAULT; 10SELECT @@global.slave_max_allowed_packet; 11@@global.slave_max_allowed_packet 121073741824 13'#---------------------FN_DYNVARS_072_02-------------------------#' 14SET @@global.slave_max_allowed_packet = @start_value; 15SELECT @@global.slave_max_allowed_packet = 1073741824; 16@@global.slave_max_allowed_packet = 1073741824 171 18'Bug# 34876: Incorrect Default Value is assigned to variable'; 19'#--------------------FN_DYNVARS_072_03------------------------#' 20SET @@global.slave_max_allowed_packet = 1024; 21SELECT @@global.slave_max_allowed_packet; 22@@global.slave_max_allowed_packet 231024 24SET @@global.slave_max_allowed_packet = 1073741824; 25SELECT @@global.slave_max_allowed_packet; 26@@global.slave_max_allowed_packet 271073741824 28SET @@global.slave_max_allowed_packet = 1073741824; 29SELECT @@global.slave_max_allowed_packet; 30@@global.slave_max_allowed_packet 311073741824 32SET @@global.slave_max_allowed_packet = 1025; 33Warnings: 34Warning 1292 Truncated incorrect slave_max_allowed_packet value: '1025' 35SELECT @@global.slave_max_allowed_packet; 36@@global.slave_max_allowed_packet 371024 38SET @@global.slave_max_allowed_packet = 65535; 39Warnings: 40Warning 1292 Truncated incorrect slave_max_allowed_packet value: '65535' 41SELECT @@global.slave_max_allowed_packet; 42@@global.slave_max_allowed_packet 4364512 44'Bug# 34877: Invalid Values are coming in variable on assigning valid values'; 45'#--------------------FN_DYNVARS_072_04-------------------------#' 46SET @@global.slave_max_allowed_packet = -1; 47Warnings: 48Warning 1292 Truncated incorrect slave_max_allowed_packet value: '-1' 49SELECT @@global.slave_max_allowed_packet; 50@@global.slave_max_allowed_packet 511024 52SET @@global.slave_max_allowed_packet = 100000000000; 53Warnings: 54Warning 1292 Truncated incorrect slave_max_allowed_packet value: '100000000000' 55SELECT @@global.slave_max_allowed_packet; 56@@global.slave_max_allowed_packet 571073741824 58SET @@global.slave_max_allowed_packet = 10000.01; 59ERROR 42000: Incorrect argument type to variable 'slave_max_allowed_packet' 60SELECT @@global.slave_max_allowed_packet; 61@@global.slave_max_allowed_packet 621073741824 63SET @@global.slave_max_allowed_packet = -1024; 64Warnings: 65Warning 1292 Truncated incorrect slave_max_allowed_packet value: '-1024' 66SELECT @@global.slave_max_allowed_packet; 67@@global.slave_max_allowed_packet 681024 69SET @@global.slave_max_allowed_packet = 4294967296; 70Warnings: 71Warning 1292 Truncated incorrect slave_max_allowed_packet value: '4294967296' 72SELECT @@global.slave_max_allowed_packet; 73@@global.slave_max_allowed_packet 741073741824 75SET @@global.slave_max_allowed_packet = 1023; 76Warnings: 77Warning 1292 Truncated incorrect slave_max_allowed_packet value: '1023' 78SELECT @@global.slave_max_allowed_packet; 79@@global.slave_max_allowed_packet 801024 81'Bug # 34837: Errors are not coming on assigning invalid values to variable'; 82SET @@global.slave_max_allowed_packet = ON; 83ERROR 42000: Incorrect argument type to variable 'slave_max_allowed_packet' 84SELECT @@global.slave_max_allowed_packet; 85@@global.slave_max_allowed_packet 861024 87SET @@global.slave_max_allowed_packet = 'test'; 88ERROR 42000: Incorrect argument type to variable 'slave_max_allowed_packet' 89SELECT @@global.slave_max_allowed_packet; 90@@global.slave_max_allowed_packet 911024 92'#-------------------FN_DYNVARS_072_05----------------------------#' 93SET @@session.slave_max_allowed_packet = 4096; 94ERROR HY000: Variable 'slave_max_allowed_packet' is a GLOBAL variable and should be set with SET GLOBAL 95SELECT @@session.slave_max_allowed_packet; 96ERROR HY000: Variable 'slave_max_allowed_packet' is a GLOBAL variable 97'#----------------------FN_DYNVARS_072_06------------------------#' 98SELECT @@global.slave_max_allowed_packet = VARIABLE_VALUE 99FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 100WHERE VARIABLE_NAME='slave_max_allowed_packet'; 101@@global.slave_max_allowed_packet = VARIABLE_VALUE 1021 103SELECT @@slave_max_allowed_packet = VARIABLE_VALUE 104FROM INFORMATION_SCHEMA.SESSION_VARIABLES 105WHERE VARIABLE_NAME='slave_max_allowed_packet'; 106@@slave_max_allowed_packet = VARIABLE_VALUE 1071 108'#---------------------FN_DYNVARS_072_07----------------------#' 109SET @@global.slave_max_allowed_packet = TRUE; 110Warnings: 111Warning 1292 Truncated incorrect slave_max_allowed_packet value: '1' 112SELECT @@global.slave_max_allowed_packet; 113@@global.slave_max_allowed_packet 1141024 115SET @@global.slave_max_allowed_packet = FALSE; 116Warnings: 117Warning 1292 Truncated incorrect slave_max_allowed_packet value: '0' 118SELECT @@global.slave_max_allowed_packet; 119@@global.slave_max_allowed_packet 1201024 121'#---------------------FN_DYNVARS_072_08----------------------#' 122SET @@global.slave_max_allowed_packet = 5000; 123Warnings: 124Warning 1292 Truncated incorrect slave_max_allowed_packet value: '5000' 125SELECT @@slave_max_allowed_packet = @@global.slave_max_allowed_packet; 126@@slave_max_allowed_packet = @@global.slave_max_allowed_packet 1271 128'#---------------------FN_DYNVARS_072_09----------------------#' 129SET slave_max_allowed_packet = 6000; 130ERROR HY000: Variable 'slave_max_allowed_packet' is a GLOBAL variable and should be set with SET GLOBAL 131SELECT @@slave_max_allowed_packet; 132@@slave_max_allowed_packet 1334096 134SELECT local.slave_max_allowed_packet; 135ERROR 42S02: Unknown table 'local' in field list 136SELECT global.slave_max_allowed_packet; 137ERROR 42S02: Unknown table 'global' in field list 138SELECT slave_max_allowed_packet = @@session.slave_max_allowed_packet; 139ERROR 42S22: Unknown column 'slave_max_allowed_packet' in 'field list' 140SET @@global.slave_max_allowed_packet = @start_value; 141SELECT @@global.slave_max_allowed_packet; 142@@global.slave_max_allowed_packet 1431073741824 144