1SET @start_global_value = @@global.histogram_size; 2SET @start_session_value = @@session.histogram_size; 3SELECT @start_global_value = @start_session_value; 4@start_global_value = @start_session_value 51 6'#--------------------FN_DYNVARS_053_01-------------------------#' 7SET @@global.histogram_size = DEFAULT; 8SELECT @@global.histogram_size; 9@@global.histogram_size 10254 11SET @@session.histogram_size = DEFAULT; 12SELECT @@session.histogram_size; 13@@session.histogram_size 14254 15'#--------------------FN_DYNVARS_053_03-------------------------#' 16SET @@global.histogram_size = 1; 17SELECT @@global.histogram_size; 18@@global.histogram_size 191 20SET @@global.histogram_size = 31; 21SELECT @@global.histogram_size; 22@@global.histogram_size 2331 24SET @@global.histogram_size = 255; 25SELECT @@global.histogram_size; 26@@global.histogram_size 27255 28'#--------------------FN_DYNVARS_053_04-------------------------#' 29SET @@session.histogram_size = 1; 30SELECT @@session.histogram_size; 31@@session.histogram_size 321 33SET @@session.histogram_size = 31; 34SELECT @@session.histogram_size; 35@@session.histogram_size 3631 37SET @@session.histogram_size = 255; 38SELECT @@session.histogram_size; 39@@session.histogram_size 40255 41'#------------------FN_DYNVARS_053_05-----------------------#' 42SET @@global.histogram_size = -1; 43Warnings: 44Warning 1292 Truncated incorrect histogram_size value: '-1' 45SELECT @@global.histogram_size; 46@@global.histogram_size 470 48SET @@global.histogram_size = 256; 49Warnings: 50Warning 1292 Truncated incorrect histogram_size value: '256' 51SELECT @@global.histogram_size; 52@@global.histogram_size 53255 54SET @@global.histogram_size = 1024; 55Warnings: 56Warning 1292 Truncated incorrect histogram_size value: '1024' 57SELECT @@global.histogram_size; 58@@global.histogram_size 59255 60SET @@global.histogram_size = 4.5; 61ERROR 42000: Incorrect argument type to variable 'histogram_size' 62SELECT @@global.histogram_size; 63@@global.histogram_size 64255 65SET @@global.histogram_size = test; 66ERROR 42000: Incorrect argument type to variable 'histogram_size' 67SELECT @@global.histogram_size; 68@@global.histogram_size 69255 70SET @@session.histogram_size = -1; 71Warnings: 72Warning 1292 Truncated incorrect histogram_size value: '-1' 73SELECT @@session.histogram_size; 74@@session.histogram_size 750 76SET @@session.histogram_size = 256; 77Warnings: 78Warning 1292 Truncated incorrect histogram_size value: '256' 79SELECT @@session.histogram_size; 80@@session.histogram_size 81255 82SET @@session.histogram_size = 1024; 83Warnings: 84Warning 1292 Truncated incorrect histogram_size value: '1024' 85SELECT @@session.histogram_size; 86@@session.histogram_size 87255 88SET @@session.histogram_size = 4.5; 89ERROR 42000: Incorrect argument type to variable 'histogram_size' 90SELECT @@session.histogram_size; 91@@session.histogram_size 92255 93SET @@session.histogram_size = test; 94ERROR 42000: Incorrect argument type to variable 'histogram_size' 95SELECT @@session.histogram_size; 96@@session.histogram_size 97255 98'#------------------FN_DYNVARS_053_06-----------------------#' 99SELECT @@global.histogram_size = VARIABLE_VALUE 100FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 101WHERE VARIABLE_NAME='histogram_size'; 102@@global.histogram_size = VARIABLE_VALUE 1031 104'#------------------FN_DYNVARS_053_07-----------------------#' 105SELECT @@session.histogram_size = VARIABLE_VALUE 106FROM INFORMATION_SCHEMA.SESSION_VARIABLES 107WHERE VARIABLE_NAME='histogram_size'; 108@@session.histogram_size = VARIABLE_VALUE 1091 110'#------------------FN_DYNVARS_053_08-----------------------#' 111SET @@global.histogram_size = TRUE; 112SET @@global.histogram_size = FALSE; 113'#---------------------FN_DYNVARS_001_09----------------------#' 114SET @@global.histogram_size = 10; 115SELECT @@histogram_size = @@global.histogram_size; 116@@histogram_size = @@global.histogram_size 1170 118'#---------------------FN_DYNVARS_001_10----------------------#' 119SET @@histogram_size = 100; 120SELECT @@histogram_size = @@local.histogram_size; 121@@histogram_size = @@local.histogram_size 1221 123SELECT @@local.histogram_size = @@session.histogram_size; 124@@local.histogram_size = @@session.histogram_size 1251 126SET @@global.histogram_size = @start_global_value; 127SET @@session.histogram_size = @start_session_value; 128