1SET @start_global_value = @@global.max_sp_recursion_depth; 2SELECT @start_global_value; 3@start_global_value 40 5SET @start_session_value = @@session.max_sp_recursion_depth; 6SELECT @start_session_value; 7@start_session_value 80 9'#--------------------FN_DYNVARS_085_01-------------------------#' 10SET @@global.max_sp_recursion_depth = 1000; 11Warnings: 12Warning 1292 Truncated incorrect max_sp_recursion_depth value: '1000' 13SET @@global.max_sp_recursion_depth = DEFAULT; 14SELECT @@global.max_sp_recursion_depth; 15@@global.max_sp_recursion_depth 160 17SET @@session.max_sp_recursion_depth = 1000; 18Warnings: 19Warning 1292 Truncated incorrect max_sp_recursion_depth value: '1000' 20SET @@session.max_sp_recursion_depth = DEFAULT; 21SELECT @@session.max_sp_recursion_depth; 22@@session.max_sp_recursion_depth 230 24'#--------------------FN_DYNVARS_085_02-------------------------#' 25SET @@global.max_sp_recursion_depth = DEFAULT; 26SELECT @@global.max_sp_recursion_depth = 0; 27@@global.max_sp_recursion_depth = 0 281 29SET @@session.max_sp_recursion_depth = DEFAULT; 30SELECT @@session.max_sp_recursion_depth = 0; 31@@session.max_sp_recursion_depth = 0 321 33'#--------------------FN_DYNVARS_085_03-------------------------#' 34SET @@global.max_sp_recursion_depth = 0; 35SELECT @@global.max_sp_recursion_depth; 36@@global.max_sp_recursion_depth 370 38SET @@global.max_sp_recursion_depth = 1; 39SELECT @@global.max_sp_recursion_depth; 40@@global.max_sp_recursion_depth 411 42SET @@global.max_sp_recursion_depth = 254; 43SELECT @@global.max_sp_recursion_depth; 44@@global.max_sp_recursion_depth 45254 46SET @@global.max_sp_recursion_depth = 255; 47SELECT @@global.max_sp_recursion_depth; 48@@global.max_sp_recursion_depth 49255 50SET @@global.max_sp_recursion_depth = 150; 51SELECT @@global.max_sp_recursion_depth; 52@@global.max_sp_recursion_depth 53150 54'#--------------------FN_DYNVARS_085_04-------------------------#' 55SET @@session.max_sp_recursion_depth = 0; 56SELECT @@session.max_sp_recursion_depth; 57@@session.max_sp_recursion_depth 580 59SET @@session.max_sp_recursion_depth = 1; 60SELECT @@session.max_sp_recursion_depth; 61@@session.max_sp_recursion_depth 621 63SET @@session.max_sp_recursion_depth = 254; 64SELECT @@session.max_sp_recursion_depth; 65@@session.max_sp_recursion_depth 66254 67SET @@session.max_sp_recursion_depth = 255; 68SELECT @@session.max_sp_recursion_depth; 69@@session.max_sp_recursion_depth 70255 71SET @@session.max_sp_recursion_depth = 150; 72SELECT @@session.max_sp_recursion_depth; 73@@session.max_sp_recursion_depth 74150 75'#------------------FN_DYNVARS_085_05-----------------------#' 76SET @@global.max_sp_recursion_depth = -1024; 77Warnings: 78Warning 1292 Truncated incorrect max_sp_recursion_depth value: '-1024' 79SELECT @@global.max_sp_recursion_depth; 80@@global.max_sp_recursion_depth 810 82SET @@global.max_sp_recursion_depth = 256; 83Warnings: 84Warning 1292 Truncated incorrect max_sp_recursion_depth value: '256' 85SELECT @@global.max_sp_recursion_depth; 86@@global.max_sp_recursion_depth 87255 88SET @@global.max_sp_recursion_depth = -1; 89Warnings: 90Warning 1292 Truncated incorrect max_sp_recursion_depth value: '-1' 91SELECT @@global.max_sp_recursion_depth; 92@@global.max_sp_recursion_depth 930 94SET @@global.max_sp_recursion_depth = 3000; 95Warnings: 96Warning 1292 Truncated incorrect max_sp_recursion_depth value: '3000' 97SELECT @@global.max_sp_recursion_depth; 98@@global.max_sp_recursion_depth 99255 100SET @@global.max_sp_recursion_depth = 65530.34; 101ERROR 42000: Incorrect argument type to variable 'max_sp_recursion_depth' 102SELECT @@global.max_sp_recursion_depth; 103@@global.max_sp_recursion_depth 104255 105SET @@global.max_sp_recursion_depth = test; 106ERROR 42000: Incorrect argument type to variable 'max_sp_recursion_depth' 107SELECT @@global.max_sp_recursion_depth; 108@@global.max_sp_recursion_depth 109255 110SET @@session.max_sp_recursion_depth = 256; 111Warnings: 112Warning 1292 Truncated incorrect max_sp_recursion_depth value: '256' 113SELECT @@session.max_sp_recursion_depth; 114@@session.max_sp_recursion_depth 115255 116SET @@session.max_sp_recursion_depth = -1; 117Warnings: 118Warning 1292 Truncated incorrect max_sp_recursion_depth value: '-1' 119SELECT @@session.max_sp_recursion_depth; 120@@session.max_sp_recursion_depth 1210 122SET @@session.max_sp_recursion_depth = 500000; 123Warnings: 124Warning 1292 Truncated incorrect max_sp_recursion_depth value: '500000' 125SELECT @@session.max_sp_recursion_depth; 126@@session.max_sp_recursion_depth 127255 128SET @@session.max_sp_recursion_depth = -001; 129Warnings: 130Warning 1292 Truncated incorrect max_sp_recursion_depth value: '-1' 131SELECT @@session.max_sp_recursion_depth; 132@@session.max_sp_recursion_depth 1330 134SET @@session.max_sp_recursion_depth = 65530.34; 135ERROR 42000: Incorrect argument type to variable 'max_sp_recursion_depth' 136SET @@session.max_sp_recursion_depth = 10737418241; 137Warnings: 138Warning 1292 Truncated incorrect max_sp_recursion_depth value: '10737418241' 139SELECT @@session.max_sp_recursion_depth; 140@@session.max_sp_recursion_depth 141255 142SET @@session.max_sp_recursion_depth = test; 143ERROR 42000: Incorrect argument type to variable 'max_sp_recursion_depth' 144SELECT @@session.max_sp_recursion_depth; 145@@session.max_sp_recursion_depth 146255 147'#------------------FN_DYNVARS_085_06-----------------------#' 148SELECT @@global.max_sp_recursion_depth = VARIABLE_VALUE 149FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 150WHERE VARIABLE_NAME='max_sp_recursion_depth'; 151@@global.max_sp_recursion_depth = VARIABLE_VALUE 1521 153'#------------------FN_DYNVARS_085_07-----------------------#' 154SELECT @@session.max_sp_recursion_depth = VARIABLE_VALUE 155FROM INFORMATION_SCHEMA.SESSION_VARIABLES 156WHERE VARIABLE_NAME='max_sp_recursion_depth'; 157@@session.max_sp_recursion_depth = VARIABLE_VALUE 1581 159'#------------------FN_DYNVARS_085_08-----------------------#' 160SET @@global.max_sp_recursion_depth = TRUE; 161SELECT @@global.max_sp_recursion_depth; 162@@global.max_sp_recursion_depth 1631 164SET @@global.max_sp_recursion_depth = FALSE; 165SELECT @@global.max_sp_recursion_depth; 166@@global.max_sp_recursion_depth 1670 168'#---------------------FN_DYNVARS_085_09----------------------#' 169SET @@global.max_sp_recursion_depth = 20; 170SELECT @@max_sp_recursion_depth = @@global.max_sp_recursion_depth; 171@@max_sp_recursion_depth = @@global.max_sp_recursion_depth 1720 173'#---------------------FN_DYNVARS_085_10----------------------#' 174SET @@max_sp_recursion_depth = 255; 175SELECT @@max_sp_recursion_depth = @@local.max_sp_recursion_depth; 176@@max_sp_recursion_depth = @@local.max_sp_recursion_depth 1771 178SELECT @@local.max_sp_recursion_depth = @@session.max_sp_recursion_depth; 179@@local.max_sp_recursion_depth = @@session.max_sp_recursion_depth 1801 181'#---------------------FN_DYNVARS_085_11----------------------#' 182SET max_sp_recursion_depth = 102; 183SELECT @@max_sp_recursion_depth; 184@@max_sp_recursion_depth 185102 186SELECT local.max_sp_recursion_depth; 187ERROR 42S02: Unknown table 'local' in field list 188SELECT session.max_sp_recursion_depth; 189ERROR 42S02: Unknown table 'session' in field list 190SELECT max_sp_recursion_depth = @@session.max_sp_recursion_depth; 191ERROR 42S22: Unknown column 'max_sp_recursion_depth' in 'field list' 192SET @@global.max_sp_recursion_depth = @start_global_value; 193SELECT @@global.max_sp_recursion_depth; 194@@global.max_sp_recursion_depth 1950 196SET @@session.max_sp_recursion_depth = @start_session_value; 197SELECT @@session.max_sp_recursion_depth; 198@@session.max_sp_recursion_depth 1990 200