Debian Codegraph @

mysql-test/suite/memcached/t/memc240_sep_4.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', '0', 'bbbbbbbbbbbbbb', '2345', '2012', 0, 0, 0);
46 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', '3', 'cccccccccccccc', '3456', '0', 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:11240
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:11240" ],
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 # Unload and reload the plugin for updating the options
80 UNINSTALL PLUGIN daemon_memcached;
81
82 # Let uninstall completes
83 UPDATE innodb_memcache.config_options SET value='|' WHERE name='separator';
84 # Wait until uninstall done.
85 let $wait_condition= SELECT COUNT(*)>0 FROM INFORMATION_SCHEMA.PROCESSLIST
86 WHERE INFO LIKE '%UNINSTALL PLUGIN%';
87 source include/wait_condition.inc;
88 --let $memcached_address=127.0.0.1:11240
89 --source ../include/load_daemon_memcached_expecting_success.inc
90
91 perl;
92 use DBI;
93 use Cache::Memcached;
94 my $memd = new Cache::Memcached {
95 'servers' => [ "127.0.0.1:11240" ],
96 'connect_timeout' => 20,
97 'select_timeout' => 20
98 };
99 print "Here are the memcached results after set:\n";
100 $val = $memd->set("E","Essen|Ost|5|eeeeeeeeeee|5678|2012");
101 $val = $memd->get("E");
102 if ($val) { print "$val\n"; }
103 #$val = $memd->set("E","Essen0Ost050eeeeeeeeeee0567802012");
104 #$val = $memd->get("E");
105 #if ($val) { print "$val\n"; }
106 $memd->disconnect_all;
107 EOF
108
109 --sorted_result
110 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
111
112 DROP TABLE t1;
113
114 UNINSTALL PLUGIN daemon_memcached;
115 DROP DATABASE innodb_memcache;
116
117 SET @@global.transaction_isolation= @transaction_isolation;