Debian Codegraph @

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

raw
1 SET @transaction_isolation= @@global.transaction_isolation;
2 SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
3 INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
4 "innodb_only", "innodb_only", "innodb_only");
5 INSERT INTO config_options VALUES("separator", "|");
6 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
7 "c1", "c2,c21,c22,c23,c24,c25", "c3", "c4", "c5", "PRIMARY");
8 USE test;
9 DROP TABLE IF EXISTS t1;
10 CREATE TABLE t1 (c1 VARCHAR(32),
11 c2 VARCHAR(40),
12 c21 CHAR(40),
13 c22 VARCHAR(2048),
14 c23 TEXT,
15 c24 VARCHAR(250),
16 c25 CHAR (10),
17 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
18 ENGINE = INNODB;
19 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City','1', 'dddddddddddddd', '1234', '2012', 0, 0, 0);
20 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', '2', 'bbbbbbbbbbbbbb', '2345', '2012', 0, 0, 0);
21 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', '3', 'cccccccccccccc', '3456', '2012', 0, 0 ,0);
22 INSERT INTO t1 VALUES ('H', 'Hamburg', 'Norderstedt', '4', 'hhhhhhhhhh', '4567', '2012', 0, 0, 0);
23 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
24 Warnings:
25 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
26 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
27 c1 c2 c21 c22 c23 c24 c25
28 B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
29 C Cottbus West 3 cccccccccccccc 3456 2012
30 D Darmstadt City 1 dddddddddddddd 1234 2012
31 H Hamburg Norderstedt 4 hhhhhhhhhh 4567 2012
32 Here are the memcached results with D,B,H,C:
33 Darmstadt|City |1|dddddddddddddd|1234|2012
34 Berlin|Mitte |2|bbbbbbbbbbbbbb|2345|2012
35 Hamburg|Norderstedt |4|hhhhhhhhhh|4567|2012
36 Cottbus|West |3|cccccccccccccc|3456|2012
37 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
38 c1 c2 c21 c22 c23 c24 c25
39 B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
40 C Cottbus West 3 cccccccccccccc 3456 2012
41 D Darmstadt City 1 dddddddddddddd 1234 2012
42 H Hamburg Norderstedt 4 hhhhhhhhhh 4567 2012
43 Here are the memcached results after set:
44 Essen|Ost |5|eeeeeeeeeee|5678|2012
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 E Essen Ost 5 eeeeeeeeeee 5678 2012
51 H Hamburg Norderstedt 4 hhhhhhhhhh 4567 2012
52 Here are the memcached results after add:
53 Frankfurt|Airport |6|fffffffffff|6789|2012
54 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
55 c1 c2 c21 c22 c23 c24 c25
56 B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
57 C Cottbus West 3 cccccccccccccc 3456 2012
58 D Darmstadt City 1 dddddddddddddd 1234 2012
59 E Essen Ost 5 eeeeeeeeeee 5678 2012
60 F Frankfurt Airport 6 fffffffffff 6789 2012
61 H Hamburg Norderstedt 4 hhhhhhhhhh 4567 2012
62 Here are the memcached results after replace:
63 Frankfurt a.M.|Sachsenhausen |61|fffff|6789|2012
64 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
65 c1 c2 c21 c22 c23 c24 c25
66 B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
67 C Cottbus West 3 cccccccccccccc 3456 2012
68 D Darmstadt City 1 dddddddddddddd 1234 2012
69 E Essen Ost 5 eeeeeeeeeee 5678 2012
70 F Frankfurt a.M. Sachsenhausen 61 fffff 6789 2012
71 H Hamburg Norderstedt 4 hhhhhhhhhh 4567 2012
72 Here are the memcached results after delete:
73 Essen|Ost |5|eeeeeeeeeee|5678|2012
74 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
75 c1 c2 c21 c22 c23 c24 c25
76 B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
77 C Cottbus West 3 cccccccccccccc 3456 2012
78 D Darmstadt City 1 dddddddddddddd 1234 2012
79 E Essen Ost 5 eeeeeeeeeee 5678 2012
80 H Hamburg Norderstedt 4 hhhhhhhhhh 4567 2012
81 ALTER TABLE t1 MODIFY c2 CHAR(30);
82 Here are the memcached results with D,B,H,C:
83 Darmstadt |City |1|dddddddddddddd|1234|2012
84 Berlin |Mitte |2|bbbbbbbbbbbbbb|2345|2012
85 Hamburg |Norderstedt |4|hhhhhhhhhh|4567|2012
86 Cottbus |West |3|cccccccccccccc|3456|2012
87 Here are the memcached results after add:
88 Frankfurt |Airport |6|fffffffffff|6789|2012
89 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
90 c1 c2 c21 c22 c23 c24 c25
91 B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
92 C Cottbus West 3 cccccccccccccc 3456 2012
93 D Darmstadt City 1 dddddddddddddd 1234 2012
94 E Essen Ost 5 eeeeeeeeeee 5678 2012
95 F Frankfurt Airport 6 fffffffffff 6789 2012
96 H Hamburg Norderstedt 4 hhhhhhhhhh 4567 2012
97 DROP TABLE t1;
98 UNINSTALL PLUGIN daemon_memcached;
99 DROP DATABASE innodb_memcache;
100 SET @@global.transaction_isolation= @transaction_isolation;