Debian Codegraph @

mysql-test/suite/memcached/r/memc279_wrong_index.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 config_options VALUES("table_map_delimiter", ".");
7 INSERT INTO containers VALUES ("desct1", "test", "t1", "c1", "c2", "c3", "c4", "c5", "PRIMARY");
8 INSERT INTO containers VALUES ("desct2", "test", "t2", "c1", "c2", "c3", "c4", "c5", "PRIMARY");
9 INSERT INTO containers VALUES ("desct3", "test", "t1", "c1", "c2", "c3", "c4", "c5", "i1");
10 INSERT INTO containers VALUES ("desct4", "test", "t1", "c1", "c2", "c3", "c4", "c5", "i2");
11 INSERT INTO containers VALUES ("desct5", "test", "t1", "c1", "c2", "c3", "c4", "c5", "i3");
12 INSERT INTO containers VALUES ("desct6", "test", "t1", "c1", "c2", "c3", "c4", "c5", "i4");
13 use test;
14 CREATE TABLE t1 (
15 c1 VARCHAR(32),
16 c2 VARCHAR(512),
17 c3 INT,
18 c4 BIGINT UNSIGNED,
19 c5 INT,
20 primary key(c1,c5)
21 ) ENGINE = INNODB;
22 CREATE TABLE t2 (
23 c1 VARCHAR(32),
24 c2 VARCHAR(512),
25 c3 INT,
26 c4 BIGINT UNSIGNED,
27 c5 INT,
28 primary key(c3)
29 ) ENGINE = INNODB;
30 CREATE INDEX i1 ON t1(c1);
31 CREATE UNIQUE INDEX i2 ON t1(c1,c5);
32 CREATE UNIQUE INDEX i3 ON t1(c5);
33 CREATE UNIQUE INDEX i4 ON t1(c1);
34 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
35 Warnings:
36 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
37 DROP TABLE t1,t2;
38 UNINSTALL PLUGIN daemon_memcached;
39 DROP DATABASE innodb_memcache;
40 SET @@global.transaction_isolation= @transaction_isolation;