Debian Codegraph @

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

raw
1 Warnings:
2 Warning 1287 '@@new' is deprecated and will be removed in a future release.
3 drop table if exists t1;
4 create table t1 (
5 a int not null,
6 b text not null,
7 c int not null,
8 d blob,
9 e int not null,
10 primary key (a, c),
11 unique key (c, e)
12 )
13 engine=ndb
14 partition by range (c)
15 partitions 3
16 ( partition p1 values less than (2),
17 partition p2 values less than (3),
18 partition p3 values less than (4));
19 insert into t1 values (1, @x1, 1, @x2, 1);
20 insert into t1 values (1, @y1, 2, @y2, 1);
21 insert into t1 values (1, @z1, 3, @z2, 1);
22 insert into t1 values (2, @x1, 1, @x2, 2);
23 insert into t1 values (2, @y1, 2, @y2, 2);
24 insert into t1 values (2, @z1, 3, @z2, 2);
25 insert into t1 values (3, @x1, 1, @x2, 3);
26 insert into t1 values (3, @y1, 2, @y2, 3);
27 insert into t1 values (3, @z1, 3, @z2, 3);
28 select a, c, sha1(b), sha1(d) from t1 order by a, c;
29 a c sha1(b) sha1(d)
30 1 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
31 1 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
32 1 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
33 2 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
34 2 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
35 2 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
36 3 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
37 3 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
38 3 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
39 select a, c, sha1(b), sha1(d) from t1 where a = 1 and c = 1;
40 a c sha1(b) sha1(d)
41 1 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
42 select a, c, sha1(b), sha1(d) from t1 where a = 1 and c = 2;
43 a c sha1(b) sha1(d)
44 1 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
45 select a, c, sha1(b), sha1(d) from t1 where a = 1 and c = 3;
46 a c sha1(b) sha1(d)
47 1 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
48 update t1 set b = @y1, d = @y2 where a = 2 and c = 1;
49 update t1 set b = @z1, d = @z2 where a = 2 and c = 2;
50 update t1 set b = @x1, d = @x2 where a = 2 and c = 3;
51 select a, c, sha1(b), sha1(d) from t1 order by a, c;
52 a c sha1(b) sha1(d)
53 1 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
54 1 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
55 1 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
56 2 1 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
57 2 2 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
58 2 3 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
59 3 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
60 3 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
61 3 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
62 update t1 set b = @y1, d = @y2 where c = 1 and e = 3;
63 update t1 set b = @z1, d = @z2 where c = 2 and e = 3;
64 update t1 set b = @x1, d = @x2 where c = 3 and e = 3;
65 select a, c, sha1(b), sha1(d) from t1 order by a, c;
66 a c sha1(b) sha1(d)
67 1 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
68 1 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
69 1 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
70 2 1 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
71 2 2 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
72 2 3 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
73 3 1 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
74 3 2 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
75 3 3 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
76 update t1 set b = @x1, d = @x2;
77 select a, c, sha1(b), sha1(d) from t1 order by a, c;
78 a c sha1(b) sha1(d)
79 1 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
80 1 2 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
81 1 3 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
82 2 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
83 2 2 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
84 2 3 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
85 3 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
86 3 2 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
87 3 3 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
88 update t1 set b = @x1, d = @x2 where c = 1;
89 update t1 set b = @y1, d = @y2 where c = 2;
90 update t1 set b = @z1, d = @z2 where c = 3;
91 select a, c, sha1(b), sha1(d) from t1 order by a, c;
92 a c sha1(b) sha1(d)
93 1 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
94 1 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
95 1 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
96 2 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
97 2 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
98 2 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
99 3 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
100 3 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
101 3 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
102 delete from t1 where a = 1 and c = 1;
103 select a, c, sha1(b), sha1(d) from t1 order by a, c;
104 a c sha1(b) sha1(d)
105 1 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
106 1 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
107 2 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
108 2 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
109 2 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
110 3 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
111 3 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
112 3 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
113 delete from t1 where c = 2 and e = 2;
114 select a, c, sha1(b), sha1(d) from t1 order by a, c;
115 a c sha1(b) sha1(d)
116 1 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
117 1 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
118 2 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
119 2 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
120 3 1 1d42dd9090cf78314a06665d4ea938c35cc760f4 10d3c783026b310218d10b7188da96a2401648c6
121 3 2 a33549d9844092289a58ac348dd59f09fc28406a daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
122 3 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
123 delete from t1 where c < 3;
124 select a, c, sha1(b), sha1(d) from t1 order by a, c;
125 a c sha1(b) sha1(d)
126 1 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
127 2 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
128 3 3 70fc9a7d08beebc522258bfb02000a30c77a8f1d 090565c580809efed3d369481a4bbb168b20713e
129 delete from t1;
130 select a, c, sha1(b), sha1(d) from t1 order by a, c;
131 a c sha1(b) sha1(d)
132 drop table t1;
133 create table t1 (
134 a char(4),
135 b int,
136 primary key (a, b)
137 )
138 engine=ndb
139 character set latin1
140 partition by key (a)
141 partitions 4;
142 insert into t1 values ('aaa',1);
143 insert into t1 values ('bbb',1);
144 insert into t1 values ('bbb',2);
145 select count(*) from t1 where a = 'aaa';
146 count(*)
147 1
148 select count(*) from t1 where a = 'Aaa';
149 count(*)
150 1
151 select count(*) from t1 where a = 'aAa';
152 count(*)
153 1
154 select count(*) from t1 where a = 'aaA';
155 count(*)
156 1
157 select count(*) from t1 where a = 'AAa';
158 count(*)
159 1
160 select count(*) from t1 where a = 'AaA';
161 count(*)
162 1
163 select count(*) from t1 where a = 'aAA';
164 count(*)
165 1
166 select count(*) from t1 where a = 'AAA';
167 count(*)
168 1
169 drop table t1;
170 create table t1 (
171 a varbinary(10),
172 b int,
173 primary key (a, b)
174 )
175 engine=ndb
176 character set latin1
177 partition by key (a)
178 partitions 4;
179 insert into t1 values ('aaa',1);
180 insert into t1 values ('aaabbb',1);
181 insert into t1 values ('aaabbb',2);
182 insert into t1 values ('aaabbbccc',1);
183 insert into t1 values ('aaabbbccc',2);
184 insert into t1 values ('aaabbbccc',3);
185 select count(*) from t1 where a = 'aaa';
186 count(*)
187 1
188 select count(*) from t1 where a = 'Aaa';
189 count(*)
190 0
191 select count(*) from t1 where a = 'aaabbb';
192 count(*)
193 2
194 select count(*) from t1 where a = 'aaaBbb';
195 count(*)
196 0
197 select count(*) from t1 where a = 'aaabbbccc';
198 count(*)
199 3
200 select count(*) from t1 where a = 'aaabbbCcc';
201 count(*)
202 0
203 drop table t1;