Debian Codegraph @

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

raw
1 SET @start_buffer_pool_size = @@GLOBAL.innodb_buffer_pool_size;
2 '#---------------------BS_STVARS_022_02----------------------#'
3 SELECT @@GLOBAL.innodb_buffer_pool_size_max;
4 @@GLOBAL.innodb_buffer_pool_size_max
5 8388608
6 SELECT @@GLOBAL.innodb_buffer_pool_size = @@GLOBAL.innodb_buffer_pool_size_max;
7 @@GLOBAL.innodb_buffer_pool_size = @@GLOBAL.innodb_buffer_pool_size_max
8 1
9 SET GLOBAL innodb_buffer_pool_size = @@GLOBAL.innodb_buffer_pool_size_max + 1048576;
10 Warnings:
11 Warning 1292 Truncated incorrect innodb_buffer_pool_size value: '9437184'
12 SELECT @@GLOBAL.innodb_buffer_pool_size = @@GLOBAL.innodb_buffer_pool_size_max;
13 @@GLOBAL.innodb_buffer_pool_size = @@GLOBAL.innodb_buffer_pool_size_max
14 1
15 '#---------------------BS_STVARS_022_03----------------------#'
16 SELECT @@GLOBAL.innodb_buffer_pool_size = VARIABLE_VALUE
17 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
18 WHERE VARIABLE_NAME='innodb_buffer_pool_size';
19 @@GLOBAL.innodb_buffer_pool_size = VARIABLE_VALUE
20 1
21 1 Expected
22 SELECT COUNT(VARIABLE_VALUE)
23 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
24 WHERE VARIABLE_NAME='innodb_buffer_pool_size';
25 COUNT(VARIABLE_VALUE)
26 1
27 1 Expected
28 '#---------------------BS_STVARS_022_04----------------------#'
29 SELECT @@innodb_buffer_pool_size = @@GLOBAL.innodb_buffer_pool_size;
30 @@innodb_buffer_pool_size = @@GLOBAL.innodb_buffer_pool_size
31 1
32 1 Expected
33 '#---------------------BS_STVARS_022_05----------------------#'
34 SELECT COUNT(@@innodb_buffer_pool_size);
35 COUNT(@@innodb_buffer_pool_size)
36 1
37 1 Expected
38 SELECT COUNT(@@local.innodb_buffer_pool_size);
39 ERROR HY000: Variable 'innodb_buffer_pool_size' is a GLOBAL variable
40 Expected error 'Variable is a GLOBAL variable'
41 SELECT COUNT(@@SESSION.innodb_buffer_pool_size);
42 ERROR HY000: Variable 'innodb_buffer_pool_size' is a GLOBAL variable
43 Expected error 'Variable is a GLOBAL variable'
44 SELECT COUNT(@@GLOBAL.innodb_buffer_pool_size);
45 COUNT(@@GLOBAL.innodb_buffer_pool_size)
46 1
47 1 Expected
48 SELECT innodb_buffer_pool_size = @@SESSION.innodb_buffer_pool_size;
49 ERROR 42S22: Unknown column 'innodb_buffer_pool_size' in 'SELECT'
50 SET GLOBAL innodb_buffer_pool_size = @start_buffer_pool_size;
51 SELECT @@innodb_buffer_pool_size = @start_buffer_pool_size;
52 @@innodb_buffer_pool_size = @start_buffer_pool_size
53 1