1SET @start_global_value = @@global.read_rnd_buffer_size; 2SELECT @start_global_value; 3@start_global_value 4262144 5SET @start_session_value = @@session.read_rnd_buffer_size; 6SELECT @start_session_value; 7@start_session_value 8262144 9'#--------------------FN_DYNVARS_140_01-------------------------#' 10SET @@global.read_rnd_buffer_size = 1000; 11SET @@global.read_rnd_buffer_size = DEFAULT; 12SELECT @@global.read_rnd_buffer_size; 13@@global.read_rnd_buffer_size 14262144 15SET @@session.read_rnd_buffer_size = 2000; 16SET @@session.read_rnd_buffer_size = DEFAULT; 17SELECT @@session.read_rnd_buffer_size; 18@@session.read_rnd_buffer_size 19262144 20'#--------------------FN_DYNVARS_140_03-------------------------#' 21SET @@global.read_rnd_buffer_size = 8201; 22SELECT @@global.read_rnd_buffer_size; 23@@global.read_rnd_buffer_size 248201 25SET @@global.read_rnd_buffer_size = 8200; 26SELECT @@global.read_rnd_buffer_size; 27@@global.read_rnd_buffer_size 288200 29SET @@global.read_rnd_buffer_size = 2147479552; 30SELECT @@global.read_rnd_buffer_size; 31@@global.read_rnd_buffer_size 322147479552 33SET @@global.read_rnd_buffer_size = 2147479551; 34SELECT @@global.read_rnd_buffer_size; 35@@global.read_rnd_buffer_size 362147479551 37'#--------------------FN_DYNVARS_140_04-------------------------#' 38SET @@session.read_rnd_buffer_size = 8200; 39SELECT @@session.read_rnd_buffer_size; 40@@session.read_rnd_buffer_size 418200 42SET @@session.read_rnd_buffer_size = 8201; 43SELECT @@session.read_rnd_buffer_size; 44@@session.read_rnd_buffer_size 458201 46SET @@session.read_rnd_buffer_size = 2147479552; 47SELECT @@session.read_rnd_buffer_size; 48@@session.read_rnd_buffer_size 492147479552 50SET @@session.read_rnd_buffer_size = 2147479551; 51SELECT @@session.read_rnd_buffer_size; 52@@session.read_rnd_buffer_size 532147479551 54'#------------------FN_DYNVARS_140_05-----------------------#' 55SET @@global.read_rnd_buffer_size = 8199; 56SELECT @@global.read_rnd_buffer_size; 57@@global.read_rnd_buffer_size 588199 59SET @@global.read_rnd_buffer_size = -1024; 60Warnings: 61Warning 1292 Truncated incorrect read_rnd_buffer_size value: '-1024' 62SELECT @@global.read_rnd_buffer_size; 63@@global.read_rnd_buffer_size 641 65SET @@global.read_rnd_buffer_size = 2147479553; 66SELECT @@global.read_rnd_buffer_size; 67@@global.read_rnd_buffer_size 682147479553 69SET @@global.read_rnd_buffer_size = 65530.34; 70ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size' 71SET @@global.read_rnd_buffer_size = test; 72ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size' 73SET @@session.read_rnd_buffer_size = 8199; 74SELECT @@session.read_rnd_buffer_size; 75@@session.read_rnd_buffer_size 768199 77SET @@session.read_rnd_buffer_size = -2; 78Warnings: 79Warning 1292 Truncated incorrect read_rnd_buffer_size value: '-2' 80SELECT @@session.read_rnd_buffer_size; 81@@session.read_rnd_buffer_size 821 83SET @@session.read_rnd_buffer_size = 65530.34; 84ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size' 85SET @@session.read_rnd_buffer_size = test; 86ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size' 87'#------------------FN_DYNVARS_140_06-----------------------#' 88SELECT @@global.read_rnd_buffer_size = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='read_rnd_buffer_size'; 89@@global.read_rnd_buffer_size = VARIABLE_VALUE 901 91'#------------------FN_DYNVARS_140_07-----------------------#' 92SELECT @@session.read_rnd_buffer_size = 93VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='read_rnd_buffer_size'; 94@@session.read_rnd_buffer_size = 95VARIABLE_VALUE 961 97'#------------------FN_DYNVARS_140_08-----------------------#' 98SET @@global.read_rnd_buffer_size = TRUE; 99SELECT @@global.read_rnd_buffer_size; 100@@global.read_rnd_buffer_size 1011 102SET @@global.read_rnd_buffer_size = FALSE; 103Warnings: 104Warning 1292 Truncated incorrect read_rnd_buffer_size value: '0' 105SELECT @@global.read_rnd_buffer_size; 106@@global.read_rnd_buffer_size 1071 108'#---------------------FN_DYNVARS_140_09----------------------#' 109SET @@global.read_rnd_buffer_size = 9000; 110SELECT @@read_rnd_buffer_size = @@global.read_rnd_buffer_size; 111@@read_rnd_buffer_size = @@global.read_rnd_buffer_size 1120 113'#---------------------FN_DYNVARS_140_10----------------------#' 114SET @@read_rnd_buffer_size = 9000; 115SELECT @@read_rnd_buffer_size = @@local.read_rnd_buffer_size; 116@@read_rnd_buffer_size = @@local.read_rnd_buffer_size 1171 118SELECT @@local.read_rnd_buffer_size = @@session.read_rnd_buffer_size; 119@@local.read_rnd_buffer_size = @@session.read_rnd_buffer_size 1201 121'#---------------------FN_DYNVARS_140_11----------------------#' 122SET read_rnd_buffer_size = 9100; 123SELECT @@read_rnd_buffer_size; 124@@read_rnd_buffer_size 1259100 126SELECT local.read_rnd_buffer_size; 127ERROR 42S02: Unknown table 'local' in field list 128SELECT session.read_rnd_buffer_size; 129ERROR 42S02: Unknown table 'session' in field list 130SELECT read_rnd_buffer_size = @@session.read_rnd_buffer_size; 131ERROR 42S22: Unknown column 'read_rnd_buffer_size' in 'field list' 132SET @@global.read_rnd_buffer_size = @start_global_value; 133SELECT @@global.read_rnd_buffer_size; 134@@global.read_rnd_buffer_size 135262144 136SET @@session.read_rnd_buffer_size = @start_session_value; 137SELECT @@session.read_rnd_buffer_size; 138@@session.read_rnd_buffer_size 139262144 140