Debian Codegraph @

mysql-test/suite/memcached/t/memc265_r_batch_5.test

raw
1 source include/not_valgrind.inc;
2 source include/have_memcached_plugin.inc;
3 source include/not_windows.inc;
4
5 --disable_query_log
6 CALL mtr.add_suppression("daemon-memcached-r-batch-size': unsigned value");
7 CALL mtr.add_suppression("Could not obtain server's UPN to be used as target service name");
8 CALL mtr.add_suppression("Warning: MySQL is trying to drop");
9 --enable_query_log
10
11 --enable_connect_log
12 SET @auto_commit= @@global.autocommit;
13 SET @innodb_lock_wait_timeout_old=@@global.innodb_lock_wait_timeout;
14 SET @@global.innodb_lock_wait_timeout=1;
15 SET @lock_wait_timeout_old=@@global.lock_wait_timeout;
16 SET @@global.lock_wait_timeout=1;
17 SET @@global.autocommit=0;
18 SET @transaction_isolation= @@global.transaction_isolation;
19 SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE;
20 SET @wait= @@global.wait_timeout;
21
22 # Create the memcached tables
23 --disable_query_log
24 source include/memcache_config.inc;
25 --enable_query_log
26
27 INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
28 "innodb_only", "innodb_only", "innodb_only");
29
30 INSERT INTO config_options VALUES("separator", "|");
31
32 # describe table for memcache
33 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
34 "c1", "c2,c21", "c3", "c4", "c5", "PRIMARY");
35
36 CREATE USER mysqltest1@localhost;
37 COMMIT;
38 connect (mysqltest1,localhost,mysqltest1,,);
39 connection mysqltest1;
40
41 USE test;
42
43 --disable_warnings
44 DROP TABLE IF EXISTS t1;
45 --enable_warnings
46 CREATE TABLE t1 (c1 VARCHAR(32),
47 c2 VARCHAR(1024),
48 c21 VARCHAR(1024),
49 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
50 ENGINE = INNODB;
51
52 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City', 0, 0, 0);
53 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', 0, 0, 0);
54 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', 0, 0 ,0);
55 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', 0, 0, 0);
56 COMMIT;
57
58 connection default;
59 # Tables must exist before plugin can be started!
60 --let $memcached_address=127.0.0.1:11265
61 --source ../include/load_daemon_memcached_expecting_success.inc
62 SELECT @@global.daemon_memcached_r_batch_size;
63 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
64 SET @@global.daemon_memcached_r_batch_size=100;
65
66 connection mysqltest1;
67
68 --sorted_result
69 SELECT c1,c2,c21 FROM t1;
70 COMMIT;
71
72 connection default;
73
74 perl;
75 use DBI;
76 use Cache::Memcached;
77 my $memd = new Cache::Memcached {
78 'servers' => [ "127.0.0.1:11265" ],
79 'connect_timeout' => 20,
80 'select_timeout' => 20
81 };
82 print "Here are the memcached results:\n";
83 $val = $memd->get("B");
84 if ($val) { print "$val\n"; }
85 $val = $memd->get("B");
86 if ($val) { print "$val\n"; }
87 $val = $memd->get("B");
88 if ($val) { print "$val\n"; }
89 $val = $memd->get("C");
90 if ($val) { print "$val\n"; }
91 $val = $memd->get("B");
92 if ($val) { print "$val\n"; }
93 $val = $memd->get("C");
94 if ($val) { print "$val\n"; }
95 $memd->disconnect_all;
96 EOF
97 --sorted_result
98 SELECT c1,c2,c21 FROM test.t1;
99
100 connection mysqltest1;
101 --sorted_result
102 SELECT c1,c2,c21 FROM t1 FOR UPDATE;
103 ROLLBACK;
104
105 connection default;
106 perl;
107 use DBI;
108 use Cache::Memcached;
109 my $memd = new Cache::Memcached {
110 'servers' => [ "127.0.0.1:11265" ],
111 'connect_timeout' => 20,
112 'select_timeout' => 20
113 };
114 print "Here are the memcached results:\n";
115 $val = $memd->get("B");
116 if ($val) { print "$val\n"; }
117 $val = $memd->get("B");
118 if ($val) { print "$val\n"; }
119 $val = $memd->get("B");
120 if ($val) { print "$val\n"; }
121 $val = $memd->get("C");
122 if ($val) { print "$val\n"; }
123 $val = $memd->get("B");
124 if ($val) { print "$val\n"; }
125 $val = $memd->get("C");
126 if ($val) { print "$val\n"; }
127 $val = $memd->get("D");
128 if ($val) { print "$val\n"; }
129 $val = $memd->get("D");
130 if ($val) { print "$val\n"; }
131 $val = $memd->get("D");
132 if ($val) { print "$val\n"; }
133 $val = $memd->get("D");
134 if ($val) { print "$val\n"; }
135 $val = $memd->get("D");
136 if ($val) { print "$val\n"; }
137 $val = $memd->get("D");
138 if ($val) { print "$val\n"; }
139 $memd->disconnect_all;
140 EOF
141 --sorted_result
142 SELECT c1,c2,c21 FROM test.t1;
143
144 connection mysqltest1;
145 SELECT c1,c2,c21 FROM test.t1 FOR UPDATE;
146 ROLLBACK;
147
148 connection default;
149 perl;
150 use DBI;
151 use Cache::Memcached;
152 my $memd = new Cache::Memcached {
153 'servers' => [ "127.0.0.1:11265" ],
154 'connect_timeout' => 20,
155 'select_timeout' => 20
156 };
157 print "Here are the memcached results:\n";
158 $val = $memd->get("D");
159 if ($val) { print "$val\n"; }
160 $val = $memd->get("H");
161 if ($val) { print "$val\n"; }
162 $val = $memd->get("D");
163 if ($val) { print "$val\n"; }
164 $val = $memd->get("H");
165 if ($val) { print "$val\n"; }
166 $val = $memd->get("D");
167 if ($val) { print "$val\n"; }
168 $memd->disconnect_all;
169 EOF
170 --sorted_result
171 SELECT c1,c2,c21 FROM test.t1;
172
173 connection mysqltest1;
174 DROP TABLE test.t1;
175 COMMIT;
176
177 connection default;
178 disconnect mysqltest1;
179
180 UNINSTALL PLUGIN daemon_memcached;
181 DROP DATABASE innodb_memcache;
182 DROP USER mysqltest1@localhost;
183
184 SET @@global.transaction_isolation= @transaction_isolation;
185 SET @@global.autocommit=@auto_commit;
186 SET @@global.innodb_lock_wait_timeout=@innodb_lock_wait_timeout_old;
187 SET @@global.lock_wait_timeout=@lock_wait_timeout_old;
188