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; 91Warnings: 92Warning 1292 Truncated incorrect min_examined_row_limit value: '429496729500' 93SELECT @@global.min_examined_row_limit; 94@@global.min_examined_row_limit 954294967295 96SET @@global.min_examined_row_limit = 65530.34; 97ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit' 98SELECT @@global.min_examined_row_limit; 99@@global.min_examined_row_limit 1004294967295 101SET @@global.min_examined_row_limit = test; 102ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit' 103SELECT @@global.min_examined_row_limit; 104@@global.min_examined_row_limit 1054294967295 106SET @@session.min_examined_row_limit = 4294967296; 107Warnings: 108Warning 1292 Truncated incorrect min_examined_row_limit value: '4294967296' 109SELECT @@session.min_examined_row_limit; 110@@session.min_examined_row_limit 1114294967295 112SET @@session.min_examined_row_limit = -1; 113Warnings: 114Warning 1292 Truncated incorrect min_examined_row_limit value: '-1' 115SELECT @@session.min_examined_row_limit; 116@@session.min_examined_row_limit 1170 118SET @@session.min_examined_row_limit = 65530.34; 119ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit' 120SET @@session.min_examined_row_limit = 4294967295021; 121Warnings: 122Warning 1292 Truncated incorrect min_examined_row_limit value: '4294967295021' 123SELECT @@session.min_examined_row_limit; 124@@session.min_examined_row_limit 1254294967295 126SET @@session.min_examined_row_limit = test; 127ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit' 128SELECT @@session.min_examined_row_limit; 129@@session.min_examined_row_limit 1304294967295 131'#------------------FN_DYNVARS_089_06-----------------------#' 132SELECT @@global.min_examined_row_limit = VARIABLE_VALUE 133FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 134WHERE VARIABLE_NAME='min_examined_row_limit'; 135@@global.min_examined_row_limit = VARIABLE_VALUE 1361 137'#------------------FN_DYNVARS_089_07-----------------------#' 138SELECT @@session.min_examined_row_limit = VARIABLE_VALUE 139FROM INFORMATION_SCHEMA.SESSION_VARIABLES 140WHERE VARIABLE_NAME='min_examined_row_limit'; 141@@session.min_examined_row_limit = VARIABLE_VALUE 1421 143'#------------------FN_DYNVARS_089_08-----------------------#' 144SET @@global.min_examined_row_limit = TRUE; 145SELECT @@global.min_examined_row_limit; 146@@global.min_examined_row_limit 1471 148SET @@global.min_examined_row_limit = FALSE; 149SELECT @@global.min_examined_row_limit; 150@@global.min_examined_row_limit 1510 152'#---------------------FN_DYNVARS_089_09----------------------#' 153SET @@global.min_examined_row_limit = 10; 154SELECT @@min_examined_row_limit = @@global.min_examined_row_limit; 155@@min_examined_row_limit = @@global.min_examined_row_limit 1560 157'#---------------------FN_DYNVARS_089_10----------------------#' 158SET @@min_examined_row_limit = 100; 159SELECT @@min_examined_row_limit = @@local.min_examined_row_limit; 160@@min_examined_row_limit = @@local.min_examined_row_limit 1611 162SELECT @@local.min_examined_row_limit = @@session.min_examined_row_limit; 163@@local.min_examined_row_limit = @@session.min_examined_row_limit 1641 165'#---------------------FN_DYNVARS_089_11----------------------#' 166SET min_examined_row_limit = 1; 167SELECT @@min_examined_row_limit; 168@@min_examined_row_limit 1691 170SELECT local.min_examined_row_limit; 171ERROR 42S02: Unknown table 'local' in field list 172SELECT session.min_examined_row_limit; 173ERROR 42S02: Unknown table 'session' in field list 174SELECT min_examined_row_limit = @@session.min_examined_row_limit; 175ERROR 42S22: Unknown column 'min_examined_row_limit' in 'field list' 176SET @@global.min_examined_row_limit = @start_global_value; 177SELECT @@global.min_examined_row_limit; 178@@global.min_examined_row_limit 1790 180SET @@session.min_examined_row_limit = @start_session_value; 181SELECT @@session.min_examined_row_limit; 182@@session.min_examined_row_limit 1830 184