Debian Codegraph @

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

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