Debian Codegraph @

mysql-test/suite/memcached/r/memc245_w_batch_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 USE test;
9 DROP TABLE IF EXISTS t1;
10 CREATE TABLE t1 (c1 VARCHAR(32),
11 c2 VARCHAR(1024),
12 c21 VARCHAR(1024),
13 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
14 ENGINE = INNODB;
15 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City', 0, 0, 0);
16 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', 0, 0, 0);
17 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', 0, 0 ,0);
18 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', 0, 0, 0);
19 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
20 Warnings:
21 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
22 SELECT @@global.daemon_memcached_r_batch_size;
23 @@global.daemon_memcached_r_batch_size
24 1
25 SELECT c1,c2,c21 FROM t1;
26 c1 c2 c21
27 B Berlin Mitte
28 C Cottbus West
29 D Darmstadt City
30 H Hamburg Norderstedt
31 Here are the memcached results with D,B,H,C:
32 Darmstadt|City
33 Berlin|Mitte
34 Hamburg|Norderstedt
35 Cottbus|West
36 SELECT c1,c2,c21 FROM t1;
37 c1 c2 c21
38 B Berlin Mitte
39 C Cottbus West
40 D Darmstadt City
41 H Hamburg Norderstedt
42 Here are the memcached results after set:
43 Essen|Ost
44 SELECT c1,c2,c21 FROM t1;
45 c1 c2 c21
46 B Berlin Mitte
47 C Cottbus West
48 D Darmstadt City
49 E Essen Ost
50 H Hamburg Norderstedt
51 Here are the memcached results after add:
52 Frankfurt|Sachsenhause
53 SELECT c1,c2,c21 FROM t1;
54 c1 c2 c21
55 B Berlin Mitte
56 C Cottbus West
57 D Darmstadt City
58 E Essen Ost
59 F Frankfurt Sachsenhause
60 H Hamburg Norderstedt
61 Here are the memcached results after replace:
62 Frankfurt a. M.|Sachsenhausen
63 SELECT c1,c2,c21 FROM t1;
64 c1 c2 c21
65 B Berlin Mitte
66 C Cottbus West
67 D Darmstadt City
68 E Essen Ost
69 F Frankfurt a. M. Sachsenhausen
70 H Hamburg Norderstedt
71 Here are the memcached results after delete:
72 SELECT c1,c2,c21 FROM t1;
73 c1 c2 c21
74 B Berlin Mitte
75 C Cottbus West
76 D Darmstadt City
77 E Essen Ost
78 H Hamburg Norderstedt
79 Here are the memcached results after add Frankfurt|:
80 Frankfurt|
81 Here are the memcached results after add |Airport:
82 Frankfurt|
83 SELECT c1,c2,c21 FROM t1;
84 c1 c2 c21
85 B Berlin Mitte
86 C Cottbus West
87 D Darmstadt City
88 E Essen Ost
89 F Frankfurt NULL
90 H Hamburg Norderstedt
91 Here are the memcached results after replace Frankfurt a.M.:
92 Frankfurt a. M.|
93 Here are the memcached results after replace Sachsenhausen:
94 |Sachsenhausen
95 SELECT c1,c2,c21 FROM t1;
96 c1 c2 c21
97 B Berlin Mitte
98 C Cottbus West
99 D Darmstadt City
100 E Essen Ost
101 F NULL Sachsenhausen
102 H Hamburg Norderstedt
103 DROP TABLE t1;
104 UNINSTALL PLUGIN daemon_memcached;
105 DROP DATABASE innodb_memcache;
106 SET @@global.transaction_isolation= @transaction_isolation;