Debian Codegraph @

mysql-test/suite/archive/mysqlhotcopy_archive.result

raw
1 DROP DATABASE IF EXISTS hotcopy_test;
2 CREATE DATABASE hotcopy_test;
3 USE hotcopy_test;
4 CREATE TABLE t1 (c1 int, c2 varchar(20)) ENGINE=archive;
5 CREATE TABLE t2 (c1 int, c2 varchar(20)) ENGINE=archive;
6 CREATE TABLE t3 (c1 int, c2 varchar(20)) ENGINE=archive;
7 INSERT INTO t1 VALUES (1,'aaaaaaaaaaaaaaaaaaaa'),(2, 'bbbbbbbbbbbbbbbbbbbbbbb');
8 Warnings:
9 Warning 1406 Data too long for column 'c2' at row 2
10 INSERT INTO t2 VALUES (1,'aaaaaaaaaaaaaaaaaaaa'),(2, 'bbbbbbbbbbbbbbbbbbbbbbb');
11 Warnings:
12 Warning 1406 Data too long for column 'c2' at row 2
13 INSERT INTO t3 VALUES (1,'aaaaaaaaaaaaaaaaaaaa'),(2, 'bbbbbbbbbbbbbbbbbbbbbbb');
14 Warnings:
15 Warning 1406 Data too long for column 'c2' at row 2
16 db.opt
17 t1.ARZ
18 t1.frm
19 t2.ARZ
20 t2.frm
21 t3.ARZ
22 t3.frm
23 db.opt
24 t1.ARZ
25 t1.frm
26 t2.ARZ
27 t2.frm
28 t3.ARZ
29 t3.frm
30 USE hotcopy_save;
31 SELECT * FROM t1;
32 c1 c2
33 1 aaaaaaaaaaaaaaaaaaaa
34 2 bbbbbbbbbbbbbbbbbbbb
35 SELECT * FROM t2;
36 c1 c2
37 1 aaaaaaaaaaaaaaaaaaaa
38 2 bbbbbbbbbbbbbbbbbbbb
39 SELECT * FROM t3;
40 c1 c2
41 1 aaaaaaaaaaaaaaaaaaaa
42 2 bbbbbbbbbbbbbbbbbbbb
43 USE hotcopy_test;
44 DROP TABLE t2;
45 db.opt
46 t1.ARZ
47 t1.frm
48 t3.ARZ
49 t3.frm
50 FLUSH TABLES;
51 SELECT * FROM t1;
52 c1 c2
53 1 aaaaaaaaaaaaaaaaaaaa
54 2 bbbbbbbbbbbbbbbbbbbb
55 SELECT * FROM t2;
56 c1 c2
57 1 aaaaaaaaaaaaaaaaaaaa
58 2 bbbbbbbbbbbbbbbbbbbb
59 SELECT * FROM t3;
60 c1 c2
61 1 aaaaaaaaaaaaaaaaaaaa
62 2 bbbbbbbbbbbbbbbbbbbb
63 USE hotcopy_test;
64 db.opt
65 t1.ARZ
66 t1.frm
67 t2.ARZ
68 t2.frm
69 t3.ARZ
70 t3.frm
71 DROP DATABASE hotcopy_save;
72 db.opt
73 t1.ARZ
74 t1.frm
75 t2.ARZ
76 t2.frm
77 t3.ARZ
78 t3.frm
79 DROP DATABASE hotcopy_save;
80 db.opt
81 t1.ARZ
82 t1.frm
83 t2.ARZ
84 t2.frm
85 t3.ARZ
86 t3.frm
87 db.opt
88 t1.ARZ
89 t1.frm
90 t2.ARZ
91 t2.frm
92 t3.ARZ
93 t3.frm
94 db.opt
95 t1.ARZ
96 t1.frm
97 t2.ARZ
98 t2.frm
99 t3.ARZ
100 t3.frm
101 db.opt
102 t1.ARZ
103 t1.frm
104 t2.ARZ
105 t2.frm
106 t3.ARZ
107 t3.frm
108 db.opt
109 t1.ARZ
110 t1.frm
111 t2.ARZ
112 t2.frm
113 t3.ARZ
114 t3.frm
115 DROP DATABASE hotcopy_test_cpy;
116 DROP DATABASE hotcopy_test;
117 DROP DATABASE hotcopy_save;
118 DROP DATABASE hotcopy_save_old;