Debian Codegraph @

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

raw
1 call mtr.add_suppression("Cannot add field ");
2 SET @transaction_isolation= @@global.transaction_isolation;
3 SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
4 SET sql_mode='NO_ENGINE_SUBSTITUTION';
5 INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
6 "innodb_only", "innodb_only", "innodb_only");
7 INSERT INTO config_options VALUES("separator", ",");
8 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
9 "c1",
10 "c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
11 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
12 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
13 c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
14 c240,c241,c242,c243,c244,c245,c246,c247,c248,c249",
15 "c3", "c4", "c5", "PRIMARY");
16 Warnings:
17 Warning 1265 Data truncated for column 'value_columns' at row 1
18 SELECT * FROM containers;
19 name db_schema db_table key_columns value_columns flags cas_column expire_time_column unique_idx_name_on_key
20 desc_t1 test t1 c1 c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
21 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
22 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
23 c c3 c4 c5 PRIMARY
24 DELETE FROM containers;
25 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
26 "c1",
27 "c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
28 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
29 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229",
30 "c3", "c4", "c5", "PRIMARY");
31 USE test;
32 SET innodb_strict_mode=OFF;
33 CREATE TABLE t1 (c1 VARCHAR(32),
34 c200 VARCHAR(40),
35 c201 VARCHAR(40),
36 c202 VARCHAR(40),
37 c203 VARCHAR(40),
38 c204 VARCHAR(40),
39 c205 VARCHAR(40),
40 c206 VARCHAR(40),
41 c207 VARCHAR(40),
42 c208 VARCHAR(40),
43 c209 VARCHAR(40),
44 c210 VARCHAR(40),
45 c211 VARCHAR(40),
46 c212 VARCHAR(40),
47 c213 VARCHAR(40),
48 c214 VARCHAR(40),
49 c215 VARCHAR(40),
50 c216 VARCHAR(40),
51 c217 VARCHAR(40),
52 c218 VARCHAR(40),
53 c219 VARCHAR(40),
54 c220 VARCHAR(40),
55 c221 VARCHAR(40),
56 c222 VARCHAR(40),
57 c223 VARCHAR(40),
58 c224 VARCHAR(40),
59 c225 VARCHAR(40),
60 c226 VARCHAR(40),
61 c227 VARCHAR(40),
62 c228 VARCHAR(40),
63 c229 VARCHAR(40),
64 c230 VARCHAR(40),
65 c231 VARCHAR(40),
66 c232 VARCHAR(40),
67 c233 VARCHAR(40),
68 c234 VARCHAR(40),
69 c235 VARCHAR(40),
70 c236 VARCHAR(40),
71 c237 VARCHAR(40),
72 c238 VARCHAR(40),
73 c239 VARCHAR(40),
74 c240 VARCHAR(40),
75 c241 VARCHAR(40),
76 c242 VARCHAR(40),
77 c243 VARCHAR(40),
78 c244 VARCHAR(40),
79 c245 VARCHAR(40),
80 c246 VARCHAR(40),
81 c247 VARCHAR(40),
82 c248 VARCHAR(40),
83 c249 VARCHAR(40),
84 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
85 ROW_FORMAT=COMPACT ENGINE = INNODB;
86 INSERT INTO t1 VALUES ('1',
87 'c200','c201','c202','c203','c204','c205','c206','c207','c208','c209',
88 'c210','c211','c212','c213','c214','c215','c216','c217','c218','c219',
89 'c220','c221','c222','c223','c224','c225','c226','c227','c228','c229',
90 'c230','c231','c232','c233','c234','c235','c236','c237','c238','c239',
91 'c240','c241','c242','c243','c244','c245','c246','c247','c248','c249',
92 0, 0, 0);
93 INSERT INTO t1 VALUES ('2',
94 'c200','c201','c202','c203','c204','c205','c206','c207','c208','c209',
95 'c210','c211','c212','c213','c214','c215','c216','c217','c218','c219',
96 'c220','c221','c222','c223','c224','c225','c226','c227','c228','c229',
97 'c230','c231','c232','c233','c234','c235','c236','c237','c238','c239',
98 'c240','c241','c242','c243','c244','c245','c246','c247','c248','c249',
99 0, 0, 0);
100 INSERT INTO t1 VALUES ('3',
101 'c200','c201','c202','c203','c204','c205','c206','c207','c208','c209',
102 'c210','c211','c212','c213','c214','c215','c216','c217','c218','c219',
103 'c220','c221','c222','c223','c224','c225','c226','c227','c228','c229',
104 'c230','c231','c232','c233','c234','c235','c236','c237','c238','c239',
105 'c240','c241','c242','c243','c244','c245','c246','c247','c248','c249',
106 0, 0, 0);
107 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
108 Warnings:
109 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
110 SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
111 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
112 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
113 c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
114 c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
115 FROM t1;
116 c1 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
117 1 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
118 2 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
119 3 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
120 Here are the memcached results:
121 c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,c220,c221,c222,c223,c224,c225,c226,c227,c228,c229
122 c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,c220,c221,c222,c223,c224,c225,c226,c227,c228,c229
123 c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,c220,c221,c222,c223,c224,c225,c226,c227,c228,c229
124 SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
125 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
126 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
127 c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
128 c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
129 FROM t1;
130 c1 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
131 1 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
132 2 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
133 3 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
134 Here are the memcached results after set:
135 c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,c220,c221,c222,c223,c224,c225,c226,c227,c228,c229
136 SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
137 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
138 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
139 c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
140 c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
141 FROM t1;
142 c1 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
143 1 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
144 2 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
145 3 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
146 4 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
147 Here are the memcached results after set:
148 c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
149 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
150 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229
151 SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
152 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
153 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
154 c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
155 c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
156 FROM t1;
157 c1 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
158 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219
159 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
160 1 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
161 2 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
162 3 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
163 4 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209
164 Here are the memcached results after set:
165 c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
166 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
167 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229
168 SELECT c1,c200,c201,c202,c203,c204,c205,c206,c207,c208,c209,
169 c210,c211,c212,c213,c214,c215,c216,c217,c218,c219,
170 c220,c221,c222,c223,c224,c225,c226,c227,c228,c229,
171 c230,c231,c232,c233,c234,c235,c236,c237,c238,c239,
172 c240,c241,c242,c243,c244,c245,c246,c247,c248,c249
173 FROM t1;
174 c1 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
175 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219
176 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
177 1 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
178 2 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
179 3 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249
180 4 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209
181 DROP TABLE t1;
182 SET sql_mode=default;
183 UNINSTALL PLUGIN daemon_memcached;
184 DROP DATABASE innodb_memcache;
185 SET @@global.transaction_isolation= @transaction_isolation;