Debian Codegraph @

mysql-test/suite/memcached/r/memc224_index_2.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 CREATE USER mysqltest1@localhost;
9 connect mysqltest1,localhost,mysqltest1,,;
10 connection mysqltest1;
11 USE test;
12 DROP TABLE IF EXISTS t1;
13 CREATE TABLE t1 (c1 VARCHAR(32),
14 c11 VARCHAR(32),
15 c2 VARCHAR(1024),
16 c21 VARCHAR(1024),
17 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
18 ENGINE=INNODB;
19 INSERT INTO t1 VALUES ('D','D', 'Darmstadt', 'City', 0, 0, 0);
20 INSERT INTO t1 VALUES ('B','B', 'Berlin', 'Mitte', 0, 0, 0);
21 INSERT INTO t1 VALUES ('C','C', 'Cottbus', 'West', 0, 0 ,0);
22 INSERT INTO t1 VALUES ('H','H', 'Hamburg', 'Norderstedt', 0, 0, 0);
23 connection default;
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 connection mysqltest1;
28 USE test;
29 SELECT c1,c11,c2,c21 FROM t1;
30 c1 c11 c2 c21
31 B B Berlin Mitte
32 C C Cottbus West
33 D D Darmstadt City
34 H H Hamburg Norderstedt
35 Here are the memcached results with D,B,H,C:
36 Darmstadt|City
37 Berlin|Mitte
38 Hamburg|Norderstedt
39 Cottbus|West
40 SELECT c1,c11,c2,c21 FROM t1;
41 c1 c11 c2 c21
42 B B Berlin Mitte
43 C C Cottbus West
44 D D Darmstadt City
45 H H Hamburg Norderstedt
46 Here are the memcached results after set:
47 Essen|Ost
48 SELECT c1,c11,c2,c21 FROM t1;
49 c1 c11 c2 c21
50 B B Berlin Mitte
51 C C Cottbus West
52 D D Darmstadt City
53 E NULL Essen Ost
54 H H Hamburg Norderstedt
55 Here are the memcached results after add:
56 Frankfurt|Sachsenhause
57 SELECT c1,c11,c2,c21 FROM t1;
58 c1 c11 c2 c21
59 B B Berlin Mitte
60 C C Cottbus West
61 D D Darmstadt City
62 E NULL Essen Ost
63 F NULL Frankfurt Sachsenhause
64 H H Hamburg Norderstedt
65 Here are the memcached results after replace:
66 Frankfurt a. M.|Sachsenhausen
67 SELECT c1,c11,c2,c21 FROM t1;
68 c1 c11 c2 c21
69 B B Berlin Mitte
70 C C Cottbus West
71 D D Darmstadt City
72 E NULL Essen Ost
73 F NULL Frankfurt a. M. Sachsenhausen
74 H H Hamburg Norderstedt
75 Here are the memcached results after delete:
76 SELECT c1,c11,c2,c21 FROM t1;
77 c1 c11 c2 c21
78 B B Berlin Mitte
79 C C Cottbus West
80 D D Darmstadt City
81 E NULL Essen Ost
82 H H Hamburg Norderstedt
83 Here are the memcached results after add Frankfurt|Airport:
84 Frankfurt|Airport
85 SELECT c1,c11,c2,c21 FROM t1;
86 c1 c11 c2 c21
87 B B Berlin Mitte
88 C C Cottbus West
89 D D Darmstadt City
90 E NULL Essen Ost
91 F NULL Frankfurt Airport
92 H H Hamburg Norderstedt
93 Here are the memcached results after replace Frankfurt a.M|Sachsenhausen.:
94 Frankfurt a. M.|Sachsenhausen
95 SELECT c1,c11,c2,c21 FROM t1;
96 c1 c11 c2 c21
97 B B Berlin Mitte
98 C C Cottbus West
99 D D Darmstadt City
100 E NULL Essen Ost
101 F NULL Frankfurt a. M. Sachsenhausen
102 H H Hamburg Norderstedt
103 connection default;
104 UNINSTALL PLUGIN daemon_memcached;
105 ALTER TABLE test.t1 DROP PRIMARY KEY;
106 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
107 Warnings:
108 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
109 connection mysqltest1;
110 Here are the memcached results after set:
111 SELECT c1,c11,c2,c21 FROM t1;
112 c1 c11 c2 c21
113 B B Berlin Mitte
114 C C Cottbus West
115 D D Darmstadt City
116 E NULL Essen Ost
117 F NULL Frankfurt a. M. Sachsenhausen
118 H H Hamburg Norderstedt
119 connection default;
120 UNINSTALL PLUGIN daemon_memcached;
121 ALTER TABLE test.t1 ADD CONSTRAINT PRIMARY KEY (c1);
122 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
123 Warnings:
124 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
125 SHOW CREATE TABLE test.t1;
126 Table Create Table
127 t1 CREATE TABLE `t1` (
128 `c1` varchar(32) NOT NULL,
129 `c11` varchar(32) DEFAULT NULL,
130 `c2` varchar(1024) DEFAULT NULL,
131 `c21` varchar(1024) DEFAULT NULL,
132 `c3` int DEFAULT NULL,
133 `c4` bigint unsigned DEFAULT NULL,
134 `c5` int DEFAULT NULL,
135 PRIMARY KEY (`c1`)
136 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
137 connection mysqltest1;
138 Here are the memcached results after set:
139 Essen|Ost
140 Frankfurt a. M.|Sachsenhausen
141 Hamburg|Norderstedt
142 SELECT c1,c11,c2,c21 FROM t1;
143 c1 c11 c2 c21
144 B B Berlin Mitte
145 C C Cottbus West
146 D D Darmstadt City
147 E NULL Essen Ost
148 F NULL Frankfurt a. M. Sachsenhausen
149 H H Hamburg Norderstedt
150 connection default;
151 UNINSTALL PLUGIN daemon_memcached;
152 ALTER TABLE test.t1 DROP COLUMN c1;
153 UPDATE innodb_memcache.containers set key_columns = "c11", unique_idx_name_on_key="idx";
154 create unique index idx on test.t1(c11);
155 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
156 Warnings:
157 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
158 connection mysqltest1;
159 Here are the memcached results after add:
160 Essen|Ost
161 Frankfurt|Sachsenhause
162 Hamburg|Norderstedt
163 SELECT c11,c2,c21 FROM t1;
164 c11 c2 c21
165 B Berlin Mitte
166 C Cottbus West
167 D Darmstadt City
168 E Essen Ost
169 F Frankfurt Sachsenhause
170 H Hamburg Norderstedt
171 NULL Essen Ost
172 NULL Frankfurt a. M. Sachsenhausen
173 DROP TABLE t1;
174 connection default;
175 disconnect mysqltest1;
176 UNINSTALL PLUGIN daemon_memcached;
177 DROP DATABASE innodb_memcache;
178 DROP USER mysqltest1@localhost;
179 SET @@global.transaction_isolation= @transaction_isolation;