Debian Codegraph @

mysql-test/suite/memcached/r/memc294_multipleget.result

raw
1 INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
2 "innodb_only", "innodb_only", "innodb_only");
3 INSERT INTO config_options VALUES("separator", "0");
4 INSERT INTO containers VALUES ("desc_t1", "test", "t1", "c1", "c2,
5 c21,c22,c23,c24,c25", "c3", "c4", "c5", "PRIMARY");
6 INSERT INTO containers VALUES ("desc_t2", "test", "t2", "c1",
7 "c2,c3", "c4", "c5", "c6", "PRIMARY");
8 USE test;
9 DROP TABLE IF EXISTS t1;
10 DROP TABLE IF EXISTS t2;
11 CREATE TABLE t1 (c1 VARCHAR(32),c2 VARCHAR(40),c21 VARCHAR(40),c22 VARCHAR(40),
12 c23 VARCHAR(40),c24 VARCHAR(40),c25 VARCHAR(40),c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
13 ENGINE = INNODB;
14 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City','1', 'dddddddddddddd', '1234', '2012', 0, 0, 0);
15 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', '2', 'bbbbbbbbbbbbbb', '2345', '2012', 0, 0, 0);
16 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', '3', 'cccccccccccccc', '3456', '2012', 0, 0 ,0);
17 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', '4', 'hhhhhhhhhh', '4567', '2012', 0, 0, 0);
18 INSERT INTO t1 VALUES ('N', NULL, NULL, NULL, NULL, NULL, '2012', 0, 0, 0);
19 CREATE TABLE t2(c1 VARCHAR(32),c2 VARCHAR(1024),c3 VARCHAR(1024),
20 c4 INT, c5 BIGINT UNSIGNED, c6 INT, primary key(c1)) ENGINE=InnoDB;
21 INSERT INTO t2 VALUES ('DD','DELHI','DAHAR', 0, 0, 0);
22 INSERT INTO t2 VALUES ('BB','BOMBAY', 'BANGALORE', 0, 0, 0);
23 INSERT INTO t2 VALUES ('CC','CALICUTT','CHENNAI', 0, 0 ,0);
24 INSERT INTO t2 VALUES ('HH','HYDERABAD','HOSPET', 0, 0, 0);
25 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
26 Warnings:
27 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
28 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
29 c1 c2 c21 c22 c23 c24 c25
30 B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
31 C Cottbus West 3 cccccccccccccc 3456 2012
32 D Darmstadt City 1 dddddddddddddd 1234 2012
33 H Hamburg Norderstedt 4 hhhhhhhhhh 4567 2012
34 N NULL NULL NULL NULL NULL 2012
35 # case 1: Fetch results for all Keys
36 Here are the memcached results with D B C H D B C H N:
37 B => Berlin0Mitte020bbbbbbbbbbbbbb0234502012
38 C => Cottbus0West030cccccccccccccc0345602012
39 D => Darmstadt0City010dddddddddddddd0123402012
40 H => Hamburg0Norderstedt040hhhhhhhhhh0456702012
41 N => 000002012
42 SELECT SLEEP(2);
43 SLEEP(2)
44 0
45 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
46 c1 c2 c21 c22 c23 c24 c25
47 B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
48 C Cottbus West 3 cccccccccccccc 3456 2012
49 D Darmstadt City 1 dddddddddddddd 1234 2012
50 H Hamburg Norderstedt 4 hhhhhhhhhh 4567 2012
51 N NULL NULL NULL NULL NULL 2012
52 # case 2: Fetch results, when no values are exist for some keys
53 Here are the memcached results with D B C H I J K L M N O P NULL Q R S T U V X Y Z A D B C H:
54 B => Berlin0Mitte020bbbbbbbbbbbbbb0234502012
55 C => Cottbus0West030cccccccccccccc0345602012
56 D => Darmstadt0City010dddddddddddddd0123402012
57 H => Hamburg0Norderstedt040hhhhhhhhhh0456702012
58 N => 000002012
59 SELECT SLEEP(2);
60 SLEEP(2)
61 0
62 SELECT c1,c2,c3 FROM t2;
63 c1 c2 c3
64 BB BOMBAY BANGALORE
65 CC CALICUTT CHENNAI
66 DD DELHI DAHAR
67 HH HYDERABAD HOSPET
68 # case 3: No support switch between the tables t2 and t1
69 # Here it shows the results of table t2 and not for t1
70 Here are the memcached results with @@desc_t2.DD @@desc_t2.BB @@desc_t2.CC @@desc_t1.c @@desc_t2.HH @@desc_t1.H:
71 @@desc_t2.BB => BOMBAY0BANGALORE
72 @@desc_t2.CC => CALICUTT0CHENNAI
73 @@desc_t2.DD => DELHI0DAHAR
74 @@desc_t2.HH => HYDERABAD0HOSPET
75 SELECT SLEEP(2);
76 SLEEP(2)
77 0
78 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
79 c1 c2 c21 c22 c23 c24 c25
80 B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
81 C Cottbus West 3 cccccccccccccc 3456 2012
82 D Darmstadt City 1 dddddddddddddd 1234 2012
83 H Hamburg Norderstedt 4 hhhhhhhhhh 4567 2012
84 N NULL NULL NULL NULL NULL 2012
85 DROP TABLE t1;
86 DROP TABLE t2;
87 UNINSTALL PLUGIN daemon_memcached;
88 DROP DATABASE innodb_memcache;