1# Initial values 2SELECT @@global.max_execution_time, @@session.max_execution_time; 3@@global.max_execution_time @@session.max_execution_time 40 0 5# Save initial value 6SET @start_global_value= @@global.max_execution_time; 7SELECT @start_global_value; 8@start_global_value 90 10SET @start_session_value = @@session.max_execution_time; 11SELECT @start_session_value; 12@start_session_value 130 14# Display the DEFAULT value of max_execution_time 15SET @@session.max_execution_time = 20000; 16SET @@session.max_execution_time = DEFAULT; 17SELECT @@session.max_execution_time; 18@@session.max_execution_time 190 20SET @@global.max_execution_time = 20000; 21SET @@global.max_execution_time = DEFAULT; 22SELECT @@global.max_execution_time; 23@@global.max_execution_time 240 25# Check the DEFAULT value of max_execution_time 26SET @@global.max_execution_time = DEFAULT; 27SELECT @@global.max_execution_time = 28800; 28@@global.max_execution_time = 28800 290 30SET @@session.max_execution_time = DEFAULT; 31SELECT @@session.max_execution_time = 28800; 32@@session.max_execution_time = 28800 330 34# Check Max value for max_execution_time. 35"Max value for @@global.max_execution_time is set properly." 36"Max value for @@session.max_execution_time is set properly." 37SET @@global.max_execution_time = 0; 38SELECT @@global.max_execution_time; 39@@global.max_execution_time 400 41SET @@session.max_execution_time = 0; 42SELECT @@global.max_execution_time; 43@@global.max_execution_time 440 45# Change the value of max_execution_time to a valid value for SESSION scope 46SET @@session.max_execution_time = 10000; 47SELECT @@global.max_execution_time, @@session.max_execution_time; 48@@global.max_execution_time @@session.max_execution_time 490 10000 50SET @@session.max_execution_time = 50050; 51SELECT @@global.max_execution_time, @@session.max_execution_time; 52@@global.max_execution_time @@session.max_execution_time 530 50050 54SET @@session.max_execution_time = 65535; 55SELECT @@global.max_execution_time, @@session.max_execution_time; 56@@global.max_execution_time @@session.max_execution_time 570 65535 58# Change the value of max_execution_time to an invalid value # 59SET @@global.max_execution_time = -2; 60Warnings: 61Warning 1292 Truncated incorrect max_execution_time value: '-2' 62SELECT @@global.max_execution_time; 63@@global.max_execution_time 640 65SET @@global.max_execution_time = 65530.34; 66ERROR 42000: Incorrect argument type to variable 'max_execution_time' 67SELECT @@global.max_execution_time; 68@@global.max_execution_time 690 70SET @@global.max_execution_time = test; 71ERROR 42000: Incorrect argument type to variable 'max_execution_time' 72SELECT @@global.max_execution_time; 73@@global.max_execution_time 740 75# Change the value of max_execution_time to a valid value for SESSION scope 76SET @@session.max_execution_time = 10000; 77SELECT @@global.max_execution_time, @@session.max_execution_time; 78@@global.max_execution_time @@session.max_execution_time 790 10000 80SET @@session.max_execution_time = 50050; 81SELECT @@global.max_execution_time, @@session.max_execution_time; 82@@global.max_execution_time @@session.max_execution_time 830 50050 84SET @@session.max_execution_time = 65535; 85SELECT @@global.max_execution_time, @@session.max_execution_time; 86@@global.max_execution_time @@session.max_execution_time 870 65535 88# Change the value of max_execution_time to an invalid value # 89SET @@global.max_execution_time = -2; 90Warnings: 91Warning 1292 Truncated incorrect max_execution_time value: '-2' 92SELECT @@global.max_execution_time; 93@@global.max_execution_time 940 95SET @@global.max_execution_time = 65530.34; 96ERROR 42000: Incorrect argument type to variable 'max_execution_time' 97SELECT @@global.max_execution_time; 98@@global.max_execution_time 990 100SET @@global.max_execution_time = test; 101ERROR 42000: Incorrect argument type to variable 'max_execution_time' 102SELECT @@global.max_execution_time; 103@@global.max_execution_time 1040 105SET @@global.max_execution_time = ""; 106ERROR 42000: Incorrect argument type to variable 'max_execution_time' 107SELECT @@global.max_execution_time; 108@@global.max_execution_time 1090 110SET @@global.max_execution_time = "*"; 111ERROR 42000: Incorrect argument type to variable 'max_execution_time' 112SELECT @@global.max_execution_time; 113@@global.max_execution_time 1140 115SET @@global.max_execution_time = NULL; 116ERROR 42000: Incorrect argument type to variable 'max_execution_time' 117SELECT @@global.max_execution_time; 118@@global.max_execution_time 1190 120SET @@global.max_execution_time = "0"; 121ERROR 42000: Incorrect argument type to variable 'max_execution_time' 122SELECT @@global.max_execution_time; 123@@global.max_execution_time 1240 125SET @@global.max_execution_time = "*#$**$(@(@ ##@"; 126ERROR 42000: Incorrect argument type to variable 'max_execution_time' 127SELECT @@global.max_execution_time; 128@@global.max_execution_time 1290 130SET @@session.max_execution_time = -2; 131Warnings: 132Warning 1292 Truncated incorrect max_execution_time value: '-2' 133SELECT @@session.max_execution_time; 134@@session.max_execution_time 1350 136SET @@session.max_execution_time = 65530.34; 137ERROR 42000: Incorrect argument type to variable 'max_execution_time' 138SELECT @@session.max_execution_time; 139@@session.max_execution_time 1400 141SET @@session.max_execution_time = test; 142ERROR 42000: Incorrect argument type to variable 'max_execution_time' 143SELECT @@session.max_execution_time; 144@@session.max_execution_time 1450 146SET @@session.max_execution_time = ""; 147ERROR 42000: Incorrect argument type to variable 'max_execution_time' 148SELECT @@session.max_execution_time; 149@@session.max_execution_time 1500 151SET @@session.max_execution_time = "*"; 152ERROR 42000: Incorrect argument type to variable 'max_execution_time' 153SELECT @@session.max_execution_time; 154@@session.max_execution_time 1550 156SET @@session.max_execution_time = NULL; 157ERROR 42000: Incorrect argument type to variable 'max_execution_time' 158SELECT @@session.max_execution_time; 159@@session.max_execution_time 1600 161SET @@session.max_execution_time = "0"; 162ERROR 42000: Incorrect argument type to variable 'max_execution_time' 163SELECT @@session.max_execution_time; 164@@session.max_execution_time 1650 166SET @@session.max_execution_time = "*#$**$(@(@ ##@"; 167ERROR 42000: Incorrect argument type to variable 'max_execution_time' 168SELECT @@session.max_execution_time; 169@@session.max_execution_time 1700 171# Check if the value in GLOBAL Table matches value in variable 172SELECT @@global.max_execution_time = VARIABLE_VALUE 173FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 174WHERE VARIABLE_NAME='max_execution_time'; 175@@global.max_execution_time = VARIABLE_VALUE 1761 177# Check if the value in SESSION Table matches value in variable 178SELECT @@session.max_execution_time = VARIABLE_VALUE 179FROM INFORMATION_SCHEMA.SESSION_VARIABLES 180WHERE VARIABLE_NAME='max_execution_time'; 181@@session.max_execution_time = VARIABLE_VALUE 1821 183# Check if TRUE and FALSE values can be used on variable 184SET @@global.max_execution_time = TRUE; 185SELECT @@global.max_execution_time; 186@@global.max_execution_time 1871 188SET @@global.max_execution_time = FALSE; 189SELECT @@global.max_execution_time; 190@@global.max_execution_time 1910 192SET @@session.max_execution_time = TRUE; 193SELECT @@session.max_execution_time; 194@@session.max_execution_time 1951 196SET @@session.max_execution_time = FALSE; 197SELECT @@session.max_execution_time; 198@@session.max_execution_time 1990 200# Check if accessing variable with SESSION,LOCAL and without SCOPE points to same session variable 201SET @@max_execution_time = 10000; 202SELECT @@max_execution_time = @@local.max_execution_time; 203@@max_execution_time = @@local.max_execution_time 2041 205SELECT @@local.max_execution_time = @@session.max_execution_time; 206@@local.max_execution_time = @@session.max_execution_time 2071 208# Check if max_execution_time can be accessed with and without @@ sign 209SET max_execution_time = 10000; 210SELECT @@max_execution_time; 211@@max_execution_time 21210000 213SELECT local.max_execution_time; 214ERROR 42S02: Unknown table 'local' in field list 215SELECT session.max_execution_time; 216ERROR 42S02: Unknown table 'session' in field list 217# Restore initial value 218SET @@global.max_execution_time = @start_global_value; 219SELECT @@global.max_execution_time; 220@@global.max_execution_time 2210 222SET @@session.max_execution_time = @start_session_value; 223SELECT @@session.max_execution_time; 224@@session.max_execution_time 2250 226