Debian Codegraph @

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

raw
1 SET @auto_commit= @@global.autocommit;
2 SET @innodb_lock_wait_timeout_old=@@global.innodb_lock_wait_timeout;
3 SET @@global.innodb_lock_wait_timeout=1;
4 SET @lock_wait_timeout_old=@@global.lock_wait_timeout;
5 SET @@global.lock_wait_timeout=1;
6 SET @@global.autocommit=0;
7 SET @transaction_isolation= @@global.transaction_isolation;
8 SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE;
9 SET @wait= @@global.wait_timeout;
10 INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
11 "innodb_only", "innodb_only", "innodb_only");
12 INSERT INTO config_options VALUES("separator", "|");
13 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
14 "c1", "c2,c21", "c3", "c4", "c5", "PRIMARY");
15 CREATE USER mysqltest1@localhost;
16 COMMIT;
17 connect mysqltest1,localhost,mysqltest1,,;
18 connection mysqltest1;
19 USE test;
20 DROP TABLE IF EXISTS t1;
21 CREATE TABLE t1 (c1 VARCHAR(32),
22 c2 VARCHAR(1024),
23 c21 VARCHAR(1024),
24 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
25 ENGINE = INNODB;
26 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City', 0, 0, 0);
27 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', 0, 0, 0);
28 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', 0, 0 ,0);
29 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', 0, 0, 0);
30 COMMIT;
31 connection default;
32 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
33 Warnings:
34 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
35 SELECT @@global.daemon_memcached_r_batch_size;
36 @@global.daemon_memcached_r_batch_size
37 2
38 SET @@global.daemon_memcached_r_batch_size=100;
39 ERROR HY000: Variable 'daemon_memcached_r_batch_size' is a read only variable
40 connection mysqltest1;
41 SELECT c1,c2,c21 FROM t1;
42 c1 c2 c21
43 B Berlin Mitte
44 C Cottbus West
45 D Darmstadt City
46 H Hamburg Norderstedt
47 COMMIT;
48 connection default;
49 Here are the memcached results:
50 Berlin|Mitte
51 Cottbus|West
52 SELECT c1,c2,c21 FROM test.t1;
53 c1 c2 c21
54 B Berlin Mitte
55 C Cottbus West
56 D Darmstadt City
57 H Hamburg Norderstedt
58 connection mysqltest1;
59 SELECT c1,c2,c21 FROM t1 FOR UPDATE;
60 c1 c2 c21
61 B Berlin Mitte
62 C Cottbus West
63 D Darmstadt City
64 H Hamburg Norderstedt
65 ROLLBACK;
66 connection default;
67 Here are the memcached results:
68 Cottbus|West
69 Darmstadt|City
70 SELECT c1,c2,c21 FROM test.t1;
71 c1 c2 c21
72 B Berlin Mitte
73 C Cottbus West
74 D Darmstadt City
75 H Hamburg Norderstedt
76 connection mysqltest1;
77 SELECT c1,c2,c21 FROM test.t1 FOR UPDATE;
78 c1 c2 c21
79 B Berlin Mitte
80 C Cottbus West
81 D Darmstadt City
82 H Hamburg Norderstedt
83 ROLLBACK;
84 connection default;
85 Here are the memcached results:
86 Darmstadt|City
87 Hamburg|Norderstedt
88 Darmstadt|City
89 Hamburg|Norderstedt
90 SELECT c1,c2,c21 FROM test.t1;
91 c1 c2 c21
92 B Berlin Mitte
93 C Cottbus West
94 D Darmstadt City
95 H Hamburg Norderstedt
96 connection mysqltest1;
97 SELECT c1,c2,c21 FROM t1 FOR UPDATE;
98 c1 c2 c21
99 B Berlin Mitte
100 C Cottbus West
101 D Darmstadt City
102 H Hamburg Norderstedt
103 DROP TABLE test.t1;
104 COMMIT;
105 connection default;
106 disconnect mysqltest1;
107 UNINSTALL PLUGIN daemon_memcached;
108 DROP DATABASE innodb_memcache;
109 DROP USER mysqltest1@localhost;
110 SET @@global.transaction_isolation= @transaction_isolation;
111 SET @@global.autocommit=@auto_commit;
112 SET @@global.innodb_lock_wait_timeout=@innodb_lock_wait_timeout_old;
113 SET @@global.lock_wait_timeout=@lock_wait_timeout_old;