Debian Codegraph @

mysql-test/suite/memcached/t/memc239_sep_3.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 #set names utf8;
16
17 # Create the memcached tables
18 --disable_query_log
19 source include/memcache_config.inc;
20 --enable_query_log
21
22 INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
23 "innodb_only", "innodb_only", "innodb_only");
24
25 INSERT INTO config_options VALUES("separator", "ü");
26
27 # describe table for memcache
28 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
29 "c1", "c2,c21,c22,c23,c24,c25", "c3", "c4", "c5", "PRIMARY");
30
31 USE test;
32
33 --disable_warnings
34 DROP TABLE IF EXISTS t1;
35 --enable_warnings
36 CREATE TABLE t1 (c1 VARCHAR(32),
37 c2 VARCHAR(40),
38 c21 VARCHAR(40),
39 c22 VARCHAR(40),
40 c23 VARCHAR(40),
41 c24 VARCHAR(40),
42 c25 VARCHAR(40),
43 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
44 ENGINE = INNODB;
45
46 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City','1', 'dddddddddddddd', '1234', '2012', 0, 0, 0);
47 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', '2', 'bbbbbbbbbbbbbb', '2345', '2012', 0, 0, 0);
48 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', '3', 'cccccccccccccc', '3456', '2012', 0, 0 ,0);
49 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', '4', 'hhhhhhhhhh', '4567', '2012', 0, 0, 0);
50
51 # Tables must exist before plugin can be started!
52 --let $memcached_address=127.0.0.1:11239
53 --source ../include/load_daemon_memcached_expecting_success.inc
54
55 --sorted_result
56 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
57
58 perl;
59 use DBI;
60 use Cache::Memcached;
61 my $memd = new Cache::Memcached {
62 'servers' => [ "127.0.0.1:11239" ],
63 'connect_timeout' => 20,
64 'select_timeout' => 20
65 };
66 print "Here are the memcached results with D,B,H,C:\n";
67 $val = $memd->get("D");
68 if ($val) { print "$val\n"; }
69 $val = $memd->get("B");
70 if ($val) { print "$val\n"; }
71 $val = $memd->get("H");
72 if ($val) { print "$val\n"; }
73 $val = $memd->get("C");
74 if ($val) { print "$val\n"; }
75 $memd->disconnect_all;
76 EOF
77
78 --sorted_result
79 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
80
81 perl;
82 use DBI;
83 use Cache::Memcached;
84 my $memd = new Cache::Memcached {
85 'servers' => [ "127.0.0.1:11239" ],
86 'connect_timeout' => 20,
87 'select_timeout' => 20
88 };
89 print "Here are the memcached results after set:\n";
90 $val = $memd->set("E","Essen|Ost|5|eeeeeeeeeee|5678|2012");
91 $val = $memd->get("E");
92 if ($val) { print "$val\n"; }
93 $val = $memd->set("E","EssenüOstü5üeeeeeeeeeeeü5678ü2012");
94 $val = $memd->get("E");
95 if ($val) { print "$val\n"; }
96 $memd->disconnect_all;
97 EOF
98
99 --sorted_result
100 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
101
102 DROP TABLE t1;
103
104 UNINSTALL PLUGIN daemon_memcached;
105 DROP DATABASE innodb_memcache;
106
107 SET @@global.transaction_isolation= @transaction_isolation;