Debian Codegraph @

mysql-test/suite/memcached/t/memc262_instant_add_column.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 --enable_query_log
10
11 --enable_connect_log
12 SET @transaction_isolation= @@global.transaction_isolation;
13 SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
14
15 # Create the memcached tables
16 --disable_query_log
17 source include/memcache_config.inc;
18 --enable_query_log
19
20 INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
21 "innodb_only", "innodb_only", "innodb_only");
22
23 INSERT INTO config_options VALUES("separator", "|");
24
25 USE test;
26
27 --disable_warnings
28 DROP TABLE IF EXISTS t1;
29 --enable_warnings
30 CREATE TABLE t1 (c1 VARCHAR(32),
31 c2 VARCHAR(40),
32 c21 VARCHAR(40),
33 c22 VARCHAR(40),
34 c23 VARCHAR(40),
35 c24 VARCHAR(40),
36 c25 VARCHAR(40) DEFAULT 'world',
37 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
38 ENGINE = INNODB;
39
40 INSERT INTO t1 VALUES ('D', 'Darmstadt', NULL,'1', 'dddddddddddddd', '1234', NULL, 0, 0, 0);
41 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', NULL, 'bbbbbbbbbbbbbb', '2345', '2012', 0, 0, 0);
42 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', '3', NULL, '3456', '2012', 0, 0, 0);
43 INSERT INTO t1 VALUES ('H', NULL, NULL, NULL, 'hhhhhhhhhh', NULL, NULL, 0, 0, 0);
44
45 # Add some columns instantly
46 ALTER TABLE t1 ADD COLUMN c26 INT DEFAULT 20, ALGORITHM = INSTANT;
47 ALTER TABLE t1 ADD COLUMN c27 BIGINT UNSIGNED DEFAULT 50, ALGORITHM = INSTANT;
48 ALTER TABLE t1 ADD COLUMN c28 VARCHAR(20) DEFAULT 'hello', ALGORITHM = INSTANT;
49 UPDATE t1 SET c27 = 100 WHERE c1 < 'D';
50
51 # describe table for memcache
52 INSERT INTO innodb_memcache.containers VALUES ("desc_t1", "test", "t1",
53 "c1", "c2,c21,c22,c23,c24,c25,c26,c27,c28", "c3", "c4", "c5", "PRIMARY");
54
55 # Tables must exist before plugin can be started!
56 --let $memcached_address=127.0.0.1:11262
57 --source ../include/load_daemon_memcached_expecting_success.inc
58
59 --sorted_result
60 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27,c28 FROM t1;
61
62 perl;
63 use DBI;
64 use Cache::Memcached;
65 my $memd = new Cache::Memcached {
66 'servers' => [ "127.0.0.1:11262" ],
67 'connect_timeout' => 20,
68 'select_timeout' => 20
69 };
70 print "Here are the memcached results with D,B,H,C:\n";
71 $val = $memd->get("D");
72 if ($val) { print "$val\n"; }
73 $val = $memd->get("B");
74 if ($val) { print "$val\n"; }
75 $val = $memd->get("H");
76 if ($val) { print "$val\n"; }
77 $val = $memd->get("C");
78 if ($val) { print "$val\n"; }
79 $memd->disconnect_all;
80 EOF
81
82 --sorted_result
83 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27,c28 FROM t1;
84
85 perl;
86 use DBI;
87 use Cache::Memcached;
88 my $memd = new Cache::Memcached {
89 'servers' => [ "127.0.0.1:11262" ],
90 'connect_timeout' => 20,
91 'select_timeout' => 20
92 };
93 print "Here are the memcached results after set:\n";
94 $val = $memd->set("E","Essen||||5678|2012|'germany'|'western'|'city'|100|200|'Hello world'");
95 $val = $memd->get("E");
96 if ($val) { print "$val\n"; }
97 $memd->disconnect_all;
98 EOF
99
100 --sorted_result
101 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27,c28 FROM t1;
102
103 perl;
104 use DBI;
105 use Cache::Memcached;
106 my $memd = new Cache::Memcached {
107 'servers' => [ "127.0.0.1:11262" ],
108 'connect_timeout' => 20,
109 'select_timeout' => 20
110 };
111 print "Here are the memcached results after add:\n";
112 $val = $memd->add("F","Frankfurt|Airport||||2012");
113 $val = $memd->get("F");
114 if ($val) { print "$val\n"; }
115 $memd->disconnect_all;
116 EOF
117
118 --sorted_result
119 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27,c28 FROM t1;
120
121 perl;
122 use DBI;
123 use Cache::Memcached;
124 my $memd = new Cache::Memcached {
125 'servers' => [ "127.0.0.1:11262" ],
126 'connect_timeout' => 20,
127 'select_timeout' => 20
128 };
129 print "Here are the memcached results after replace:\n";
130 $val = $memd->replace("F","Frankfurt a.M.|Sachsenhausen|61|fffff|6789|");
131 $val = $memd->get("F");
132 if ($val) { print "$val\n"; }
133 $memd->disconnect_all;
134 EOF
135
136 --sorted_result
137 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27,c28 FROM t1;
138
139 perl;
140 use DBI;
141 use Cache::Memcached;
142 my $memd = new Cache::Memcached {
143 'servers' => [ "127.0.0.1:11262" ],
144 'connect_timeout' => 20,
145 'select_timeout' => 20
146 };
147 print "Here are the memcached results after delete:\n";
148 $val = $memd->delete("F");
149 $val = $memd->get("E");
150 if ($val) { print "$val\n"; }
151 $val = $memd->get("F");
152 if ($val) { print "$val\n"; }
153 $memd->disconnect_all;
154 EOF
155
156 --sorted_result
157 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27,c28 FROM t1;
158
159 DROP TABLE t1;
160
161 UNINSTALL PLUGIN daemon_memcached;
162 DROP DATABASE innodb_memcache;
163
164 SET @@global.transaction_isolation= @transaction_isolation;