1SET @start_global_value = @@global.min_examined_row_limit; 2SELECT @start_global_value; 3@start_global_value 40 5SET @start_session_value = @@session.min_examined_row_limit; 6SELECT @start_session_value; 7@start_session_value 80 9'#--------------------FN_DYNVARS_089_01-------------------------#' 10SET @@global.min_examined_row_limit = 100; 11SET @@global.min_examined_row_limit = DEFAULT; 12SELECT @@global.min_examined_row_limit; 13@@global.min_examined_row_limit 140 15SET @@session.min_examined_row_limit = 200; 16SET @@session.min_examined_row_limit = DEFAULT; 17SELECT @@session.min_examined_row_limit; 18@@session.min_examined_row_limit 190 20'#--------------------FN_DYNVARS_089_02-------------------------#' 21SET @@global.min_examined_row_limit = DEFAULT; 22SELECT @@global.min_examined_row_limit = 0; 23@@global.min_examined_row_limit = 0 241 25SET @@session.min_examined_row_limit = DEFAULT; 26SELECT @@session.min_examined_row_limit = 0; 27@@session.min_examined_row_limit = 0 281 29'#--------------------FN_DYNVARS_089_03-------------------------#' 30SET @@global.min_examined_row_limit = 0; 31SELECT @@global.min_examined_row_limit; 32@@global.min_examined_row_limit 330 34SET @@global.min_examined_row_limit = 1; 35SELECT @@global.min_examined_row_limit; 36@@global.min_examined_row_limit 371 38SET @@global.min_examined_row_limit = 60020; 39SELECT @@global.min_examined_row_limit; 40@@global.min_examined_row_limit 4160020 42SET @@global.min_examined_row_limit = 65535; 43SELECT @@global.min_examined_row_limit; 44@@global.min_examined_row_limit 4565535 46SET @@global.min_examined_row_limit = 4294967295; 47SELECT @@global.min_examined_row_limit; 48@@global.min_examined_row_limit 494294967295 50SET @@global.min_examined_row_limit = 4294967294; 51SELECT @@global.min_examined_row_limit; 52@@global.min_examined_row_limit 534294967294 54'#--------------------FN_DYNVARS_089_04-------------------------#' 55SET @@session.min_examined_row_limit = 0; 56SELECT @@session.min_examined_row_limit; 57@@session.min_examined_row_limit 580 59SET @@session.min_examined_row_limit = 1; 60SELECT @@session.min_examined_row_limit; 61@@session.min_examined_row_limit 621 63SET @@session.min_examined_row_limit = 50050; 64SELECT @@session.min_examined_row_limit; 65@@session.min_examined_row_limit 6650050 67SET @@session.min_examined_row_limit = 65535; 68SELECT @@session.min_examined_row_limit; 69@@session.min_examined_row_limit 7065535 71SET @@session.min_examined_row_limit = 4294967295; 72SELECT @@session.min_examined_row_limit; 73@@session.min_examined_row_limit 744294967295 75SET @@session.min_examined_row_limit = 4294967294; 76SELECT @@session.min_examined_row_limit; 77@@session.min_examined_row_limit 784294967294 79'#------------------FN_DYNVARS_089_05-----------------------#' 80SET @@global.min_examined_row_limit = 429496726; 81SELECT @@global.min_examined_row_limit; 82@@global.min_examined_row_limit 83429496726 84SET @@global.min_examined_row_limit = -1024; 85Warnings: 86Warning 1292 Truncated incorrect min_examined_row_limit value: '-1024' 87SELECT @@global.min_examined_row_limit; 88@@global.min_examined_row_limit 890 90SET @@global.min_examined_row_limit = 429496729500; 91SELECT @@global.min_examined_row_limit; 92@@global.min_examined_row_limit 93429496729500 94SET @@global.min_examined_row_limit = 65530.34; 95ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit' 96SELECT @@global.min_examined_row_limit; 97@@global.min_examined_row_limit 98429496729500 99SET @@global.min_examined_row_limit = test; 100ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit' 101SELECT @@global.min_examined_row_limit; 102@@global.min_examined_row_limit 103429496729500 104SET @@session.min_examined_row_limit = 4294967296; 105SELECT @@session.min_examined_row_limit; 106@@session.min_examined_row_limit 1074294967296 108SET @@session.min_examined_row_limit = -1; 109Warnings: 110Warning 1292 Truncated incorrect min_examined_row_limit value: '-1' 111SELECT @@session.min_examined_row_limit; 112@@session.min_examined_row_limit 1130 114SET @@session.min_examined_row_limit = 65530.34; 115ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit' 116SET @@session.min_examined_row_limit = 4294967295021; 117SELECT @@session.min_examined_row_limit; 118@@session.min_examined_row_limit 1194294967295021 120SET @@session.min_examined_row_limit = test; 121ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit' 122SELECT @@session.min_examined_row_limit; 123@@session.min_examined_row_limit 1244294967295021 125'#------------------FN_DYNVARS_089_06-----------------------#' 126SELECT @@global.min_examined_row_limit = VARIABLE_VALUE 127FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 128WHERE VARIABLE_NAME='min_examined_row_limit'; 129@@global.min_examined_row_limit = VARIABLE_VALUE 1301 131'#------------------FN_DYNVARS_089_07-----------------------#' 132SELECT @@session.min_examined_row_limit = VARIABLE_VALUE 133FROM INFORMATION_SCHEMA.SESSION_VARIABLES 134WHERE VARIABLE_NAME='min_examined_row_limit'; 135@@session.min_examined_row_limit = VARIABLE_VALUE 1361 137'#------------------FN_DYNVARS_089_08-----------------------#' 138SET @@global.min_examined_row_limit = TRUE; 139SELECT @@global.min_examined_row_limit; 140@@global.min_examined_row_limit 1411 142SET @@global.min_examined_row_limit = FALSE; 143SELECT @@global.min_examined_row_limit; 144@@global.min_examined_row_limit 1450 146'#---------------------FN_DYNVARS_089_09----------------------#' 147SET @@global.min_examined_row_limit = 10; 148SELECT @@min_examined_row_limit = @@global.min_examined_row_limit; 149@@min_examined_row_limit = @@global.min_examined_row_limit 1500 151'#---------------------FN_DYNVARS_089_10----------------------#' 152SET @@min_examined_row_limit = 100; 153SELECT @@min_examined_row_limit = @@local.min_examined_row_limit; 154@@min_examined_row_limit = @@local.min_examined_row_limit 1551 156SELECT @@local.min_examined_row_limit = @@session.min_examined_row_limit; 157@@local.min_examined_row_limit = @@session.min_examined_row_limit 1581 159'#---------------------FN_DYNVARS_089_11----------------------#' 160SET min_examined_row_limit = 1; 161SELECT @@min_examined_row_limit; 162@@min_examined_row_limit 1631 164SELECT local.min_examined_row_limit; 165ERROR 42S02: Unknown table 'local' in field list 166SELECT session.min_examined_row_limit; 167ERROR 42S02: Unknown table 'session' in field list 168SELECT min_examined_row_limit = @@session.min_examined_row_limit; 169ERROR 42S22: Unknown column 'min_examined_row_limit' in 'field list' 170SET @@global.min_examined_row_limit = @start_global_value; 171SELECT @@global.min_examined_row_limit; 172@@global.min_examined_row_limit 1730 174SET @@session.min_examined_row_limit = @start_session_value; 175SELECT @@session.min_examined_row_limit; 176@@session.min_examined_row_limit 1770 178