Debian Codegraph @

mysql-test/suite/memcached/r/memc278_view.result

raw
1 SET @transaction_isolation= @@global.transaction_isolation;
2 SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
3 INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
4 "innodb_only", "innodb_only", "innodb_only");
5 INSERT INTO config_options VALUES("separator", "|");
6 INSERT INTO config_options VALUES("table_map_delimiter", ".");
7 INSERT INTO containers VALUES ("desct1", "test", "t1",
8 "c1", "c2,c21", "c3", "c4", "c5", "PRIMARY");
9 INSERT INTO containers VALUES ("desct2", "test", "t2",
10 "c1", "c2", "c3", "c4", "c5", "PRIMARY");
11 INSERT INTO containers VALUES ("desc_v1", "test", "v1",
12 "vc1", "vc2,vc21", "vc3", "vc4", "vc5", "PRIMARY");
13 INSERT INTO containers VALUES ("desct3", "test", "t3",
14 "c1", "c2,c21", "c3", "c4", "c5", "PRIMARY");
15 INSERT INTO containers VALUES ("desct4", "test", "t4",
16 "c1", "c2,c21,c22", "c3", "c4", "c5", "PRIMARY");
17 INSERT INTO containers VALUES ("desct5", "test", "t5",
18 "c1", "c2,c21,c22,c23", "c3", "c4", "c5", "PRIMARY");
19 USE test;
20 DROP TABLE IF EXISTS t1,t2;
21 CREATE TABLE t1 (c1 VARCHAR(32),
22 c2 VARCHAR(1024),
23 c21 VARCHAR(1024),
24 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
25 ENGINE = INNODB;
26 CREATE TABLE t2 (c1 VARCHAR(32),
27 c2 VARCHAR(1024),
28 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
29 ENGINE = INNODB;
30 CREATE TABLE t3 (c1 VARCHAR(32),
31 c2 VARCHAR(1024),
32 c21 VARCHAR(1024),
33 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
34 ENGINE = INNODB;
35 CREATE TABLE t4 (c1 VARCHAR(32),
36 c2 VARCHAR(1024),
37 c21 VARCHAR(1024),
38 c22 VARCHAR(1024),
39 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
40 ENGINE = INNODB;
41 CREATE TABLE t5 (c1 VARCHAR(32),
42 c2 VARCHAR(1024),
43 c21 VARCHAR(1024),
44 c22 VARCHAR(1024),
45 c23 VARCHAR(1024),
46 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
47 ENGINE = INNODB;
48 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City', 0, 0, 0);
49 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', 0, 0, 0);
50 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', 0, 0 ,0);
51 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', 0, 0, 0);
52 INSERT INTO t2 VALUES ('D', 'Dortmund', 0, 0, 0);
53 INSERT INTO t2 VALUES ('B', 'Bremen', 0, 0, 0);
54 INSERT INTO t2 VALUES ('C', 'Celle', 0, 0 ,0);
55 INSERT INTO t2 VALUES ('H', 'Hannover', 0, 0, 0);
56 INSERT INTO t3 VALUES ('D', 'Detmold', 'City', 0, 0, 0);
57 INSERT INTO t3 VALUES ('B', 'Bonn', 'Mitte', 0, 0, 0);
58 INSERT INTO t3 VALUES ('A', 'Aachen', 'West', 0, 0 ,0);
59 INSERT INTO t3 VALUES ('H', 'Hameln', 'Nord', 0, 0, 0);
60 INSERT INTO t4 VALUES ('Z', 'Zossen', 'City', '12345', 0, 0, 0);
61 INSERT INTO t4 VALUES ('B', 'Brandenburg', 'Mitte', '23456', 0, 0, 0);
62 INSERT INTO t4 VALUES ('M', 'Muenchen', 'West', '34567', 0, 0 ,0);
63 INSERT INTO t4 VALUES ('H', 'Husum', 'Nord', '45678', 0, 0, 0);
64 INSERT INTO t5 VALUES ('D', 'Duesseldorf', 'City', '98765', 'Hafen', 0, 0, 0);
65 INSERT INTO t5 VALUES ('O', 'Oldenburg', 'Mitte', '87654', 'Deich', 0, 0, 0);
66 INSERT INTO t5 VALUES ('K', 'Koeln', 'West', '76543', 'Rhein', 0, 0 ,0);
67 INSERT INTO t5 VALUES ('S', 'Stuttgart', 'Nord', '65432', 'Fernsehturm', 0, 0, 0);
68 CREATE VIEW v1 AS SELECT t1.c1 AS vc1,t1.c2 AS vc2,t3.c21 AS vc21,
69 t1.c3 AS vc3,t1.c4 AS vc4,t1.c5 AS vc5 FROM t1,t3 WHERE t1.c1=t3.c1;
70 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
71 Warnings:
72 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
73 SELECT c1,c2,c21 FROM t1;
74 c1 c2 c21
75 B Berlin Mitte
76 C Cottbus West
77 D Darmstadt City
78 H Hamburg Norderstedt
79 SELECT c1,c2 FROM t2;
80 c1 c2
81 B Bremen
82 C Celle
83 D Dortmund
84 H Hannover
85 SELECT c1,c2,c21 FROM t3;
86 c1 c2 c21
87 A Aachen West
88 B Bonn Mitte
89 D Detmold City
90 H Hameln Nord
91 SELECT c1,c2,c21,c22 FROM t4;
92 c1 c2 c21 c22
93 B Brandenburg Mitte 23456
94 H Husum Nord 45678
95 M Muenchen West 34567
96 Z Zossen City 12345
97 SELECT c1,c2,c21,c22,c23 FROM t5;
98 c1 c2 c21 c22 c23
99 D Duesseldorf City 98765 Hafen
100 K Koeln West 76543 Rhein
101 O Oldenburg Mitte 87654 Deich
102 S Stuttgart Nord 65432 Fernsehturm
103 Here are the memcached results with D,B,H,C of default:
104 Darmstadt|City
105 Berlin|Mitte
106 Hamburg|Norderstedt
107 Cottbus|West
108 Here are the memcached results with D,B,H,C of t1:
109 Darmstadt|City
110 Berlin|Mitte
111 Hamburg|Norderstedt
112 Cottbus|West
113 Here are the memcached results with D,B,H,C of t2:
114 Dortmund
115 Bremen
116 Hannover
117 Celle
118 Here are the memcached results with D,B,H,A of t3:
119 Detmold|City
120 Bonn|Mitte
121 Hameln|Nord
122 Aachen|West
123 Here are the memcached results with D,O,K,S of t5:
124 Duesseldorf|City|98765|Hafen
125 Oldenburg|Mitte|87654|Deich
126 Koeln|West|76543|Rhein
127 Stuttgart|Nord|65432|Fernsehturm
128 Here are the memcached results with Z,B,H,M of t4:
129 Zossen|City|12345
130 Brandenburg|Mitte|23456
131 Husum|Nord|45678
132 Muenchen|West|34567
133 Here are the memcached results with D,B,H,C of t2:
134 Dortmund
135 Bremen
136 Hannover
137 Celle
138 SELECT c1,c2,c21 FROM t1;
139 c1 c2 c21
140 B Berlin Mitte
141 C Cottbus West
142 D Darmstadt City
143 H Hamburg Norderstedt
144 SELECT c1,c2 FROM t2;
145 c1 c2
146 B Bremen
147 C Celle
148 D Dortmund
149 H Hannover
150 SELECT c1,c2,c21 FROM t3;
151 c1 c2 c21
152 A Aachen West
153 B Bonn Mitte
154 D Detmold City
155 H Hameln Nord
156 SELECT c1,c2,c21,c22 FROM t4;
157 c1 c2 c21 c22
158 B Brandenburg Mitte 23456
159 H Husum Nord 45678
160 M Muenchen West 34567
161 Z Zossen City 12345
162 SELECT c1,c2,c21,c22,c23 FROM t5;
163 c1 c2 c21 c22 c23
164 D Duesseldorf City 98765 Hafen
165 K Koeln West 76543 Rhein
166 O Oldenburg Mitte 87654 Deich
167 S Stuttgart Nord 65432 Fernsehturm
168 SELECT vc1,vc2,vc21 FROM v1;
169 vc1 vc2 vc21
170 B Berlin Mitte
171 D Darmstadt City
172 H Hamburg Nord
173 Here are the memcached results with D,B,H,C of view v1:
174 Here are the memcached results after set to view v1:
175 SELECT vc1,vc2,vc21 FROM v1;
176 vc1 vc2 vc21
177 B Berlin Mitte
178 D Darmstadt City
179 H Hamburg Nord
180 Here are the memcached results after set in default:
181 Essen|Ost
182 Here are the memcached results after set in t2:
183 Essen
184 Here are the memcached results after set in t5:
185 Essen|Mitte|111111|Mahlzeit
186 Here are the memcached results after set in t3:
187 Essen|Ost
188 Here are the memcached results after set in t4:
189 Essen|Mitte|111111
190 Here are the memcached results after set in t5:
191 Essen|Aussen|111111|Mahlzeit
192 SELECT vc1,vc2,vc21 FROM v1;
193 vc1 vc2 vc21
194 B Berlin Mitte
195 D Darmstadt City
196 E Essen Ost
197 H Hamburg Nord
198 SELECT c1,c2,c21 FROM t1;
199 c1 c2 c21
200 B Berlin Mitte
201 C Cottbus West
202 D Darmstadt City
203 E Essen Ost
204 H Hamburg Norderstedt
205 SELECT c1,c2 FROM t2;
206 c1 c2
207 B Bremen
208 C Celle
209 D Dortmund
210 E Essen
211 H Hannover
212 SELECT c1,c2,c21 FROM t3;
213 c1 c2 c21
214 A Aachen West
215 B Bonn Mitte
216 D Detmold City
217 E Essen Ost
218 H Hameln Nord
219 SELECT c1,c2,c21,c22 FROM t4;
220 c1 c2 c21 c22
221 B Brandenburg Mitte 23456
222 E Essen Mitte 111111
223 H Husum Nord 45678
224 M Muenchen West 34567
225 Z Zossen City 12345
226 SELECT c1,c2,c21,c22,c23 FROM t5;
227 c1 c2 c21 c22 c23
228 D Duesseldorf City 98765 Hafen
229 E Essen Aussen 111111 Mahlzeit
230 K Koeln West 76543 Rhein
231 O Oldenburg Mitte 87654 Deich
232 S Stuttgart Nord 65432 Fernsehturm
233 DROP VIEW v1;
234 DROP TABLE t1,t2,t3,t4,t5;
235 UNINSTALL PLUGIN daemon_memcached;
236 DROP DATABASE innodb_memcache;
237 SET @@global.transaction_isolation= @transaction_isolation;