Debian Codegraph @

mysql-test/suite/memcached/t/memc220_fkey_1.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-w-batch-size': unsigned");
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 CALL mtr.add_suppression("Error: MySQL is freeing a thd");
10 --enable_query_log
11
12 --enable_connect_log
13 SET @transaction_isolation= @@global.transaction_isolation;
14 SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
15
16 # Create the memcached tables
17 --disable_query_log
18 source include/memcache_config.inc;
19 --enable_query_log
20
21 INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
22 "innodb_only", "innodb_only", "innodb_only");
23
24 INSERT INTO config_options VALUES("separator", "|");
25
26 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
27 "c1", "c11,c2,c21", "c3", "c4", "c5", "it1");
28
29 USE test;
30 --disable_warnings
31 DROP TABLE IF EXISTS t2;
32 --enable_warnings
33
34 CREATE TABLE t2 (c1 VARCHAR(32),
35 c2 VARCHAR(255),
36 c21 VARCHAR(255),
37 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
38 ENGINE = INNODB;
39
40 --disable_warnings
41 DROP TABLE IF EXISTS t1;
42 --enable_warnings
43
44 CREATE TABLE t1 (c1 VARCHAR(32),
45 c11 VARCHAR(32),
46 c2 VARCHAR(1024),
47 c21 VARCHAR(1024),
48 c3 INT, c4 BIGINT UNSIGNED, c5 INT,
49 FOREIGN KEY ft1(c11) REFERENCES t2(c1))
50
51 ENGINE = INNODB;
52
53 CREATE UNIQUE INDEX it1 ON t1 (c1);
54
55 INSERT INTO t2 VALUES ('Dd', 'Hessen', 'M', 0, 0, 0);
56 INSERT INTO t2 VALUES ('Bb', 'Brandenburg', 'M', 0, 0, 0);
57 INSERT INTO t2 VALUES ('Cc', 'Lausitz', 'S', 0, 0 ,0);
58 INSERT INTO t2 VALUES ('Hh', 'Schleswig-Holstein', 'S', 0, 0, 0);
59
60 INSERT INTO t1 VALUES ('D','Dd', 'Darmstadt', 'City', 0, 0, 0);
61 INSERT INTO t1 VALUES ('B','Bb', 'Berlin', 'Mitte', 0, 0, 0);
62 INSERT INTO t1 VALUES ('C','Cc', 'Cottbus', 'West', 0, 0 ,0);
63 INSERT INTO t1 VALUES ('H','Hh', 'Hamburg', 'Norderstedt', 0, 0, 0);
64
65 # Tables must exist before plugin can be started!
66 --let $memcached_address=127.0.0.1:11220
67 --source ../include/load_daemon_memcached_expecting_success.inc
68
69 --sorted_result
70 SELECT c1,c2,c21 FROM t1;
71
72 perl;
73 use DBI;
74 use Cache::Memcached;
75 my $memd = new Cache::Memcached {
76 'servers' => [ "127.0.0.1:11220" ],
77 'connect_timeout' => 20,
78 'select_timeout' => 20
79 };
80 print "Here are the memcached results with D,B,H,C:\n";
81 $val = $memd->get("D");
82 if ($val) { print "$val\n"; }
83 $val = $memd->get("B");
84 if ($val) { print "$val\n"; }
85 $val = $memd->get("H");
86 if ($val) { print "$val\n"; }
87 $val = $memd->get("C");
88 if ($val) { print "$val\n"; }
89 $memd->disconnect_all;
90 EOF
91
92 --sorted_result
93 SELECT t1.c1,t1.c2,t1.c21,t2.c2,t2.c21 FROM t1,t2 WHERE t1.c11=t2.c1;
94
95 perl;
96 use DBI;
97 use Cache::Memcached;
98 my $memd = new Cache::Memcached {
99 'servers' => [ "127.0.0.1:11220" ],
100 'connect_timeout' => 20,
101 'select_timeout' => 20
102 };
103 print "Here are the memcached results after set:\n";
104 $val = $memd->set("E","Dd|Essen|Ost");
105 $val = $memd->get("E");
106 if ($val) { print "$val\n"; }
107 $memd->disconnect_all;
108 EOF
109
110 --sorted_result
111 SELECT t1.c1,t1.c2,t1.c21,t2.c2,t2.c21 FROM t1,t2 WHERE t1.c11=t2.c1;
112
113 perl;
114 use DBI;
115 perl;
116 use DBI;
117 use Cache::Memcached;
118 my $memd = new Cache::Memcached {
119 'servers' => [ "127.0.0.1:11220" ],
120 'connect_timeout' => 20,
121 'select_timeout' => 20
122 };
123 print "Here are the memcached results after add:\n";
124 $val = $memd->add("F","Dd|Frankfurt|Sachsenhause");
125 $val = $memd->get("F");
126 if ($val) { print "$val\n"; }
127 $memd->disconnect_all;
128 EOF
129
130 --sorted_result
131 SELECT t1.c1,t1.c2,t1.c21,t2.c2,t2.c21 FROM t1,t2 WHERE t1.c11=t2.c1;
132
133 perl;
134 use DBI;
135 use Cache::Memcached;
136 my $memd = new Cache::Memcached {
137 'servers' => [ "127.0.0.1:11220" ],
138 'connect_timeout' => 20,
139 'select_timeout' => 20
140 };
141 print "Here are the memcached results after replace:\n";
142 $val = $memd->replace("F","Dd,Frankfurt a. M.|Sachsenhausen");
143 $val = $memd->get("F");
144 if ($val) { print "$val\n"; }
145 $memd->disconnect_all;
146 EOF
147
148 --sorted_result
149 SELECT t1.c1,t1.c2,t1.c21,t2.c2,t2.c21 FROM t1,t2 WHERE t1.c11=t2.c1;
150
151 perl;
152 use DBI;
153 use Cache::Memcached;
154 my $memd = new Cache::Memcached {
155 'servers' => [ "127.0.0.1:11220" ],
156 'connect_timeout' => 20,
157 'select_timeout' => 20
158 };
159 print "Here are the memcached results after delete:\n";
160 $val = $memd->delete("F");
161 $val = $memd->get("F");
162 if ($val) { print "$val\n"; }
163 $memd->disconnect_all;
164 EOF
165
166 --sorted_result
167 SELECT t1.c1,t1.c2,t1.c21,t2.c2,t2.c21 FROM t1,t2 WHERE t1.c11=t2.c1;
168
169 perl;
170 use DBI;
171 use Cache::Memcached;
172 my $memd = new Cache::Memcached {
173 'servers' => [ "127.0.0.1:11220" ],
174 'connect_timeout' => 20,
175 'select_timeout' => 20
176 };
177 print "Here are the memcached results after add Frankfurt|Airport:\n";
178 $val = $memd->add("F","Bb|Frankfurt|Airport");
179 $val = $memd->get("F");
180 if ($val) { print "$val\n"; }
181 $memd->disconnect_all;
182 EOF
183
184 --sorted_result
185 SELECT t1.c1,t1.c2,t1.c21,t2.c2,t2.c21 FROM t1,t2 WHERE t1.c11=t2.c1;
186
187 # The replace must not succeed as Xx is not a valid foreign key.
188 perl;
189 use DBI;
190 use Cache::Memcached;
191 my $memd = new Cache::Memcached {
192 'servers' => [ "127.0.0.1:11220" ],
193 'connect_timeout' => 20,
194 'select_timeout' => 20
195 };
196 print "Here are the memcached results after replace Frankfurt a.M|Sachsenhausen.:\n";
197 $val = $memd->replace("F","Xx|Frankfurt a. M.|Sachsenhausen");
198 $val = $memd->get("F");
199 if ($val) { print "$val\n"; }
200 $memd->disconnect_all;
201 EOF
202
203 --sorted_result
204 SELECT t1.c1,t1.c2,t1.c21,t2.c2,t2.c21 FROM t1,t2 WHERE t1.c11=t2.c1;
205
206 #uninstall the plugin before dropping mapped table
207 UNINSTALL PLUGIN daemon_memcached;
208 DROP TABLE test.t1;
209 DROP TABLE test.t2;
210 DROP DATABASE innodb_memcache;
211
212 SET @@global.transaction_isolation= @transaction_isolation;
213