Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_interpreter;
2 SELECT @start_global_value;
3 @start_global_value
4 init
5 select @@global.innodb_interpreter;
6 @@global.innodb_interpreter
7 init
8 select @@session.innodb_compression_level;
9 ERROR HY000: Variable 'innodb_compression_level' is a GLOBAL variable
10 show global variables like 'innodb_interpreter';
11 Variable_name Value
12 innodb_interpreter init
13 show session variables like 'innodb_interpreter';
14 Variable_name Value
15 innodb_interpreter init
16 select * from performance_schema.global_variables where variable_name='innodb_interpreter';
17 VARIABLE_NAME VARIABLE_VALUE
18 innodb_interpreter init
19 select * from performance_schema.session_variables where variable_name='innodb_interpreter';
20 VARIABLE_NAME VARIABLE_VALUE
21 innodb_interpreter init
22 CREATE TABLE t1 (f1 INT PRIMARY KEY);
23 SHOW CREATE TABLE t1;
24 Table Create Table
25 t1 CREATE TABLE `t1` (
26 `f1` int NOT NULL,
27 PRIMARY KEY (`f1`)
28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
29 START TRANSACTION;
30 INSERT INTO t1(f1) VALUES (1), (2), (3), (4), (5);
31 SELECT * FROM t1;
32 f1
33 1
34 2
35 3
36 4
37 5
38 COMMIT;
39 # Ensure that dirty pages of table t1 is flushed.
40 FLUSH TABLES t1 FOR EXPORT;
41 UNLOCK TABLES;
42 SET SESSION innodb_interpreter = 'init';
43 SET SESSION innodb_interpreter = 'open_table test/t1';
44 SET SESSION innodb_interpreter = 'find_space_id test/t1';
45 SELECT @@session.innodb_interpreter_output INTO @space_id;
46 SET SESSION innodb_interpreter = CONCAT('find_fil_page_lsn ', @space_id, ' 0');
47 SELECT @@session.innodb_interpreter_output INTO @fil_page_lsn;
48 SET SESSION innodb_interpreter = 'make_ondisk_root_page_zeroes test/t1';
49 SET SESSION innodb_interpreter = 'destroy';
50 DROP TABLE t1;
51 CREATE TABLE t1 (f1 INT PRIMARY KEY);
52 SHOW CREATE TABLE t1;
53 Table Create Table
54 t1 CREATE TABLE `t1` (
55 `f1` int NOT NULL,
56 PRIMARY KEY (`f1`)
57 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
58 START TRANSACTION;
59 INSERT INTO t1(f1) VALUES (1), (2), (3), (4), (5);
60 SELECT * FROM t1;
61 f1
62 1
63 2
64 3
65 4
66 5
67 COMMIT;
68 # Ensure that dirty pages of table t1 is flushed.
69 FLUSH TABLES t1 FOR EXPORT;
70 UNLOCK TABLES;
71 SET SESSION innodb_interpreter = 'init';
72 SET SESSION innodb_interpreter = 'open_table test/t1';
73 SET SESSION innodb_interpreter = 'find_space_id test/t1';
74 SELECT @@session.innodb_interpreter_output INTO @space_id;
75 SET @cmd = CONCAT('find_fil_page_lsn ', @space_id, ' 0');
76 SET SESSION innodb_interpreter = @cmd;
77 SELECT @@session.innodb_interpreter_output INTO @fil_page_lsn;
78 SET SESSION innodb_interpreter = 'corrupt_ondisk_root_page test/t1';
79 SET SESSION innodb_interpreter = 'destroy';
80 DROP TABLE t1;
81 CREATE TABLE t1 (f1 INT PRIMARY KEY);
82 SHOW CREATE TABLE t1;
83 Table Create Table
84 t1 CREATE TABLE `t1` (
85 `f1` int NOT NULL,
86 PRIMARY KEY (`f1`)
87 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
88 START TRANSACTION;
89 INSERT INTO t1(f1) VALUES (1), (2), (3), (4), (5);
90 SELECT * FROM t1;
91 f1
92 1
93 2
94 3
95 4
96 5
97 COMMIT;
98 # Ensure that dirty pages of table t1 is flushed.
99 FLUSH TABLES t1 FOR EXPORT;
100 UNLOCK TABLES;
101 SET SESSION innodb_interpreter = 'init';
102 SET SESSION innodb_interpreter = 'open_table test/t1';
103 SET SESSION innodb_interpreter = 'find_space_id test/t1';
104 SET SESSION innodb_interpreter = 'find_flush_sync_lsn';
105 SELECT @@session.innodb_interpreter_output INTO @lsn;
106 SET SESSION innodb_interpreter = 'corrupt_ondisk_page0 test/t1';
107 SET SESSION innodb_interpreter = 'destroy';
108 DROP TABLE t1;
109 SET @@global.innodb_interpreter = @start_global_value;
110 SELECT @@global.innodb_interpreter;
111 @@global.innodb_interpreter
112 init
113 #
114 # Bug #33316661: setting innodb_interpreter=null terminate called after
115 # throwing an instance of 'std::logic_error'
116 #
117 SET SESSION innodb_interpreter = null;
118 ERROR 42000: Variable 'innodb_interpreter' can't be set to the value of 'NULL'
119 SET SESSION innodb_interpreter = 0;
120 ERROR 42000: Incorrect argument type to variable 'innodb_interpreter'
121 SET GLOBAL innodb_interpreter = null;
122 ERROR 42000: Variable 'innodb_interpreter' can't be set to the value of 'NULL'
123 SET GLOBAL innodb_interpreter = 0;
124 ERROR 42000: Incorrect argument type to variable 'innodb_interpreter'