1SET @start_global_value = @@global.innodb_file_per_table; 2SELECT @start_global_value; 3@start_global_value 41 5'#---------------------BS_STVARS_028_01----------------------#' 6SELECT COUNT(@@GLOBAL.innodb_file_per_table); 7COUNT(@@GLOBAL.innodb_file_per_table) 81 91 Expected 10'#---------------------BS_STVARS_028_02----------------------#' 11SET @@global.innodb_file_per_table = 0; 12SELECT @@global.innodb_file_per_table; 13@@global.innodb_file_per_table 140 15SET @@global.innodb_file_per_table ='On' ; 16SELECT @@global.innodb_file_per_table; 17@@global.innodb_file_per_table 181 19SET @@global.innodb_file_per_table ='Off' ; 20SELECT @@global.innodb_file_per_table; 21@@global.innodb_file_per_table 220 23SET @@global.innodb_file_per_table = 1; 24SELECT @@global.innodb_file_per_table; 25@@global.innodb_file_per_table 261 27'#---------------------BS_STVARS_028_03----------------------#' 28SELECT IF(@@GLOBAL.innodb_file_per_table,'ON','OFF') = VARIABLE_VALUE 29FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 30WHERE VARIABLE_NAME='innodb_file_per_table'; 31IF(@@GLOBAL.innodb_file_per_table,'ON','OFF') = VARIABLE_VALUE 321 331 Expected 34SELECT COUNT(@@GLOBAL.innodb_file_per_table); 35COUNT(@@GLOBAL.innodb_file_per_table) 361 371 Expected 38SELECT COUNT(VARIABLE_VALUE) 39FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 40WHERE VARIABLE_NAME='innodb_file_per_table'; 41COUNT(VARIABLE_VALUE) 421 431 Expected 44'#---------------------BS_STVARS_028_04----------------------#' 45SELECT @@innodb_file_per_table = @@GLOBAL.innodb_file_per_table; 46@@innodb_file_per_table = @@GLOBAL.innodb_file_per_table 471 481 Expected 49'#---------------------BS_STVARS_028_05----------------------#' 50SELECT COUNT(@@innodb_file_per_table); 51COUNT(@@innodb_file_per_table) 521 531 Expected 54SELECT COUNT(@@local.innodb_file_per_table); 55ERROR HY000: Variable 'innodb_file_per_table' is a GLOBAL variable 56Expected error 'Variable is a GLOBAL variable' 57SELECT COUNT(@@SESSION.innodb_file_per_table); 58ERROR HY000: Variable 'innodb_file_per_table' is a GLOBAL variable 59Expected error 'Variable is a GLOBAL variable' 60SELECT COUNT(@@GLOBAL.innodb_file_per_table); 61COUNT(@@GLOBAL.innodb_file_per_table) 621 631 Expected 64SELECT innodb_file_per_table = @@SESSION.innodb_file_per_table; 65ERROR 42S22: Unknown column 'innodb_file_per_table' in 'field list' 66SET @@global.innodb_file_per_table = @start_global_value; 67SELECT @@global.innodb_file_per_table; 68@@global.innodb_file_per_table 691 70