Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_interpreter_basic.test

raw
1 --source include/have_debug.inc
2
3 SET @start_global_value = @@global.innodb_interpreter;
4 SELECT @start_global_value;
5
6 #
7 # exists as global only
8 #
9 select @@global.innodb_interpreter;
10 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
11 select @@session.innodb_compression_level;
12 show global variables like 'innodb_interpreter';
13 show session variables like 'innodb_interpreter';
14 --disable_warnings
15 select * from performance_schema.global_variables where variable_name='innodb_interpreter';
16 select * from performance_schema.session_variables where variable_name='innodb_interpreter';
17 --enable_warnings
18
19 CREATE TABLE t1 (f1 INT PRIMARY KEY);
20 SHOW CREATE TABLE t1;
21
22 START TRANSACTION;
23 INSERT INTO t1(f1) VALUES (1), (2), (3), (4), (5);
24 SELECT * FROM t1;
25 COMMIT;
26
27 --echo # Ensure that dirty pages of table t1 is flushed.
28 FLUSH TABLES t1 FOR EXPORT;
29 UNLOCK TABLES;
30
31 SET SESSION innodb_interpreter = 'init';
32 SET SESSION innodb_interpreter = 'open_table test/t1';
33 SET SESSION innodb_interpreter = 'find_space_id test/t1';
34 SELECT @@session.innodb_interpreter_output INTO @space_id;
35 SET SESSION innodb_interpreter = CONCAT('find_fil_page_lsn ', @space_id, ' 0');
36 SELECT @@session.innodb_interpreter_output INTO @fil_page_lsn;
37 SET SESSION innodb_interpreter = 'make_ondisk_root_page_zeroes test/t1';
38 SET SESSION innodb_interpreter = 'destroy';
39 DROP TABLE t1;
40
41 CREATE TABLE t1 (f1 INT PRIMARY KEY);
42 SHOW CREATE TABLE t1;
43
44 START TRANSACTION;
45 INSERT INTO t1(f1) VALUES (1), (2), (3), (4), (5);
46 SELECT * FROM t1;
47 COMMIT;
48
49 --echo # Ensure that dirty pages of table t1 is flushed.
50 FLUSH TABLES t1 FOR EXPORT;
51 UNLOCK TABLES;
52
53 SET SESSION innodb_interpreter = 'init';
54 SET SESSION innodb_interpreter = 'open_table test/t1';
55 SET SESSION innodb_interpreter = 'find_space_id test/t1';
56 SELECT @@session.innodb_interpreter_output INTO @space_id;
57 SET @cmd = CONCAT('find_fil_page_lsn ', @space_id, ' 0');
58 SET SESSION innodb_interpreter = @cmd;
59 SELECT @@session.innodb_interpreter_output INTO @fil_page_lsn;
60 SET SESSION innodb_interpreter = 'corrupt_ondisk_root_page test/t1';
61 SET SESSION innodb_interpreter = 'destroy';
62 DROP TABLE t1;
63
64 CREATE TABLE t1 (f1 INT PRIMARY KEY);
65 SHOW CREATE TABLE t1;
66
67 START TRANSACTION;
68 INSERT INTO t1(f1) VALUES (1), (2), (3), (4), (5);
69 SELECT * FROM t1;
70 COMMIT;
71
72 --echo # Ensure that dirty pages of table t1 is flushed.
73 FLUSH TABLES t1 FOR EXPORT;
74 UNLOCK TABLES;
75
76 SET SESSION innodb_interpreter = 'init';
77 SET SESSION innodb_interpreter = 'open_table test/t1';
78 SET SESSION innodb_interpreter = 'find_space_id test/t1';
79 SET SESSION innodb_interpreter = 'find_flush_sync_lsn';
80 SELECT @@session.innodb_interpreter_output INTO @lsn;
81 SET SESSION innodb_interpreter = 'corrupt_ondisk_page0 test/t1';
82 SET SESSION innodb_interpreter = 'destroy';
83 DROP TABLE t1;
84
85 SET @@global.innodb_interpreter = @start_global_value;
86 SELECT @@global.innodb_interpreter;
87
88 --echo #
89 --echo # Bug #33316661: setting innodb_interpreter=null terminate called after
90 --echo # throwing an instance of 'std::logic_error'
91 --echo #
92
93 --error ER_WRONG_VALUE_FOR_VAR
94 SET SESSION innodb_interpreter = null;
95 --error ER_WRONG_TYPE_FOR_VAR
96 SET SESSION innodb_interpreter = 0;
97 --error ER_WRONG_VALUE_FOR_VAR
98 SET GLOBAL innodb_interpreter = null;
99 --error ER_WRONG_TYPE_FOR_VAR
100 SET GLOBAL innodb_interpreter = 0;