Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_file_per_table_basic.result

raw
1 SET @start_global_value = @@global.innodb_file_per_table;
2 SELECT @start_global_value;
3 @start_global_value
4 1
5 '#---------------------BS_STVARS_028_01----------------------#'
6 SELECT COUNT(@@GLOBAL.innodb_file_per_table);
7 COUNT(@@GLOBAL.innodb_file_per_table)
8 1
9 1 Expected
10 '#---------------------BS_STVARS_028_02----------------------#'
11 SET @@global.innodb_file_per_table = 0;
12 Warnings:
13 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
14 SELECT @@global.innodb_file_per_table;
15 @@global.innodb_file_per_table
16 0
17 SET @@global.innodb_file_per_table ='On' ;
18 Warnings:
19 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
20 SELECT @@global.innodb_file_per_table;
21 @@global.innodb_file_per_table
22 1
23 SET @@global.innodb_file_per_table ='Off' ;
24 Warnings:
25 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
26 SELECT @@global.innodb_file_per_table;
27 @@global.innodb_file_per_table
28 0
29 SET @@global.innodb_file_per_table = 1;
30 Warnings:
31 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
32 SELECT @@global.innodb_file_per_table;
33 @@global.innodb_file_per_table
34 1
35 '#---------------------BS_STVARS_028_03----------------------#'
36 SELECT IF(@@GLOBAL.innodb_file_per_table,'ON','OFF') = VARIABLE_VALUE
37 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
38 WHERE VARIABLE_NAME='innodb_file_per_table';
39 IF(@@GLOBAL.innodb_file_per_table,'ON','OFF') = VARIABLE_VALUE
40 1
41 1 Expected
42 SELECT COUNT(@@GLOBAL.innodb_file_per_table);
43 COUNT(@@GLOBAL.innodb_file_per_table)
44 1
45 1 Expected
46 SELECT COUNT(VARIABLE_VALUE)
47 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
48 WHERE VARIABLE_NAME='innodb_file_per_table';
49 COUNT(VARIABLE_VALUE)
50 1
51 1 Expected
52 '#---------------------BS_STVARS_028_04----------------------#'
53 SELECT @@innodb_file_per_table = @@GLOBAL.innodb_file_per_table;
54 @@innodb_file_per_table = @@GLOBAL.innodb_file_per_table
55 1
56 1 Expected
57 '#---------------------BS_STVARS_028_05----------------------#'
58 SELECT COUNT(@@innodb_file_per_table);
59 COUNT(@@innodb_file_per_table)
60 1
61 1 Expected
62 SELECT COUNT(@@local.innodb_file_per_table);
63 ERROR HY000: Variable 'innodb_file_per_table' is a GLOBAL variable
64 Expected error 'Variable is a GLOBAL variable'
65 SELECT COUNT(@@SESSION.innodb_file_per_table);
66 ERROR HY000: Variable 'innodb_file_per_table' is a GLOBAL variable
67 Expected error 'Variable is a GLOBAL variable'
68 SELECT COUNT(@@GLOBAL.innodb_file_per_table);
69 COUNT(@@GLOBAL.innodb_file_per_table)
70 1
71 1 Expected
72 SELECT innodb_file_per_table = @@SESSION.innodb_file_per_table;
73 ERROR 42S22: Unknown column 'innodb_file_per_table' in 'SELECT'
74 SET @@global.innodb_file_per_table = @start_global_value;
75 Warnings:
76 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
77 SELECT @@global.innodb_file_per_table;
78 @@global.innodb_file_per_table
79 1