Debian Codegraph @

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