1SET @start_global_value = @@global.net_buffer_length; 2SET @@global.net_buffer_length = DEFAULT; 3'#--------------------FN_DYNVARS_109_01-------------------------#' 4SET @@global.net_buffer_length = 10000; 5Warnings: 6Warning 1292 Truncated incorrect net_buffer_length value: '10000' 7SET @@global.net_buffer_length = DEFAULT; 8SELECT @@global.net_buffer_length; 9@@global.net_buffer_length 1016384 11SET @@session.net_buffer_length = 20000; 12ERROR HY000: SESSION variable 'net_buffer_length' is read-only. Use SET GLOBAL to assign the value 13SET @@session.net_buffer_length = DEFAULT; 14ERROR HY000: SESSION variable 'net_buffer_length' is read-only. Use SET GLOBAL to assign the value 15SELECT @@session.net_buffer_length; 16@@session.net_buffer_length 1716384 18'#--------------------FN_DYNVARS_109_02-------------------------#' 19SET @@global.net_buffer_length = DEFAULT; 20SELECT @@global.net_buffer_length = 16384; 21@@global.net_buffer_length = 16384 221 23'#--------------------FN_DYNVARS_109_03-------------------------#' 24SET @@global.net_buffer_length = 1024; 25SELECT @@global.net_buffer_length; 26@@global.net_buffer_length 271024 28SET @@global.net_buffer_length = 1025; 29Warnings: 30Warning 1292 Truncated incorrect net_buffer_length value: '1025' 31SELECT @@global.net_buffer_length; 32@@global.net_buffer_length 331024 34SET @@global.net_buffer_length = 1048576; 35SELECT @@global.net_buffer_length; 36@@global.net_buffer_length 371048576 38SET @@global.net_buffer_length = 1048575; 39Warnings: 40Warning 1292 Truncated incorrect net_buffer_length value: '1048575' 41SELECT @@global.net_buffer_length; 42@@global.net_buffer_length 431047552 44SET @@global.net_buffer_length = 65535; 45Warnings: 46Warning 1292 Truncated incorrect net_buffer_length value: '65535' 47SELECT @@global.net_buffer_length; 48@@global.net_buffer_length 4964512 50'#--------------------FN_DYNVARS_109_04-------------------------#' 51'#------------------FN_DYNVARS_109_05-----------------------#' 52SET @@global.net_buffer_length = 0; 53Warnings: 54Warning 1292 Truncated incorrect net_buffer_length value: '0' 55SELECT @@global.net_buffer_length; 56@@global.net_buffer_length 571024 58SET @@global.net_buffer_length = -1024; 59Warnings: 60Warning 1292 Truncated incorrect net_buffer_length value: '-1024' 61SELECT @@global.net_buffer_length; 62@@global.net_buffer_length 631024 64SET @@global.net_buffer_length = 1023; 65Warnings: 66Warning 1292 Truncated incorrect net_buffer_length value: '1023' 67SELECT @@global.net_buffer_length; 68@@global.net_buffer_length 691024 70SET @@global.net_buffer_length = 1048577; 71Warnings: 72Warning 1292 Truncated incorrect net_buffer_length value: '1048577' 73SELECT @@global.net_buffer_length; 74@@global.net_buffer_length 751048576 76SET @@global.net_buffer_length = 104857633; 77Warnings: 78Warning 1292 Truncated incorrect net_buffer_length value: '104857633' 79SELECT @@global.net_buffer_length; 80@@global.net_buffer_length 811048576 82SET @@global.net_buffer_length = 65530.34; 83ERROR 42000: Incorrect argument type to variable 'net_buffer_length' 84SELECT @@global.net_buffer_length; 85@@global.net_buffer_length 861048576 87SET @@global.net_buffer_length = test; 88ERROR 42000: Incorrect argument type to variable 'net_buffer_length' 89SELECT @@global.net_buffer_length; 90@@global.net_buffer_length 911048576 92SET @@global.net_buffer_length = ' '; 93ERROR 42000: Incorrect argument type to variable 'net_buffer_length' 94SELECT @@global.net_buffer_length; 95@@global.net_buffer_length 961048576 97SET @@session.net_buffer_length = test; 98ERROR 42000: Incorrect argument type to variable 'net_buffer_length' 99SELECT @@session.net_buffer_length; 100@@session.net_buffer_length 10116384 102'#------------------FN_DYNVARS_109_06-----------------------#' 103SELECT @@global.net_buffer_length = VARIABLE_VALUE 104FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 105WHERE VARIABLE_NAME='net_buffer_length'; 106@@global.net_buffer_length = VARIABLE_VALUE 1071 108'#------------------FN_DYNVARS_109_07-----------------------#' 109SELECT @@session.net_buffer_length = VARIABLE_VALUE 110FROM INFORMATION_SCHEMA.SESSION_VARIABLES 111WHERE VARIABLE_NAME='net_buffer_length'; 112@@session.net_buffer_length = VARIABLE_VALUE 1131 114'#------------------FN_DYNVARS_109_08-----------------------#' 115SET @@global.net_buffer_length = TRUE; 116Warnings: 117Warning 1292 Truncated incorrect net_buffer_length value: '1' 118SELECT @@global.net_buffer_length; 119@@global.net_buffer_length 1201024 121SET @@global.net_buffer_length = FALSE; 122Warnings: 123Warning 1292 Truncated incorrect net_buffer_length value: '0' 124SELECT @@global.net_buffer_length; 125@@global.net_buffer_length 1261024 127'#---------------------FN_DYNVARS_109_09----------------------#' 128SET @@global.net_buffer_length = 2048; 129SELECT @@net_buffer_length = @@global.net_buffer_length; 130@@net_buffer_length = @@global.net_buffer_length 1310 132'#---------------------FN_DYNVARS_109_10----------------------#' 133'#---------------------FN_DYNVARS_109_11----------------------#' 134SELECT @@net_buffer_length; 135@@net_buffer_length 13616384 137SELECT local.net_buffer_length; 138ERROR 42S02: Unknown table 'local' in field list 139SELECT session.net_buffer_length; 140ERROR 42S02: Unknown table 'session' in field list 141SELECT net_buffer_length = @@session.net_buffer_length; 142ERROR 42S22: Unknown column 'net_buffer_length' in 'field list' 143SET @@global.net_buffer_length = @start_global_value; 144