Debian Codegraph @

mysql-test/suite/memcached/r/memc272_2_tables.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 USE test;
12 DROP TABLE IF EXISTS t1,t2;
13 CREATE TABLE t1 (c1 VARCHAR(32),
14 c2 VARCHAR(1024),
15 c21 VARCHAR(1024),
16 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
17 ENGINE = INNODB;
18 CREATE TABLE t2 (c1 VARCHAR(32),
19 c2 VARCHAR(1024),
20 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
21 ENGINE = INNODB;
22 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City', 0, 0, 0);
23 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', 0, 0, 0);
24 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', 0, 0 ,0);
25 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', 0, 0, 0);
26 INSERT INTO t2 VALUES ('D', 'Dortmund', 0, 0, 0);
27 INSERT INTO t2 VALUES ('B', 'Bremen', 0, 0, 0);
28 INSERT INTO t2 VALUES ('C', 'Celle', 0, 0 ,0);
29 INSERT INTO t2 VALUES ('H', 'Hannover', 0, 0, 0);
30 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
31 Warnings:
32 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
33 SELECT c1,c2,c21 FROM t1;
34 c1 c2 c21
35 B Berlin Mitte
36 C Cottbus West
37 D Darmstadt City
38 H Hamburg Norderstedt
39 SELECT c1,c2 FROM t2;
40 c1 c2
41 B Bremen
42 C Celle
43 D Dortmund
44 H Hannover
45 Here are the memcached results with D,B,H,C of default:
46 Darmstadt|City
47 Berlin|Mitte
48 Hamburg|Norderstedt
49 Cottbus|West
50 Here are the memcached results with D,B,H,C of t2:
51 Dortmund
52 Bremen
53 Hannover
54 SELECT c1,c2,c21 FROM t1;
55 c1 c2 c21
56 B Berlin Mitte
57 C Cottbus West
58 D Darmstadt City
59 H Hamburg Norderstedt
60 SELECT c1,c2 FROM t2;
61 c1 c2
62 B Bremen
63 C Celle
64 D Dortmund
65 H Hannover
66 Here are the memcached results after set in default:
67 Essen|Ost
68 Here are the memcached results after set in t2:
69 Essen
70 SELECT c1,c2,c21 FROM t1;
71 c1 c2 c21
72 B Berlin Mitte
73 C Cottbus West
74 D Darmstadt City
75 E Essen Ost
76 H Hamburg Norderstedt
77 SELECT c1,c2 FROM t2;
78 c1 c2
79 B Bremen
80 C Celle
81 D Dortmund
82 E Essen
83 H Hannover
84 Here are the memcached results after add:
85 Frankfurt|Sachsenhause
86 Here are the memcached results after add in t2:
87 SELECT c1,c2,c21 FROM t1;
88 c1 c2 c21
89 B Berlin Mitte
90 C Cottbus West
91 D Darmstadt City
92 E Essen Ost
93 F Frankfurt Sachsenhause
94 H Hamburg Norderstedt
95 SELECT c1,c2 FROM t2;
96 c1 c2
97 B Bremen
98 C Celle
99 D Dortmund
100 E Essen
101 H Hannover
102 Here are the memcached results after replace:
103 Frankfurt a. M.|Sachsenhausen
104 Here are the memcached results after replace in t2:
105 SELECT c1,c2,c21 FROM t1;
106 c1 c2 c21
107 B Berlin Mitte
108 C Cottbus West
109 D Darmstadt City
110 E Essen Ost
111 F Frankfurt a. M. Sachsenhausen
112 H Hamburg Norderstedt
113 SELECT c1,c2 FROM t2;
114 c1 c2
115 B Bremen
116 C Celle
117 D Dortmund
118 E Essen
119 H Hannover
120 Here are the memcached results after delete:
121 Here are the memcached results after delete in t2:
122 SELECT c1,c2,c21 FROM t1;
123 c1 c2 c21
124 B Berlin Mitte
125 C Cottbus West
126 D Darmstadt City
127 E Essen Ost
128 H Hamburg Norderstedt
129 SELECT c1,c2 FROM t2;
130 c1 c2
131 B Bremen
132 C Celle
133 D Dortmund
134 E Essen
135 H Hannover
136 Here are the memcached results after add Frankfurt|:
137 Frankfurt|
138 Here are the memcached results after add |Airport:
139 Frankfurt|
140 SELECT c1,c2,c21 FROM t1;
141 c1 c2 c21
142 B Berlin Mitte
143 C Cottbus West
144 D Darmstadt City
145 E Essen Ost
146 F Frankfurt NULL
147 H Hamburg Norderstedt
148 SELECT c1,c2 FROM t2;
149 c1 c2
150 B Bremen
151 C Celle
152 D Dortmund
153 E Essen
154 H Hannover
155 Here are the memcached results after replace Frankfurt a.M.:
156 Frankfurt a. M.|
157 Here are the memcached results after replace Sachsenhausen:
158 |Sachsenhausen
159 SELECT c1,c2,c21 FROM t1;
160 c1 c2 c21
161 B Berlin Mitte
162 C Cottbus West
163 D Darmstadt City
164 E Essen Ost
165 F NULL Sachsenhausen
166 H Hamburg Norderstedt
167 SELECT c1,c2 FROM t2;
168 c1 c2
169 B Bremen
170 C Celle
171 D Dortmund
172 E Essen
173 H Hannover
174 SET sql_mode='NO_ENGINE_SUBSTITUTION';
175 ALTER TABLE t1 MODIFY c2 int;
176 Warnings:
177 Warning 1366 Incorrect integer value: 'Berlin' for column 'c2' at row 1
178 Warning 1366 Incorrect integer value: 'Cottbus' for column 'c2' at row 2
179 Warning 1366 Incorrect integer value: 'Darmstadt' for column 'c2' at row 3
180 Warning 1366 Incorrect integer value: 'Essen' for column 'c2' at row 4
181 Warning 1366 Incorrect integer value: 'Hamburg' for column 'c2' at row 6
182 SET sql_mode=default;
183 SELECT c1,c2,c21 FROM t1;
184 c1 c2 c21
185 B 0 Mitte
186 C 0 West
187 D 0 City
188 E 0 Ost
189 F NULL Sachsenhausen
190 H 0 Norderstedt
191 Here are the memcached results after add Frankfurt|:
192 |Sachsenhausen
193 Here are the memcached results after add |Airport:
194 |Sachsenhausen
195 SELECT c1,c2,c21 FROM t1;
196 c1 c2 c21
197 B 0 Mitte
198 C 0 West
199 D 0 City
200 E 0 Ost
201 F NULL Sachsenhausen
202 H 0 Norderstedt
203 Here are the memcached results after flush_all:
204 SELECT c1,c2,c21 FROM t1;
205 c1 c2 c21
206 DROP TABLE t1,t2;
207 UNINSTALL PLUGIN daemon_memcached;
208 DROP DATABASE innodb_memcache;
209 SET @@global.transaction_isolation= @transaction_isolation;