Debian Codegraph @

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