Debian Codegraph @

mysql-test/suite/memcached/r/memc213_2_intcols.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 containers VALUES ("desc_t1", "test", "t1",
7 "c1", "c2,c21", "c3", "c4", "c5", "PRIMARY");
8 INSERT INTO containers VALUES ("int_test", "test", "int_test",
9 "k", "v", "", "", "", "PRIMARY");
10 USE test;
11 DROP TABLE IF EXISTS int_test;
12 DROP TABLE IF EXISTS t1;
13 CREATE TABLE t1 (c1 VARCHAR(32),
14 c2 INT,
15 c21 VARCHAR(1024),
16 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
17 ENGINE = INNODB;
18 CREATE TABLE int_test (k varchar(32),
19 v int unsigned NOT NULL, PRIMARY KEY (k)) ENGINE=InnoDB;
20 INSERT INTO t1 VALUES ('D', 1, 'City', 0, 0, 0);
21 INSERT INTO t1 VALUES ('B', 2, 'Mitte', 0, 0, 0);
22 INSERT INTO t1 VALUES ('C', 3, 'West', 0, 0 ,0);
23 INSERT INTO t1 VALUES ('H', 4, 'Norderstedt', 0, 0, 0);
24 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
25 Warnings:
26 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
27 SELECT c1,c2,c21 FROM t1;
28 c1 c2 c21
29 B 2 Mitte
30 C 3 West
31 D 1 City
32 H 4 Norderstedt
33 Here are the memcached results with D,B,H,C:
34 1|City
35 2|Mitte
36 4|Norderstedt
37 3|West
38 SELECT c1,c2,c21 FROM t1;
39 c1 c2 c21
40 B 2 Mitte
41 C 3 West
42 D 1 City
43 H 4 Norderstedt
44 Here are the memcached results after set:
45 5|Ost
46 Here are the memcached results after set min border:
47 -2147483648|Ost
48 Here are the memcached results after set max border:
49 2147483647|Ost
50 Here are the memcached results after set over max border:
51 -2147483648|Ost
52 SELECT c1,c2,c21 FROM t1;
53 c1 c2 c21
54 B 2 Mitte
55 C 3 West
56 D 1 City
57 E -2147483648 Ost
58 H 4 Norderstedt
59 Here are the memcached results after set:
60 6|Sofia
61 Here are the memcached results after calling incr 10:
62 16|
63 Here are the memcached results after calling decr 4:
64 12|
65 SELECT c1,c2,c21 FROM t1;
66 c1 c2 c21
67 B 2 Mitte
68 C 3 West
69 D 1 City
70 E -2147483648 Ost
71 H 4 Norderstedt
72 ALTER TABLE t1 MODIFY c2 varchar(20);
73 Here are the memcached results with D,B,H,C:
74 1|City
75 2|Mitte
76 4|Norderstedt
77 3|West
78 Here are the memcached results after set:
79 5|Ost-VARCHAR
80 SELECT c1,c2,c21 FROM t1;
81 c1 c2 c21
82 B 2 Mitte
83 C 3 West
84 D 1 City
85 E 5 Ost-VARCHAR
86 H 4 Norderstedt
87 ALTER TABLE t1 MODIFY c2 BIGINT;
88 Here are the memcached results with D,B,H,C:
89 1|City
90 2|Mitte
91 4|Norderstedt
92 3|West
93 Here are the memcached results after set:
94 5|Ost-BIGINT
95 Here are the memcached results after set min border:
96 -9223372036854775808|Ost
97 Here are the memcached results after set max border:
98 9223372036854775807|Ost
99 Here are the memcached results after set over max border:
100 9223372036854775807|Ost
101 Here are the memcached results after add:
102 -1|Beijing-Signed-BIGINT
103 SELECT c1,c2,c21 FROM t1;
104 c1 c2 c21
105 B 2 Mitte
106 C 3 West
107 D 1 City
108 E 9223372036854775807 Ost
109 F -1 Beijing-Signed-BIGINT
110 H 4 Norderstedt
111 SET sql_mode='NO_ENGINE_SUBSTITUTION';
112 ALTER TABLE t1 MODIFY c2 SMALLINT;
113 Warnings:
114 Warning 1264 Out of range value for column 'c2' at row 4
115 Here are the memcached results with D,B,H,C:
116 1|City
117 2|Mitte
118 4|Norderstedt
119 3|West
120 Here are the memcached results after set:
121 5|Ost-SMALLINT
122 Here are the memcached results after set min border:
123 -32768|Ost
124 Here are the memcached results after set max border:
125 32767|Ost
126 Here are the memcached results after set over max border:
127 -32768|Ost
128 SELECT c1,c2,c21 FROM t1;
129 c1 c2 c21
130 B 2 Mitte
131 C 3 West
132 D 1 City
133 E -32768 Ost
134 F -1 Beijing-Signed-BIGINT
135 H 4 Norderstedt
136 ALTER TABLE t1 MODIFY c2 TINYINT;
137 Warnings:
138 Warning 1264 Out of range value for column 'c2' at row 4
139 Here are the memcached results with D,B,H,C:
140 1|City
141 2|Mitte
142 4|Norderstedt
143 3|West
144 Here are the memcached results after set:
145 5|Ost-TINYINT
146 Here are the memcached results after set min border:
147 -128|Ost
148 Here are the memcached results after set max border:
149 127|Ost
150 Here are the memcached results after set over max border:
151 -127|Ost
152 SELECT c1,c2,c21 FROM t1;
153 c1 c2 c21
154 B 2 Mitte
155 C 3 West
156 D 1 City
157 E -127 Ost
158 F -1 Beijing-Signed-BIGINT
159 H 4 Norderstedt
160 ALTER TABLE t1 MODIFY c2 BIGINT UNSIGNED;
161 Warnings:
162 Warning 1264 Out of range value for column 'c2' at row 4
163 Warning 1264 Out of range value for column 'c2' at row 5
164 Here are the memcached results with D,B,H,C:
165 1|City
166 2|Mitte
167 4|Norderstedt
168 3|West
169 Here are the memcached results after set:
170 5|Ost-BIGINT-UNSIGNED
171 Here are the memcached results after set max border:
172 18446744073709551615|Ost
173 Here are the memcached results after set over max border:
174 18446744073709551615|Ost
175 ALTER TABLE t1 MODIFY c21 BIGINT UNSIGNED;
176 Warnings:
177 Warning 1366 Incorrect integer value: 'Mitte' for column 'c21' at row 1
178 Warning 1366 Incorrect integer value: 'West' for column 'c21' at row 2
179 Warning 1366 Incorrect integer value: 'City' for column 'c21' at row 3
180 Warning 1366 Incorrect integer value: 'Ost' for column 'c21' at row 4
181 Warning 1366 Incorrect integer value: 'Beijing-Signed-BIGINT' for column 'c21' at row 5
182 Warning 1366 Incorrect integer value: 'Norderstedt' for column 'c21' at row 6
183 Here are the memcached results with D,B,H,C:
184 1|0
185 2|0
186 4|0
187 3|0
188 Here are the memcached results after set:
189 5|5
190 Here are the memcached results after set max border:
191 18446744073709551615|18446744073709551615
192 Here are the memcached results after set over max border:
193 18446744073709551615|18446744073709551615
194 Here are the memcached results after append:
195 Append to integer value is not supported.
196 18446744073709551615|18446744073709551615
197 SELECT c1,c2,c21 FROM t1;
198 c1 c2 c21
199 B 2 0
200 C 3 0
201 D 1 0
202 E 18446744073709551615 18446744073709551615
203 F 0 0
204 H 4 0
205 SELECT c1,c2,c21 FROM t1;
206 c1 c2 c21
207 B 2 0
208 C 3 0
209 D 1 0
210 E 18446744073709551615 18446744073709551615
211 F 0 0
212 H 4 0
213 DELETE FROM t1;
214 ALTER TABLE t1 MODIFY c1 INT;
215 ALTER TABLE t1 MODIFY c21 VARCHAR(1024);
216 INSERT INTO t1 VALUES (1, 1, 'City', 0, 0, 0);
217 INSERT INTO t1 VALUES (2, 2, 'Mitte', 0, 0, 0);
218 INSERT INTO t1 VALUES (3, 3, 'West', 0, 0 ,0);
219 INSERT INTO t1 VALUES (4, 4, 'Norderstedt', 0, 0, 0);
220 SELECT c1,c2,c21 FROM t1;
221 c1 c2 c21
222 1 1 City
223 2 2 Mitte
224 3 3 West
225 4 4 Norderstedt
226 Here are the memcached results with 1,2,3,4:
227 1|City
228 2|Mitte
229 3|West
230 4|Norderstedt
231 Here are the memcached results after set:
232 5|Ost-INT-KEY
233 Here are the memcached results after add key with min border:
234 6|Ost
235 Here are the memcached results after add key with max border:
236 7|Ost
237 Here are the memcached results after add key with over max border:
238 6|Ost
239 DROP TABLE t1;
240 SET sql_mode=default;
241 #
242 # Bug#20535517 INCORRECT HANDLING OF UNSIGNED NOT NULL INTEGERS IN INNODB_MEMCACHED
243 #
244 Here are the memcached results with E:
245 543
246 SELECT * FROM int_test;
247 k v
248 E 543
249 DROP TABLE int_test;
250 UNINSTALL PLUGIN daemon_memcached;
251 DROP DATABASE innodb_memcache;
252 SET @@global.transaction_isolation= @transaction_isolation;