1SET @start_global_value=@@global.innodb_lock_wait_timeout; 2SELECT @start_global_value; 3@start_global_value 450 5'#---------------------BS_STVARS_032_01----------------------#' 6SELECT COUNT(@@GLOBAL.innodb_lock_wait_timeout); 7COUNT(@@GLOBAL.innodb_lock_wait_timeout) 81 91 Expected 10'#---------------------BS_STVARS_032_02----------------------#' 11SET global innodb_lock_wait_timeout=60; 12SELECT @@global.innodb_lock_wait_timeout; 13@@global.innodb_lock_wait_timeout 1460 15SET session innodb_lock_wait_timeout=60; 16SELECT @@session.innodb_lock_wait_timeout; 17@@session.innodb_lock_wait_timeout 1860 19'#---------------------BS_STVARS_032_03----------------------#' 20SELECT @@GLOBAL.innodb_lock_wait_timeout = VARIABLE_VALUE 21FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 22WHERE VARIABLE_NAME='innodb_lock_wait_timeout'; 23@@GLOBAL.innodb_lock_wait_timeout = VARIABLE_VALUE 241 251 Expected 26SELECT COUNT(@@GLOBAL.innodb_lock_wait_timeout); 27COUNT(@@GLOBAL.innodb_lock_wait_timeout) 281 291 Expected 30SELECT COUNT(VARIABLE_VALUE) 31FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 32WHERE VARIABLE_NAME='innodb_lock_wait_timeout'; 33COUNT(VARIABLE_VALUE) 341 351 Expected 36'#---------------------BS_STVARS_032_04----------------------#' 37SELECT @@innodb_lock_wait_timeout = @@GLOBAL.innodb_lock_wait_timeout; 38@@innodb_lock_wait_timeout = @@GLOBAL.innodb_lock_wait_timeout 391 401 Expected 41'#---------------------BS_STVARS_032_05----------------------#' 42SELECT COUNT(@@innodb_lock_wait_timeout); 43COUNT(@@innodb_lock_wait_timeout) 441 451 Expected 46SELECT COUNT(@@local.innodb_lock_wait_timeout); 47COUNT(@@local.innodb_lock_wait_timeout) 481 49SELECT COUNT(@@SESSION.innodb_lock_wait_timeout); 50COUNT(@@SESSION.innodb_lock_wait_timeout) 511 52SELECT COUNT(@@GLOBAL.innodb_lock_wait_timeout); 53COUNT(@@GLOBAL.innodb_lock_wait_timeout) 541 551 Expected 56SELECT innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout; 57ERROR 42S22: Unknown column 'innodb_lock_wait_timeout' in 'field list' 58set @@global.innodb_lock_wait_timeout=100; 59set @@global.innodb_lock_wait_timeout=DEFAULT; 60select @@global.innodb_lock_wait_timeout; 61@@global.innodb_lock_wait_timeout 6250 63set @@session.innodb_lock_wait_timeout=100; 64set @@session.innodb_lock_wait_timeout=DEFAULT; 65select @@session.innodb_lock_wait_timeout; 66@@session.innodb_lock_wait_timeout 6750 68SET @@global.innodb_lock_wait_timeout=1; 69SELECT @@global.innodb_lock_wait_timeout; 70@@global.innodb_lock_wait_timeout 711 72SET @@global.innodb_lock_wait_timeout=1024; 73SELECT @@global.innodb_lock_wait_timeout; 74@@global.innodb_lock_wait_timeout 751024 76SET @@global.innodb_lock_wait_timeout=1073741824; 77SELECT @@global.innodb_lock_wait_timeout; 78@@global.innodb_lock_wait_timeout 791073741824 80SET @@session.innodb_lock_wait_timeout=1; 81SELECT @@session.innodb_lock_wait_timeout; 82@@session.innodb_lock_wait_timeout 831 84SET @@session.innodb_lock_wait_timeout=1024; 85SELECT @@session.innodb_lock_wait_timeout; 86@@session.innodb_lock_wait_timeout 871024 88SET @@session.innodb_lock_wait_timeout=1073741824; 89SELECT @@session.innodb_lock_wait_timeout; 90@@session.innodb_lock_wait_timeout 911073741824 92SET @@global.innodb_lock_wait_timeout="t"; 93ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout' 94SELECT @@global.innodb_lock_wait_timeout; 95@@global.innodb_lock_wait_timeout 961073741824 97SET @@global.innodb_lock_wait_timeout=-1024; 98Warnings: 99Warning 1292 Truncated incorrect innodb_lock_wait_timeout value: '-1024' 100SELECT @@global.innodb_lock_wait_timeout; 101@@global.innodb_lock_wait_timeout 1020 103SET @@global.innodb_lock_wait_timeout=1073741825; 104Warnings: 105Warning 1292 Truncated incorrect innodb_lock_wait_timeout value: '1073741825' 106SELECT @@global.innodb_lock_wait_timeout; 107@@global.innodb_lock_wait_timeout 1081073741824 109SET @@global.innodb_lock_wait_timeout=" "; 110ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout' 111SELECT @@global.innodb_lock_wait_timeout; 112@@global.innodb_lock_wait_timeout 1131073741824 114SET @@global.innodb_lock_wait_timeout=' '; 115ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout' 116SELECT @@global.innodb_lock_wait_timeout; 117@@global.innodb_lock_wait_timeout 1181073741824 119SET @@global.innodb_lock_wait_timeout=1.1; 120ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout' 121SELECT @@global.innodb_lock_wait_timeout; 122@@global.innodb_lock_wait_timeout 1231073741824 124SET @@session.innodb_lock_wait_timeout="T"; 125ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout' 126SELECT @@session.innodb_lock_wait_timeout; 127@@session.innodb_lock_wait_timeout 1281073741824 129SET @@session.innodb_lock_wait_timeout=-1024; 130Warnings: 131Warning 1292 Truncated incorrect innodb_lock_wait_timeout value: '-1024' 132SELECT @@session.innodb_lock_wait_timeout; 133@@session.innodb_lock_wait_timeout 1340 135SET @@session.innodb_lock_wait_timeout=1073999999; 136Warnings: 137Warning 1292 Truncated incorrect innodb_lock_wait_timeout value: '1073999999' 138SELECT @@session.innodb_lock_wait_timeout; 139@@session.innodb_lock_wait_timeout 1401073741824 141SET @@session.innodb_lock_wait_timeout=' '; 142ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout' 143SELECT @@session.innodb_lock_wait_timeout; 144@@session.innodb_lock_wait_timeout 1451073741824 146SET @@session.innodb_lock_wait_timeout=" "; 147ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout' 148SELECT @@session.innodb_lock_wait_timeout; 149@@session.innodb_lock_wait_timeout 1501073741824 151SET @@session.innodb_lock_wait_timeout=1.1; 152ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout' 153SELECT @@session.innodb_lock_wait_timeout; 154@@session.innodb_lock_wait_timeout 1551073741824 156SET @@global.innodb_lock_wait_timeout = @start_global_value; 157SELECT @@global.innodb_lock_wait_timeout; 158@@global.innodb_lock_wait_timeout 15950 160