Debian Codegraph @

mysql-test/suite/component_keyring_file/r/import_compress_encrypt.result

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 # Creating local configuration file for keyring component: component_keyring_file
4 # Creating manifest file for current MySQL server instance
5 # Re-starting mysql server with manifest file
6 # ----------------------------------------------------------------------
7 #
8 # Bug#31313533 : IMPORT FAILS FOR ENCRYPT AND COMPRESSION ENABLED TDE TABLES
9 #
10 # SETUP
11 #
12 # Try to create a table with ZLib compression with strict mode OFF.
13 # If there is an error about Punch Hole not supported, make InnoDB
14 # think that Punch Hole is working but actually ignore the calls.
15 #
16 CREATE TABLE t1(c1 INT PRIMARY KEY) COMPRESSION="ZLIB";
17 DROP TABLE t1;
18
19 # Test 1 : Check that EXPORT and IMPORT is working fine on same FS
20
21 CREATE TABLE t1(c1 int NOT NULL AUTO_INCREMENT,
22 c2 varchar(65000) DEFAULT NULL,
23 c3 varchar(255) GENERATED ALWAYS AS (substr(c2,2,100)) STORED,
24 c4 varchar(255) GENERATED ALWAYS AS (substr(c2,10,200)) VIRTUAL,
25 b bit(64) DEFAULT NULL,
26 p_c1 bigint DEFAULT NULL,
27 PRIMARY KEY (c1)) ENGINE=Innodb AUTO_INCREMENT=50001 DEFAULT CHARSET=latin1 COMPRESSION='zlib' ENCRYPTION='Y';
28 SELECT c1, HEX(SUBSTRING(c2, 10, 10)), HEX(SUBSTRING(c3, 10, 10)),
29 HEX(SUBSTRING(c4, 10, 10)), HEX(b)
30 FROM t1 ORDER BY c1 limit 10;
31 c1 HEX(SUBSTRING(c2, 10, 10)) HEX(SUBSTRING(c3, 10, 10)) HEX(SUBSTRING(c4, 10, 10)) HEX(b)
32 50001 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
33 50002 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
34 50003 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
35 50004 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
36 50005 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
37 50006 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
38 50007 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
39 50008 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
40 50009 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
41 50010 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
42 # Flush tables for export
43 FLUSH TABLES t1 FOR EXPORT;
44 # Copy .cfp .cfg .ibd file to temp
45 UNLOCK TABLES;
46 DROP TABLE t1;
47 CREATE TABLE t1(c1 int NOT NULL AUTO_INCREMENT,
48 c2 varchar(65000) DEFAULT NULL,
49 c3 varchar(255) GENERATED ALWAYS AS (substr(c2,2,100)) STORED,
50 c4 varchar(255) GENERATED ALWAYS AS (substr(c2,10,200)) VIRTUAL,
51 b bit(64) DEFAULT NULL,
52 p_c1 bigint DEFAULT NULL,
53 PRIMARY KEY (c1)) ENGINE=Innodb AUTO_INCREMENT=50001 DEFAULT CHARSET=latin1 COMPRESSION='zlib' ENCRYPTION='Y';
54 ALTER TABLE t1 DISCARD TABLESPACE;
55 # Copy .cfp/.cfg and .ibd files from temp to datadir
56 # Start import
57 ALTER TABLE t1 IMPORT TABLESPACE;
58 SELECT c1, HEX(SUBSTRING(c2, 10, 10)), HEX(SUBSTRING(c3, 10, 10)),
59 HEX(SUBSTRING(c4, 10, 10)), HEX(b) FROM t1 ORDER BY c1 limit 10;
60 c1 HEX(SUBSTRING(c2, 10, 10)) HEX(SUBSTRING(c3, 10, 10)) HEX(SUBSTRING(c4, 10, 10)) HEX(b)
61 50001 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
62 50002 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
63 50003 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
64 50004 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
65 50005 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
66 50006 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
67 50007 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
68 50008 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
69 50009 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
70 50010 51AB8660A7143704DEA7 AB8660A7143704DEA78C A78C87578839E440B5B3 A
71 # Cleanup
72 DROP TABLE t1;
73
74 # Test 2 : Check that EXPORT and IMPORT is working fine on different FS
75
76 # Copy and unzip the dir having cfg/cfg/ibd file from a different FS Block Size
77 CREATE TABLE t1(c1 int NOT NULL AUTO_INCREMENT,
78 c2 varchar(65000) DEFAULT NULL,
79 c3 varchar(255) GENERATED ALWAYS AS (substr(c2,2,100)) STORED,
80 c4 varchar(255) GENERATED ALWAYS AS (substr(c2,10,200)) VIRTUAL,
81 b bit(64) DEFAULT NULL,
82 p_c1 bigint DEFAULT NULL,
83 PRIMARY KEY (c1)) ENGINE=Innodb AUTO_INCREMENT=50001 DEFAULT CHARSET=latin1 COMPRESSION='zlib' ENCRYPTION='Y';
84 ALTER TABLE t1 DISCARD TABLESPACE;
85 # Copy .cfp/.cfg and .ibd files from temp to datadir
86 # Start import
87 ALTER TABLE t1 IMPORT TABLESPACE;
88 SELECT c1, HEX(SUBSTRING(c2, 10, 10)), HEX(SUBSTRING(c3, 10, 10)),
89 HEX(SUBSTRING(c4, 10, 10)), HEX(b) FROM t1 ORDER BY c1 limit 10;
90 c1 HEX(SUBSTRING(c2, 10, 10)) HEX(SUBSTRING(c3, 10, 10)) HEX(SUBSTRING(c4, 10, 10)) HEX(b)
91 50001 066C8ADC3EC72175CA77 6C8ADC3EC72175CA77CE 77CEF1FBCA5BFE739000 A
92 50002 066C8ADC3EC72175CA77 6C8ADC3EC72175CA77CE 77CEF1FBCA5BFE739000 A
93 50003 066C8ADC3EC72175CA77 6C8ADC3EC72175CA77CE 77CEF1FBCA5BFE739000 A
94 50004 066C8ADC3EC72175CA77 6C8ADC3EC72175CA77CE 77CEF1FBCA5BFE739000 A
95 50005 066C8ADC3EC72175CA77 6C8ADC3EC72175CA77CE 77CEF1FBCA5BFE739000 A
96 50006 066C8ADC3EC72175CA77 6C8ADC3EC72175CA77CE 77CEF1FBCA5BFE739000 A
97 50007 066C8ADC3EC72175CA77 6C8ADC3EC72175CA77CE 77CEF1FBCA5BFE739000 A
98 50008 066C8ADC3EC72175CA77 6C8ADC3EC72175CA77CE 77CEF1FBCA5BFE739000 A
99 50009 066C8ADC3EC72175CA77 6C8ADC3EC72175CA77CE 77CEF1FBCA5BFE739000 A
100 50010 066C8ADC3EC72175CA77 6C8ADC3EC72175CA77CE 77CEF1FBCA5BFE739000 A
101 # Cleanup
102 DROP TABLE t1;
103 # Remove copied files
104 # ----------------------------------------------------------------------
105 # Teardown
106 # Removing manifest file for current MySQL server instance
107 # Removing local keyring file for keyring component: component_keyring_file
108 # Removing local configuration file for keyring component: component_keyring_file
109 # Restarting server without the manifest file
110 # ----------------------------------------------------------------------