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