Debian Codegraph @

mysql-test/suite/memcached/r/memc274_5_tables_uml.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 ("desct3", "test", "t3",
12 "c1", "c2,c21", "c3", "c4", "c5", "PRIMARY");
13 INSERT INTO containers VALUES ("desct4", "test", "t4",
14 "c1", "c2,c21,c22", "c3", "c4", "c5", "PRIMARY");
15 INSERT INTO containers VALUES ("desct5", "test", "t5",
16 "c1", "c2,c21,c22,c23", "c3", "c4", "c5", "PRIMARY");
17 USE test;
18 DROP TABLE IF EXISTS t1,t2;
19 CREATE TABLE t1 (c1 VARCHAR(32),
20 c2 VARCHAR(1024),
21 c21 VARCHAR(1024),
22 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
23 ENGINE = INNODB;
24 CREATE TABLE t2 (c1 VARCHAR(32),
25 c2 VARCHAR(1024),
26 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
27 ENGINE = INNODB;
28 CREATE TABLE t3 (c1 VARCHAR(32),
29 c2 VARCHAR(1024),
30 c21 VARCHAR(1024),
31 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
32 ENGINE = INNODB;
33 CREATE TABLE t4 (c1 VARCHAR(32),
34 c2 VARCHAR(1024),
35 c21 VARCHAR(1024),
36 c22 VARCHAR(1024),
37 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
38 ENGINE = INNODB;
39 CREATE TABLE t5 (c1 VARCHAR(32),
40 c2 VARCHAR(1024),
41 c21 VARCHAR(1024),
42 c22 VARCHAR(1024),
43 c23 VARCHAR(1024),
44 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
45 ENGINE = INNODB;
46 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City', 0, 0, 0);
47 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', 0, 0, 0);
48 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', 0, 0 ,0);
49 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Außenalster', 0, 0, 0);
50 INSERT INTO t2 VALUES ('D', 'Dortmund', 0, 0, 0);
51 INSERT INTO t2 VALUES ('B', 'Bremen', 0, 0, 0);
52 INSERT INTO t2 VALUES ('C', 'Celle', 0, 0 ,0);
53 INSERT INTO t2 VALUES ('H', 'Hannover', 0, 0, 0);
54 INSERT INTO t3 VALUES ('D', 'Detmold', 'City', 0, 0, 0);
55 INSERT INTO t3 VALUES ('B', 'Bonn', 'Mitte', 0, 0, 0);
56 INSERT INTO t3 VALUES ('A', 'Aachen', 'West', 0, 0 ,0);
57 INSERT INTO t3 VALUES ('H', 'Hameln', 'Nord', 0, 0, 0);
58 INSERT INTO t4 VALUES ('Z', 'Zossen', 'City', '12345', 0, 0, 0);
59 INSERT INTO t4 VALUES ('B', 'Brandenburg', 'Mitte', '23456', 0, 0, 0);
60 INSERT INTO t4 VALUES ('M', 'München', 'West', '34567', 0, 0 ,0);
61 INSERT INTO t4 VALUES ('H', 'Husum', 'Fähre', '45678', 0, 0, 0);
62 INSERT INTO t5 VALUES ('D', 'Düsseldorf', 'City', '98765', 'Hafen', 0, 0, 0);
63 INSERT INTO t5 VALUES ('O', 'Oldenburg', 'Mitte', '87654', 'Bäder', 0, 0, 0);
64 INSERT INTO t5 VALUES ('K', 'Köln', 'West', '76543', 'Rhein', 0, 0 ,0);
65 INSERT INTO t5 VALUES ('S', 'Stuttgart', 'Nord', '65432', 'Fernsehturm', 0, 0, 0);
66 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
67 Warnings:
68 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
69 SELECT c1,c2,c21 FROM t1;
70 c1 c2 c21
71 B Berlin Mitte
72 C Cottbus West
73 D Darmstadt City
74 H Hamburg Außenalster
75 SELECT c1,c2 FROM t2;
76 c1 c2
77 B Bremen
78 C Celle
79 D Dortmund
80 H Hannover
81 SELECT c1,c2,c21 FROM t3;
82 c1 c2 c21
83 A Aachen West
84 B Bonn Mitte
85 D Detmold City
86 H Hameln Nord
87 SELECT c1,c2,c21,c22 FROM t4;
88 c1 c2 c21 c22
89 B Brandenburg Mitte 23456
90 H Husum Fähre 45678
91 M München West 34567
92 Z Zossen City 12345
93 SELECT c1,c2,c21,c22,c23 FROM t5;
94 c1 c2 c21 c22 c23
95 D Düsseldorf City 98765 Hafen
96 K Köln West 76543 Rhein
97 O Oldenburg Mitte 87654 Bäder
98 S Stuttgart Nord 65432 Fernsehturm
99 Here are the memcached results with D,B,H,C of default:
100 Darmstadt|City
101 Berlin|Mitte
102 Hamburg|Außenalster
103 Cottbus|West
104 Here are the memcached results with D,B,H,C of t1:
105 Darmstadt|City
106 Berlin|Mitte
107 Hamburg|Außenalster
108 Cottbus|West
109 Here are the memcached results with D,B,H,C of t2:
110 Dortmund
111 Bremen
112 Hannover
113 Celle
114 Here are the memcached results with D,B,H,A of t3:
115 Detmold|City
116 Bonn|Mitte
117 Hameln|Nord
118 Aachen|West
119 Here are the memcached results with D,O,K,S of t5:
120 Düsseldorf|City|98765|Hafen
121 Oldenburg|Mitte|87654|Bäder
122 Köln|West|76543|Rhein
123 Stuttgart|Nord|65432|Fernsehturm
124 Here are the memcached results with Z,B,H,M of t4:
125 Zossen|City|12345
126 Brandenburg|Mitte|23456
127 Husum|Fähre|45678
128 München|West|34567
129 Here are the memcached results with D,B,H,C of t2:
130 Celle
131 SELECT c1,c2,c21 FROM t1;
132 c1 c2 c21
133 B Berlin Mitte
134 C Cottbus West
135 D Darmstadt City
136 H Hamburg Außenalster
137 SELECT c1,c2 FROM t2;
138 c1 c2
139 B Bremen
140 C Celle
141 D Dortmund
142 H Hannover
143 SELECT c1,c2,c21 FROM t3;
144 c1 c2 c21
145 A Aachen West
146 B Bonn Mitte
147 D Detmold City
148 H Hameln Nord
149 SELECT c1,c2,c21,c22 FROM t4;
150 c1 c2 c21 c22
151 B Brandenburg Mitte 23456
152 H Husum Fähre 45678
153 M München West 34567
154 Z Zossen City 12345
155 SELECT c1,c2,c21,c22,c23 FROM t5;
156 c1 c2 c21 c22 c23
157 D Düsseldorf City 98765 Hafen
158 K Köln West 76543 Rhein
159 O Oldenburg Mitte 87654 Bäder
160 S Stuttgart Nord 65432 Fernsehturm
161 Here are the memcached results after set in default:
162 Essen|Ost
163 Here are the memcached results after set in t2:
164 Essen
165 Here are the memcached results after set in t5:
166 Essen|Mitte|111111|Mahlzeit
167 Here are the memcached results after set in t3:
168 Essen|Ost
169 Here are the memcached results after set in t4:
170 Essen|Mitte|111111
171 Here are the memcached results after set in t5:
172 Essen|Außerhalb|111111|Mahlzeit
173 SELECT c1,c2,c21 FROM t1;
174 c1 c2 c21
175 B Berlin Mitte
176 C Cottbus West
177 D Darmstadt City
178 E Essen Ost
179 H Hamburg Außenalster
180 SELECT c1,c2 FROM t2;
181 c1 c2
182 B Bremen
183 C Celle
184 D Dortmund
185 E Essen
186 H Hannover
187 SELECT c1,c2,c21 FROM t3;
188 c1 c2 c21
189 A Aachen West
190 B Bonn Mitte
191 D Detmold City
192 E Essen Ost
193 H Hameln Nord
194 SELECT c1,c2,c21,c22 FROM t4;
195 c1 c2 c21 c22
196 B Brandenburg Mitte 23456
197 E Essen Mitte 111111
198 H Husum Fähre 45678
199 M München West 34567
200 Z Zossen City 12345
201 SELECT c1,c2,c21,c22,c23 FROM t5;
202 c1 c2 c21 c22 c23
203 D Düsseldorf City 98765 Hafen
204 E Essen Außerhalb 111111 Mahlzeit
205 K Köln West 76543 Rhein
206 O Oldenburg Mitte 87654 Bäder
207 S Stuttgart Nord 65432 Fernsehturm
208 DROP TABLE t1,t2,t3,t4,t5;
209 UNINSTALL PLUGIN daemon_memcached;
210 DROP DATABASE innodb_memcache;
211 SET @@global.transaction_isolation= @transaction_isolation;