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 = @start_global_value; 59SELECT @@global.innodb_lock_wait_timeout; 60@@global.innodb_lock_wait_timeout 6150 62