Debian Codegraph @

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

raw
1 '#---------------------BS_STVARS_035_01----------------------#'
2 SELECT COUNT(@@GLOBAL.innodb_log_file_size);
3 COUNT(@@GLOBAL.innodb_log_file_size)
4 1
5 1 Expected
6 SELECT @@GLOBAL.innodb_log_file_size;
7 @@GLOBAL.innodb_log_file_size
8 50331648
9 '#---------------------BS_STVARS_035_02----------------------#'
10 SET @@local.innodb_log_file_size=1;
11 ERROR HY000: Variable 'innodb_log_file_size' is a read only variable
12 Expected error 'Read only variable'
13 SET @@session.innodb_log_file_size=1;
14 ERROR HY000: Variable 'innodb_log_file_size' is a read only variable
15 Expected error 'Read only variable'
16 SET @@GLOBAL.innodb_log_file_size=1;
17 ERROR HY000: Variable 'innodb_log_file_size' is a read only variable
18 Expected error 'Read only variable'
19 SET @@GLOBAL.innodb_log_file_size=DEFAULT;
20 ERROR HY000: Variable 'innodb_log_file_size' is a read only variable
21 Expected error 'Read only variable'
22 SELECT COUNT(@@GLOBAL.innodb_log_file_size);
23 COUNT(@@GLOBAL.innodb_log_file_size)
24 1
25 1 Expected
26 '#---------------------BS_STVARS_035_03----------------------#'
27 SELECT @@GLOBAL.innodb_log_file_size = VARIABLE_VALUE
28 FROM performance_schema.global_variables
29 WHERE VARIABLE_NAME='innodb_log_file_size';
30 @@GLOBAL.innodb_log_file_size = VARIABLE_VALUE
31 1
32 1 Expected
33 SELECT COUNT(@@GLOBAL.innodb_log_file_size);
34 COUNT(@@GLOBAL.innodb_log_file_size)
35 1
36 1 Expected
37 SELECT COUNT(VARIABLE_VALUE)
38 FROM performance_schema.global_variables
39 WHERE VARIABLE_NAME='innodb_log_file_size';
40 COUNT(VARIABLE_VALUE)
41 1
42 1 Expected
43 '#---------------------BS_STVARS_035_04----------------------#'
44 SELECT @@innodb_log_file_size = @@GLOBAL.innodb_log_file_size;
45 @@innodb_log_file_size = @@GLOBAL.innodb_log_file_size
46 1
47 1 Expected
48 '#---------------------BS_STVARS_035_05----------------------#'
49 SELECT COUNT(@@innodb_log_file_size);
50 COUNT(@@innodb_log_file_size)
51 1
52 1 Expected
53 SELECT COUNT(@@local.innodb_log_file_size);
54 ERROR HY000: Variable 'innodb_log_file_size' is a GLOBAL variable
55 Expected error 'Variable is a GLOBAL variable'
56 SELECT COUNT(@@SESSION.innodb_log_file_size);
57 ERROR HY000: Variable 'innodb_log_file_size' is a GLOBAL variable
58 Expected error 'Variable is a GLOBAL variable'
59 SELECT COUNT(@@GLOBAL.innodb_log_file_size);
60 COUNT(@@GLOBAL.innodb_log_file_size)
61 1
62 1 Expected
63 SELECT innodb_log_file_size;
64 ERROR 42S22: Unknown column 'innodb_log_file_size' in 'field list'
65 Expected error 'Unknown column'