Debian Codegraph @

mysql-test/suite/ndb/r/ndb_restore_conv_padding.result

raw
1 Warnings:
2 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
3 ************************************************************
4 * Creating table with char+binary types
5 ************************************************************
6 CREATE TABLE t3(
7 c1 char(32),
8 b1 binary(32)
9 ) CHARACTER SET latin1 ENGINE=NDB;
10 INSERT INTO t3 VALUES('aaaaaaaa', 'bbbbbbbb');
11 SELECT length(c1), length(b1) FROM t3;
12 length(c1) length(b1)
13 8 32
14 ************************************************************
15 * Backing up table with char+binary types
16 ************************************************************
17 ************************************************************
18 * Restoring table with unchanged char+binary types (sanity check):
19 * char(32) --> char(32)
20 * binary(32) --> binary(32)
21 ************************************************************
22 CREATE TABLE t3_myisam ENGINE=MYISAM AS SELECT * FROM t3;
23 DELETE FROM t3;
24 SELECT length(c1), length(b1) FROM t3;
25 length(c1) length(b1)
26 8 32
27 SELECT COUNT(*) FROM t3 NATURAL JOIN t3_myisam;
28 COUNT(*)
29 1
30 DROP TABLE t3_myisam;
31 ************************************************************
32 * Restoring table with promoted char+binary types preserving padding:
33 * char(32) --> varchar(32)
34 * binary(32) --> varbinary(32)
35 ************************************************************
36 ALTER TABLE t3 MODIFY c1 varchar(32), MODIFY b1 varbinary(32);
37 SELECT length(c1), length(b1) FROM t3;
38 length(c1) length(b1)
39 8 32
40 CREATE TABLE t3_myisam ENGINE=MYISAM AS SELECT * FROM t3;
41 DELETE FROM t3;
42 SELECT length(c1), length(b1) FROM t3;
43 length(c1) length(b1)
44 32 32
45 SELECT COUNT(*) FROM t3 NATURAL JOIN t3_myisam;
46 COUNT(*)
47 1
48 DROP TABLE t3_myisam;
49 ************************************************************
50 * Restoring table with promoted char+binary types preserving padding:
51 * char(32) --> varchar(64)
52 * binary(32) --> varbinary(64)
53 ************************************************************
54 ALTER TABLE t3 MODIFY c1 varchar(64), MODIFY b1 varbinary(64);
55 SELECT length(c1), length(b1) FROM t3;
56 length(c1) length(b1)
57 32 32
58 CREATE TABLE t3_myisam ENGINE=MYISAM AS SELECT * FROM t3;
59 DELETE FROM t3;
60 SELECT length(c1), length(b1) FROM t3;
61 length(c1) length(b1)
62 32 32
63 SELECT COUNT(*) FROM t3 NATURAL JOIN t3_myisam;
64 COUNT(*)
65 1
66 DROP TABLE t3_myisam;
67 ************************************************************
68 * Restoring table with promoted char+binary types preserving padding:
69 * char(32) --> varchar(512)
70 * binary(32) --> varbinary(512)
71 ************************************************************
72 ALTER TABLE t3 MODIFY c1 varchar(512), MODIFY b1 varbinary(512);
73 SELECT length(c1), length(b1) FROM t3;
74 length(c1) length(b1)
75 32 32
76 CREATE TABLE t3_myisam ENGINE=MYISAM AS SELECT * FROM t3;
77 DELETE FROM t3;
78 SELECT length(c1), length(b1) FROM t3;
79 length(c1) length(b1)
80 32 32
81 SELECT COUNT(*) FROM t3 NATURAL JOIN t3_myisam;
82 COUNT(*)
83 1
84 DROP TABLE t3_myisam;
85 ************************************************************
86 * Restoring table with demoted char+binary types preserving padding:
87 * char(32) --> varchar(16)
88 * binary(32) --> varbinary(16)
89 ************************************************************
90 ALTER TABLE t3 MODIFY c1 varchar(16), MODIFY b1 varbinary(16);
91 SELECT length(c1), length(b1) FROM t3;
92 length(c1) length(b1)
93 16 16
94 CREATE TABLE t3_myisam ENGINE=MYISAM AS SELECT * FROM t3;
95 DELETE FROM t3;
96 SELECT length(c1), length(b1) FROM t3;
97 length(c1) length(b1)
98 16 16
99 SELECT COUNT(*) FROM t3 NATURAL JOIN t3_myisam;
100 COUNT(*)
101 1
102 DROP TABLE t3_myisam;
103 ************************************************************
104 * Restoring table with promoted char+binary types discarding padding:
105 * char(32) --> varchar(32)
106 * binary(32) --> varbinary(32)
107 ************************************************************
108 DELETE FROM t3;
109 ALTER TABLE t3 MODIFY c1 varchar(32), MODIFY b1 varbinary(32);
110 INSERT INTO t3 VALUES('aaaaaaaa', 'bbbbbbbb');
111 SELECT length(c1), length(b1) FROM t3;
112 length(c1) length(b1)
113 8 8
114 CREATE TABLE t3_myisam ENGINE=MYISAM AS SELECT * FROM t3;
115 DELETE FROM t3;
116 SELECT length(c1), length(b1) FROM t3;
117 length(c1) length(b1)
118 8 8
119 SELECT COUNT(*) FROM t3 NATURAL JOIN t3_myisam;
120 COUNT(*)
121 1
122 DROP TABLE t3_myisam;
123 ************************************************************
124 * Restoring table with promoted char+binary types discarding padding:
125 * char(32) --> varchar(64)
126 * binary(32) --> varbinary(64)
127 ************************************************************
128 ALTER TABLE t3 MODIFY c1 varchar(64), MODIFY b1 varbinary(64);
129 SELECT length(c1), length(b1) FROM t3;
130 length(c1) length(b1)
131 8 8
132 CREATE TABLE t3_myisam ENGINE=MYISAM AS SELECT * FROM t3;
133 DELETE FROM t3;
134 SELECT length(c1), length(b1) FROM t3;
135 length(c1) length(b1)
136 8 8
137 SELECT COUNT(*) FROM t3 NATURAL JOIN t3_myisam;
138 COUNT(*)
139 1
140 DROP TABLE t3_myisam;
141 ************************************************************
142 * Restoring table with promoted char+binary types discarding padding:
143 * char(32) --> varchar(512)
144 * binary(32) --> varbinary(512)
145 ************************************************************
146 ALTER TABLE t3 MODIFY c1 varchar(512), MODIFY b1 varbinary(512);
147 SELECT length(c1), length(b1) FROM t3;
148 length(c1) length(b1)
149 8 8
150 CREATE TABLE t3_myisam ENGINE=MYISAM AS SELECT * FROM t3;
151 DELETE FROM t3;
152 SELECT length(c1), length(b1) FROM t3;
153 length(c1) length(b1)
154 8 8
155 SELECT COUNT(*) FROM t3 NATURAL JOIN t3_myisam;
156 COUNT(*)
157 1
158 DROP TABLE t3_myisam;
159 ************************************************************
160 * Restoring table with demoted char+binary types discarding padding:
161 * char(32) --> varchar(16)
162 * binary(32) --> varbinary(16)
163 ************************************************************
164 ALTER TABLE t3 MODIFY c1 varchar(16), MODIFY b1 varbinary(16);
165 SELECT length(c1), length(b1) FROM t3;
166 length(c1) length(b1)
167 8 8
168 CREATE TABLE t3_myisam ENGINE=MYISAM AS SELECT * FROM t3;
169 DELETE FROM t3;
170 SELECT length(c1), length(b1) FROM t3;
171 length(c1) length(b1)
172 8 8
173 SELECT COUNT(*) FROM t3 NATURAL JOIN t3_myisam;
174 COUNT(*)
175 1
176 DROP TABLE t3_myisam;
177 ************************************************************
178 * Deleting table with char+binary types
179 ************************************************************
180 DROP TABLE t3;