Debian Codegraph @

mysql-test/suite/memcached/r/memc296_alter_column.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", "c3", "c4", "c5", "PRIMARY");
8 USE test;
9 connect con1,localhost,root,,;
10 DROP TABLE IF EXISTS t1;
11 CREATE TABLE t1 (c1 VARCHAR(32),
12 c2 VARCHAR(1024),
13 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
14 ENGINE = INNODB;
15 INSERT INTO t1 VALUES ('D', 'Darmstadt', 0, 0, 0);
16 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
17 Warnings:
18 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
19 SELECT c1,c2 FROM t1;
20 c1 c2
21 D Darmstadt
22 SELECT c1,c2 FROM t1;
23 c1 c2
24 D Darmstadt
25 ALTER TABLE test.t1 ADD COLUMN j JSON;
26 CREATE PROCEDURE alter_column()
27 BEGIN
28 SELECT SLEEP(10);
29 ALTER TABLE test.t1 ADD COLUMN foo varchar(200) AS (j->'$.foo') VIRTUAL;
30 END//
31 connection con1;
32 set session lock_wait_timeout=1;
33 call alter_column();;
34 connection default;
35 Here are the memcached results with E:
36 Darmstadt
37 connection con1;
38 SLEEP(10)
39 0
40 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
41 connection default;
42 disconnect con1;
43 drop procedure alter_column;
44 DROP TABLE t1;
45 UNINSTALL PLUGIN daemon_memcached;
46 DROP DATABASE innodb_memcache;
47 SET @@global.transaction_isolation= @transaction_isolation;