Debian Codegraph @

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

raw
1 CALL mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* ignoring option '--innodb-extend-and-initialize'");
2 SET @start_global_value = @@global.innodb_extend_and_initialize;
3 SET @start_session_value = @@session.innodb_extend_and_initialize;
4 ERROR HY000: Variable 'innodb_extend_and_initialize' is a GLOBAL variable
5 SELECT @@global.innodb_extend_and_initialize;
6 @@global.innodb_extend_and_initialize
7 1
8 SET @@global.innodb_extend_and_initialize = DEFAULT;
9 SELECT @@global.innodb_extend_and_initialize;
10 @@global.innodb_extend_and_initialize
11 1
12 SET @@session.innodb_extend_and_initialize = DEFAULT;
13 ERROR HY000: Variable 'innodb_extend_and_initialize' is a GLOBAL variable and should be set with SET GLOBAL
14 SET @@global.innodb_extend_and_initialize = 10;
15 ERROR 42000: Variable 'innodb_extend_and_initialize' can't be set to the value of '10'
16 SET @@global.innodb_extend_and_initialize = 'abc';
17 ERROR 42000: Variable 'innodb_extend_and_initialize' can't be set to the value of 'abc'
18 SELECT @@global.innodb_extend_and_initialize;
19 @@global.innodb_extend_and_initialize
20 1
21 SET @@global.innodb_extend_and_initialize = false;
22 SELECT @@global.innodb_extend_and_initialize;
23 @@global.innodb_extend_and_initialize
24 0
25 SET @@global.innodb_extend_and_initialize = true;
26 SELECT @@global.innodb_extend_and_initialize;
27 @@global.innodb_extend_and_initialize
28 1
29 SET @@global.innodb_extend_and_initialize = OFF;
30 SELECT @@global.innodb_extend_and_initialize;
31 @@global.innodb_extend_and_initialize
32 0
33 SET @@global.innodb_extend_and_initialize = ON;
34 SELECT @@global.innodb_extend_and_initialize;
35 @@global.innodb_extend_and_initialize
36 1
37 SET @@global.innodb_extend_and_initialize = 0;
38 SELECT @@global.innodb_extend_and_initialize;
39 @@global.innodb_extend_and_initialize
40 0
41 SET @@global.innodb_extend_and_initialize = 1;
42 SELECT @@global.innodb_extend_and_initialize;
43 @@global.innodb_extend_and_initialize
44 1
45 SET @@global.innodb_extend_and_initialize = @start_global_value;
46 # restart: --innodb-extend-and-initialize=10
47 SELECT @@global.innodb_extend_and_initialize;
48 @@global.innodb_extend_and_initialize
49 1
50 # restart: --innodb-extend-and-initialize='xyz'
51 SELECT @@global.innodb_extend_and_initialize;
52 @@global.innodb_extend_and_initialize
53 1
54 # restart: --innodb-extend-and-initialize=false
55 SELECT @@global.innodb_extend_and_initialize;
56 @@global.innodb_extend_and_initialize
57 0
58 # restart: --innodb-extend-and-initialize=true
59 SELECT @@global.innodb_extend_and_initialize;
60 @@global.innodb_extend_and_initialize
61 1
62 # restart: --innodb-extend-and-initialize=off
63 SELECT @@global.innodb_extend_and_initialize;
64 @@global.innodb_extend_and_initialize
65 0
66 # restart: --innodb-extend-and-initialize=on
67 SELECT @@global.innodb_extend_and_initialize;
68 @@global.innodb_extend_and_initialize
69 1
70 # restart: --innodb-extend-and-initialize=0
71 SELECT @@global.innodb_extend_and_initialize;
72 @@global.innodb_extend_and_initialize
73 0
74 SET @@global.innodb_extend_and_initialize = on;
75 SELECT @@global.innodb_extend_and_initialize;
76 @@global.innodb_extend_and_initialize
77 1
78 # restart: --innodb-extend-and-initialize=1
79 SELECT @@global.innodb_extend_and_initialize;
80 @@global.innodb_extend_and_initialize
81 1
82 # restart:
83 SELECT @@global.innodb_extend_and_initialize;
84 @@global.innodb_extend_and_initialize
85 1
86 SET PERSIST innodb_extend_and_initialize = FALSE;
87 # restart:
88 SELECT @@global.innodb_extend_and_initialize;
89 @@global.innodb_extend_and_initialize
90 0
91 SET PERSIST innodb_extend_and_initialize = DEFAULT;
92 # restart:
93 RESET PERSIST;