| 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 config_options VALUES("table_map_delimiter", "."); |
| 7 |
INSERT INTO containers VALUES ("desct11", "test", "t1", |
| 8 |
"c1", "c2,c21,c22,c23,c24,c25,c26,c27", "c3", "c4", "c5", |
| 9 |
"PRIMARY"); |
| 10 |
INSERT INTO containers VALUES ("desct12", "test", "t1", |
| 11 |
"c2", "c1, c2", "c3", "c4", "c5", "i12"); |
| 12 |
INSERT INTO containers VALUES ("desct13", "test", "t1", |
| 13 |
"c2", "c1,c21", "c3", "c4", "c5", "i12"); |
| 14 |
INSERT INTO containers VALUES ("desct14", "test", "t1", |
| 15 |
"c21", "c1,c23,c22", "c3", "c4", "c5", "i14"); |
| 16 |
INSERT INTO containers VALUES ("desct15", "test", "t1", |
| 17 |
"c23", "c1,c21,c22,c24", "c3", "c4", "c5", "i15"); |
| 18 |
INSERT INTO containers VALUES ("desct16", "test", "t1", |
| 19 |
"c25", "c23,c24,c27,c1", "c3", "c4", "c5", "i16"); |
| 20 |
INSERT INTO containers VALUES ("desct17", "test", "t1", |
| 21 |
"c26", "c2, c1", "c3", "c4", "c5", "i17"); |
| 22 |
USE test; |
| 23 |
DROP TABLE IF EXISTS t1,t2; |
| 24 |
CREATE TABLE t1 (c1 VARCHAR(32), |
| 25 |
c2 VARCHAR(512), |
| 26 |
c21 VARCHAR(767), |
| 27 |
c22 VARCHAR(512), |
| 28 |
c23 VARCHAR(128), |
| 29 |
c24 VARCHAR(24), |
| 30 |
c25 VARCHAR(512), |
| 31 |
c26 VARCHAR(128), |
| 32 |
c27 VARCHAR(128), |
| 33 |
c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1)) |
| 34 |
ENGINE = INNODB; |
| 35 |
INSERT INTO t1 VALUES ('D','Duesseldorf','City','98765','Hafen','1','A','a','Z',0,0,0); |
| 36 |
INSERT INTO t1 VALUES ('O','Oldenburg','Mitte','87654','Deich','2','B','b','Y',0,0,0); |
| 37 |
INSERT INTO t1 VALUES ('K','Koeln','West','76543','Rhein','3','C','c','X',0,0,0); |
| 38 |
INSERT INTO t1 VALUES ('S','Stuttgart','Nord','65432','Fernsehturm','4','D','d','U',0,0,0); |
| 39 |
CREATE UNIQUE INDEX i12 ON t1(c2); |
| 40 |
CREATE UNIQUE INDEX i14 ON t1(c21); |
| 41 |
CREATE UNIQUE INDEX i15 ON t1(c23); |
| 42 |
CREATE UNIQUE INDEX i16 ON t1(c25); |
| 43 |
CREATE UNIQUE INDEX i17 ON t1(c26); |
| 44 |
INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so'; |
| 45 |
Warnings: |
| 46 |
Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release. |
| 47 |
SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1; |
| 48 |
c1 c2 c21 c22 c23 c24 c25 c26 c27 |
| 49 |
D Duesseldorf City 98765 Hafen 1 A a Z |
| 50 |
K Koeln West 76543 Rhein 3 C c X |
| 51 |
O Oldenburg Mitte 87654 Deich 2 B b Y |
| 52 |
S Stuttgart Nord 65432 Fernsehturm 4 D d U |
| 53 |
Here are the memcached results with D,O,K,S of default: |
| 54 |
Duesseldorf|City|98765|Hafen|1|A|a|Z |
| 55 |
Oldenburg|Mitte|87654|Deich|2|B|b|Y |
| 56 |
Koeln|West|76543|Rhein|3|C|c|X |
| 57 |
Stuttgart|Nord|65432|Fernsehturm|4|D|d|U |
| 58 |
Here are the memcached results with c1 of desct11: |
| 59 |
Duesseldorf|City|98765|Hafen|1|A|a|Z |
| 60 |
Oldenburg|Mitte|87654|Deich|2|B|b|Y |
| 61 |
Koeln|West|76543|Rhein|3|C|c|X |
| 62 |
Stuttgart|Nord|65432|Fernsehturm|4|D|d|U |
| 63 |
Here are the memcached results with c2 of desct13: |
| 64 |
test/t1 |
| 65 |
D|City |
| 66 |
O|Mitte |
| 67 |
K|West |
| 68 |
S|Nord |
| 69 |
Here are the memcached results with c2 of desct12: |
| 70 |
test/t1 |
| 71 |
D|Duesseldorf |
| 72 |
O|Oldenburg |
| 73 |
K|Koeln |
| 74 |
S|Stuttgart |
| 75 |
Here are the memcached results with c2,c21,c22 of desct14: |
| 76 |
D|Hafen|98765 |
| 77 |
O|Deich|87654 |
| 78 |
K|Rhein|76543 |
| 79 |
S|Fernsehturm|65432 |
| 80 |
Here are the memcached results with c2,c21,c22,c23 of desct15: |
| 81 |
D|City|98765|1 |
| 82 |
O|Mitte|87654|2 |
| 83 |
K|West|76543|3 |
| 84 |
S|Nord|65432|4 |
| 85 |
Here are the memcached results with c23,c24,c25,c26 of desct16: |
| 86 |
Hafen|1|Z|D |
| 87 |
Rhein|3|X|K |
| 88 |
Fernsehturm|4|U|S |
| 89 |
Deich|2|Y|O |
| 90 |
Here are the memcached results with c26 of desct17: |
| 91 |
Koeln|K |
| 92 |
Oldenburg|O |
| 93 |
Duesseldorf|D |
| 94 |
Stuttgart|S |
| 95 |
SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1; |
| 96 |
c1 c2 c21 c22 c23 c24 c25 c26 c27 |
| 97 |
D Duesseldorf City 98765 Hafen 1 A a Z |
| 98 |
K Koeln West 76543 Rhein 3 C c X |
| 99 |
O Oldenburg Mitte 87654 Deich 2 B b Y |
| 100 |
S Stuttgart Nord 65432 Fernsehturm 4 D d U |
| 101 |
Here are the memcached results after set in desct12: |
| 102 |
E|Essen |
| 103 |
SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1; |
| 104 |
c1 c2 c21 c22 c23 c24 c25 c26 c27 |
| 105 |
D Duesseldorf City 98765 Hafen 1 A a Z |
| 106 |
E Essen NULL NULL NULL NULL NULL NULL NULL |
| 107 |
K Koeln West 76543 Rhein 3 C c X |
| 108 |
O Oldenburg Mitte 87654 Deich 2 B b Y |
| 109 |
S Stuttgart Nord 65432 Fernsehturm 4 D d U |
| 110 |
Here are the memcached results after set in desct13: |
| 111 |
E|Neustadt |
| 112 |
SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1; |
| 113 |
c1 c2 c21 c22 c23 c24 c25 c26 c27 |
| 114 |
D Duesseldorf City 98765 Hafen 1 A a Z |
| 115 |
E Essen Neustadt NULL NULL NULL NULL NULL NULL |
| 116 |
K Koeln West 76543 Rhein 3 C c X |
| 117 |
O Oldenburg Mitte 87654 Deich 2 B b Y |
| 118 |
S Stuttgart Nord 65432 Fernsehturm 4 D d U |
| 119 |
Here are the memcached results after set in desct14: |
| 120 |
SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1; |
| 121 |
c1 c2 c21 c22 c23 c24 c25 c26 c27 |
| 122 |
D Duesseldorf City 98765 Hafen 1 A a Z |
| 123 |
E Essen Neustadt NULL NULL NULL NULL NULL NULL |
| 124 |
K Koeln West 76543 Rhein 3 C c X |
| 125 |
O Oldenburg Mitte 87654 Deich 2 B b Y |
| 126 |
S Stuttgart Nord 65432 Fernsehturm 4 D d U |
| 127 |
Here are the memcached results after set in desct15: |
| 128 |
SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1; |
| 129 |
c1 c2 c21 c22 c23 c24 c25 c26 c27 |
| 130 |
D Duesseldorf City 98765 Hafen 1 A a Z |
| 131 |
E Essen Neustadt NULL NULL NULL NULL NULL NULL |
| 132 |
K Koeln West 76543 Rhein 3 C c X |
| 133 |
O Oldenburg Mitte 87654 Deich 2 B b Y |
| 134 |
S Stuttgart Nord 65432 Fernsehturm 4 D d U |
| 135 |
Here are the memcached results after set in desct16: |
| 136 |
SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1; |
| 137 |
c1 c2 c21 c22 c23 c24 c25 c26 c27 |
| 138 |
D Duesseldorf City 98765 Hafen 1 A a Z |
| 139 |
E Essen Neustadt NULL NULL NULL NULL NULL NULL |
| 140 |
K Koeln West 76543 Rhein 3 C c X |
| 141 |
O Oldenburg Mitte 87654 Deich 2 B b Y |
| 142 |
S Stuttgart Nord 65432 Fernsehturm 4 D d U |
| 143 |
Here are the memcached results after set in desct17: |
| 144 |
SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1; |
| 145 |
c1 c2 c21 c22 c23 c24 c25 c26 c27 |
| 146 |
D Duesseldorf City 98765 Hafen 1 A a Z |
| 147 |
E Essen Neustadt NULL NULL NULL NULL NULL NULL |
| 148 |
K Koeln West 76543 Rhein 3 C c X |
| 149 |
O Oldenburg Mitte 87654 Deich 2 B b Y |
| 150 |
S Stuttgart Nord 65432 Fernsehturm 4 D d U |
| 151 |
DROP TABLE t1; |
| 152 |
UNINSTALL PLUGIN daemon_memcached; |
| 153 |
DROP DATABASE innodb_memcache; |
| 154 |
SET @@global.transaction_isolation= @transaction_isolation; |