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 '#---------------------BS_STVARS_035_02----------------------#'
7 SET @@GLOBAL.innodb_log_file_size=10485760;
8 SELECT COUNT(@@GLOBAL.innodb_log_file_size);
9 COUNT(@@GLOBAL.innodb_log_file_size)
10 1
11 1 Expected
12 '#---------------------BS_STVARS_035_03----------------------#'
13 SELECT @@GLOBAL.innodb_log_file_size = VARIABLE_VALUE
14 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
15 WHERE VARIABLE_NAME='innodb_log_file_size';
16 @@GLOBAL.innodb_log_file_size = VARIABLE_VALUE
17 1
18 1 Expected
19 SELECT COUNT(@@GLOBAL.innodb_log_file_size);
20 COUNT(@@GLOBAL.innodb_log_file_size)
21 1
22 1 Expected
23 SELECT COUNT(VARIABLE_VALUE)
24 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
25 WHERE VARIABLE_NAME='innodb_log_file_size';
26 COUNT(VARIABLE_VALUE)
27 1
28 1 Expected
29 '#---------------------BS_STVARS_035_04----------------------#'
30 SELECT @@innodb_log_file_size = @@GLOBAL.innodb_log_file_size;
31 @@innodb_log_file_size = @@GLOBAL.innodb_log_file_size
32 1
33 1 Expected
34 '#---------------------BS_STVARS_035_05----------------------#'
35 SELECT COUNT(@@innodb_log_file_size);
36 COUNT(@@innodb_log_file_size)
37 1
38 1 Expected
39 SELECT COUNT(@@local.innodb_log_file_size);
40 ERROR HY000: Variable 'innodb_log_file_size' is a GLOBAL variable
41 Expected error 'Variable is a GLOBAL variable'
42 SELECT COUNT(@@SESSION.innodb_log_file_size);
43 ERROR HY000: Variable 'innodb_log_file_size' is a GLOBAL variable
44 Expected error 'Variable is a GLOBAL variable'
45 SELECT COUNT(@@GLOBAL.innodb_log_file_size);
46 COUNT(@@GLOBAL.innodb_log_file_size)
47 1
48 1 Expected
49 SELECT innodb_log_file_size = @@SESSION.innodb_log_file_size;
50 ERROR 42S22: Unknown column 'innodb_log_file_size' in 'SELECT'
51 Expected error 'Readonly variable'