SET @transaction_isolation= @@global.transaction_isolation;
SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
INSERT INTO cache_policies VALUES("cache_policy", "innodb_only",
"innodb_only", "innodb_only", "innodb_only");
INSERT INTO config_options VALUES("separator", "|");
INSERT INTO config_options VALUES("table_map_delimiter", ".");
INSERT INTO containers VALUES ("desct11", "test", "t1",
"c1", "c2,c21,c22,c23,c24,c25,c26,c27", "c3", "c4", "c5",
"PRIMARY");
INSERT INTO containers VALUES ("desct15", "test", "t1",
"c23", "c1,c21,c22,c24", "c3", "c4", "c5", "i15");
USE test;
DROP TABLE IF EXISTS t1,t2;
CREATE TABLE t1        (c1 VARCHAR(32),
c2  VARCHAR(512),
c21 VARCHAR(767),
c22 VARCHAR(512),
c23 VARCHAR(128),
c24 VARCHAR(24),
c25 VARCHAR(512),
c26 VARCHAR(128),
c27 VARCHAR(128),
c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
ENGINE = INNODB;
INSERT INTO t1 VALUES ('D','Duesseldorf','City','98765','Hafen','1','A','a','Z',0,0,0);
INSERT INTO t1 VALUES ('O','Oldenburg','Mitte','87654','Deich','2','B','b','Y',0,0,0);
INSERT INTO t1 VALUES ('K','Koeln','West','76543','Rhein','3','C','c','X',0,0,0);
INSERT INTO t1 VALUES ('S','Stuttgart','Nord','65432','Fernsehturm','4','D','d','U',0,0,0);
CREATE UNIQUE INDEX i15 ON t1(c23);
CREATE UNIQUE INDEX u24 ON t1(c24);
INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1;
c1	c2	c21	c22	c23	c24	c25	c26	c27
D	Duesseldorf	City	98765	Hafen	1	A	a	Z
K	Koeln	West	76543	Rhein	3	C	c	X
O	Oldenburg	Mitte	87654	Deich	2	B	b	Y
S	Stuttgart	Nord	65432	Fernsehturm	4	D	d	U
Here are the memcached results after set in desct15:
u1|u2|u3|u4
v1|v2|v3|v4
v1|v2|v3|v4
SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1;
c1	c2	c21	c22	c23	c24	c25	c26	c27
D	Duesseldorf	City	98765	Hafen	1	A	a	Z
K	Koeln	West	76543	Rhein	3	C	c	X
O	Oldenburg	Mitte	87654	Deich	2	B	b	Y
S	Stuttgart	Nord	65432	Fernsehturm	4	D	d	U
u1	NULL	u2	u3	Zebra	u4	NULL	NULL	NULL
v1	NULL	v2	v3	Leopard	v4	NULL	NULL	NULL
SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27 FROM t1;
c1	c2	c21	c22	c23	c24	c25	c26	c27
D	Duesseldorf	City	98765	Hafen	1	A	a	Z
K	Koeln	West	76543	Rhein	3	C	c	X
O	Oldenburg	Mitte	87654	Deich	2	B	b	Y
S	Stuttgart	Nord	65432	Fernsehturm	4	D	d	U
u1	NULL	u2	u3	Zebra	u4	NULL	NULL	NULL
v1	NULL	v2	v3	Leopard	v4	NULL	NULL	NULL
DROP TABLE t1;
UNINSTALL PLUGIN daemon_memcached;
DROP DATABASE innodb_memcache;
SET @@global.transaction_isolation= @transaction_isolation;