Debian Codegraph @

mysql-test/suite/memcached/r/memc216_5_utf8.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 VARCHAR(40),
13 c22 VARCHAR(40),
14 c23 VARCHAR(40),
15 c24 VARCHAR(40),
16 c25 VARCHAR(40),
17 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
18 ENGINE = INNODB DEFAULT CHARSET UTF8;
19 Warnings:
20 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
21 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City','1', 'dddddddddddddd', '1234', '2012', 0, 0, 0);
22 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', '2', 'bbbbbbbbbbbbbb', '2345', '2012', 0, 0, 0);
23 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', '3', 'cccccccccccccc', '3456', '2012', 0, 0 ,0);
24 INSERT INTO t1 VALUES ('M', 'München', 'Süd', '4', 'ÜÖÄßüöä', '4567', '2012', 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 SHOW CREATE TABLE t1;
29 Table Create Table
30 t1 CREATE TABLE `t1` (
31 `c1` varchar(32) NOT NULL,
32 `c2` varchar(40) DEFAULT NULL,
33 `c21` varchar(40) DEFAULT NULL,
34 `c22` varchar(40) DEFAULT NULL,
35 `c23` varchar(40) DEFAULT NULL,
36 `c24` varchar(40) DEFAULT NULL,
37 `c25` varchar(40) DEFAULT NULL,
38 `c3` int DEFAULT NULL,
39 `c4` bigint unsigned DEFAULT NULL,
40 `c5` int DEFAULT NULL,
41 PRIMARY KEY (`c1`)
42 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
43 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
44 c1 c2 c21 c22 c23 c24 c25
45 B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
46 C Cottbus West 3 cccccccccccccc 3456 2012
47 D Darmstadt City 1 dddddddddddddd 1234 2012
48 M München Süd 4 ÜÖÄßüöä 4567 2012
49 Here are the memcached results with D,B,M,C:
50 Darmstadt|City|1|dddddddddddddd|1234|2012
51 Berlin|Mitte|2|bbbbbbbbbbbbbb|2345|2012
52 München|Süd|4|ÜÖÄßüöä|4567|2012
53 Cottbus|West|3|cccccccccccccc|3456|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 M München Süd 4 ÜÖÄßüöä 4567 2012
60 Here are the memcached results after set:
61 Ülzen|City|5|üöäßÜÖÄ|5678|2012
62 Beijing|City|6|fffffffff|6789|2012
63 Shanghai|City|7|fffffffff|7890|2012
64 Wuhan|City|8|eeeeeeeee|8901|2012
65 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
66 c1 c2 c21 c22 c23 c24 c25
67 Shanghai City 7 fffffffff 7890 2012
68 01234567890123456789012345678901 Wuhan City 8 eeeeeeeee 8901 2012
69 B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
70 C Cottbus West 3 cccccccccccccc 3456 2012
71 D Darmstadt City 1 dddddddddddddd 1234 2012
72 M München Süd 4 ÜÖÄßüöä 4567 2012
73 _ Beijing City 6 fffffffff 6789 2012
74 Ü Ülzen City 5 üöäßÜÖÄ 5678 2012
75 DROP TABLE t1;
76 UNINSTALL PLUGIN daemon_memcached;
77 DROP TABLE IF EXISTS t1;
78 CREATE TABLE t1 (c1 CHAR(32),
79 c2 CHAR(40),
80 c21 CHAR(40),
81 c22 CHAR(40),
82 c23 CHAR(40),
83 c24 CHAR(40),
84 c25 CHAR(40),
85 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
86 ENGINE = INNODB DEFAULT CHARSET UTF8;
87 Warnings:
88 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
89 INSERT INTO t1 VALUES ('D', 'Darmstadt', 'City','1', 'dddddddddddddd', '1234', '2012', 0, 0, 0);
90 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', '2', 'bbbbbbbbbbbbbb', '2345', '2012', 0, 0, 0);
91 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', '3', 'cccccccccccccc', '3456', '2012', 0, 0 ,0);
92 INSERT INTO t1 VALUES ('M', 'München', 'Süd', '4', 'ÜÖÄßüöä', '4567', '2012', 0, 0, 0);
93 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
94 Warnings:
95 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
96 SHOW CREATE TABLE t1;
97 Table Create Table
98 t1 CREATE TABLE `t1` (
99 `c1` char(32) NOT NULL,
100 `c2` char(40) DEFAULT NULL,
101 `c21` char(40) DEFAULT NULL,
102 `c22` char(40) DEFAULT NULL,
103 `c23` char(40) DEFAULT NULL,
104 `c24` char(40) DEFAULT NULL,
105 `c25` char(40) DEFAULT NULL,
106 `c3` int DEFAULT NULL,
107 `c4` bigint unsigned DEFAULT NULL,
108 `c5` int DEFAULT NULL,
109 PRIMARY KEY (`c1`)
110 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
111 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
112 c1 c2 c21 c22 c23 c24 c25
113 B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
114 C Cottbus West 3 cccccccccccccc 3456 2012
115 D Darmstadt City 1 dddddddddddddd 1234 2012
116 M München Süd 4 ÜÖÄßüöä 4567 2012
117 Here are the memcached results with D,B,M,C:
118 Darmstadt |City |1 |dddddddddddddd |1234 |2012
119 Berlin |Mitte |2 |bbbbbbbbbbbbbb |2345 |2012
120 München |Süd |4 |ÜÖÄßüöä |4567 |2012
121 Cottbus |West |3 |cccccccccccccc |3456 |2012
122 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
123 c1 c2 c21 c22 c23 c24 c25
124 B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
125 C Cottbus West 3 cccccccccccccc 3456 2012
126 D Darmstadt City 1 dddddddddddddd 1234 2012
127 M München Süd 4 ÜÖÄßüöä 4567 2012
128 Here are the memcached results after set:
129 Ülzen |City |5 |üöäßÜÖÄ |5678 |2012
130 Beijing |City |6 |fffffffff |6789 |2012
131 Shanghai |City |7 |fffffffff |7890 |2012
132 Wuhan |City |8 |eeeeeeeee |8901 |2012
133 SELECT c1,c2,c21,c22,c23,c24,c25 FROM t1;
134 c1 c2 c21 c22 c23 c24 c25
135 Shanghai City 7 fffffffff 7890 2012
136 01234567890123456789012345678901 Wuhan City 8 eeeeeeeee 8901 2012
137 B Berlin Mitte 2 bbbbbbbbbbbbbb 2345 2012
138 C Cottbus West 3 cccccccccccccc 3456 2012
139 D Darmstadt City 1 dddddddddddddd 1234 2012
140 M München Süd 4 ÜÖÄßüöä 4567 2012
141 _ Beijing City 6 fffffffff 6789 2012
142 Ü Ülzen City 5 üöäßÜÖÄ 5678 2012
143 DROP TABLE t1;
144 UNINSTALL PLUGIN daemon_memcached;
145 DROP DATABASE innodb_memcache;
146 SET @@global.transaction_isolation= @transaction_isolation;