Debian Codegraph @

mysql-test/suite/memcached/t/memc237_sep_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 --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", "0");
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', 'City','1', 'dddddddddddddd', '1234', '2012', 0, 0, 0);
45 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', '2', 'bbbbbbbbbbbbbb', '2345', '2012', 0, 0, 0);
46 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', '3', 'cccccccccccccc', '3456', '2012', 0, 0 ,0);
47 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', '4', 'hhhhhhhhhh', '4567', '2012', 0, 0, 0);
48
49 # Tables must exist before plugin can be started!
50 --let $memcached_address=127.0.0.1:11237
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:11237" ],
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:11237" ],
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|Ost|5|eeeeeeeeeee|5678|2012");
89 $val = $memd->get("E");
90 if ($val) { print "$val\n"; }
91 $val = $memd->set("E","Essen0Ost050eeeeeeeeeee0567802012");
92 $val = $memd->get("E");
93 if ($val) { print "$val\n"; }
94 $memd->disconnect_all;
95 EOF
96
97 --sorted_result
98 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
99
100 DROP TABLE t1;
101
102 UNINSTALL PLUGIN daemon_memcached;
103 DROP DATABASE innodb_memcache;
104
105 SET @@global.transaction_isolation= @transaction_isolation;