Debian Codegraph @

mysql-test/suite/memcached/r/memc282_time_expire.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 #
8 #Bug 20400373 INNODB MEMCACHE CRASH WHEN RETRIEVING EXPIRED
9 # RECORD WITH @@ TABLE MAPPING
10 INSERT INTO containers VALUES ("desc_t1", "test", "t1",
11 "c1", "c2", "c3", "c4", "c5", "PRIMARY");
12 INSERT INTO containers VALUES ('bb','test','demo','c1','c1,c22','c3',
13 'c4','c5','PRIMARY');
14 USE test;
15 DROP TABLE IF EXISTS t1;
16 DROP TABLE IF EXISTS demo;
17 CREATE TABLE t1 (c1 VARCHAR(32),
18 c2 VARCHAR(1024),
19 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
20 ENGINE = INNODB;
21 INSERT INTO t1 VALUES ('D', 'Darmstadt', 0, 0, 0);
22 CREATE TABLE demo (c1 VARCHAR(32) PRIMARY KEY NOT NULL,
23 c21 VARCHAR(1024),
24 c22 VARCHAR(1024),
25 c3 INT(11), c4 BIGINT(20) UNSIGNED, c5 INT(11))
26 ENGINE = INNODB;
27 Warnings:
28 Warning 1681 Integer display width is deprecated and will be removed in a future release.
29 Warning 1681 Integer display width is deprecated and will be removed in a future release.
30 Warning 1681 Integer display width is deprecated and will be removed in a future release.
31 INSERT INTO demo VALUES('b','aa','aa',0,2,unix_timestamp()-60);
32 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
33 Warnings:
34 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
35 SELECT c1,c2 FROM t1;
36 c1 c2
37 D Darmstadt
38 SELECT c1,c21 FROM demo;
39 c1 c21
40 b aa
41 DROP TABLE t1;
42 DROP TABLE demo;
43 UNINSTALL PLUGIN daemon_memcached;
44 DROP DATABASE innodb_memcache;
45 SET @@global.transaction_isolation= @transaction_isolation;