Debian Codegraph @

mysql-test/suite/memcached/r/memc295_virtual_block.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", "0" ,"0", "0", "PRIMARY");
8 USE test;
9 DROP TABLE IF EXISTS t1;
10 CREATE TABLE t1(
11 c1 VARCHAR(30) PRIMARY KEY,
12 c2 INT,
13 c3 INT GENERATED ALWAYS AS (c2 + c2) VIRTUAL
14 ) ENGINE=INNODB;
15 INSERT INTO t1(c1, c2) VALUES("Wayne", 1);
16 INSERT INTO t1(c1, c2) VALUES("Stark", 2);
17 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
18 Warnings:
19 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
20 show variables like 'daemon_memcached_option';
21 Variable_name Value
22 daemon_memcached_option -m128 -p11295
23 SELECT c1,c2 FROM t1;
24 c1 c2
25 Stark 2
26 Wayne 1
27 NO_RESULT
28 SELECT c1,c2 FROM t1;
29 c1 c2
30 Stark 2
31 Wayne 1
32 Set Mycroft|3:
33 Error: Mycroft|3 cannot be inserted.
34 SELECT c1,c2 FROM t1;
35 c1 c2
36 Stark 2
37 Wayne 1
38 drop table t1;
39 UNINSTALL PLUGIN daemon_memcached;
40 DROP DATABASE innodb_memcache;
41 SET @@global.transaction_isolation= @transaction_isolation;