Debian Codegraph @

mysql-test/suite/memcached/r/memc262_instant_add_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 USE test;
7 DROP TABLE IF EXISTS t1;
8 CREATE TABLE t1 (c1 VARCHAR(32),
9 c2 VARCHAR(40),
10 c21 VARCHAR(40),
11 c22 VARCHAR(40),
12 c23 VARCHAR(40),
13 c24 VARCHAR(40),
14 c25 VARCHAR(40) DEFAULT 'world',
15 c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1))
16 ENGINE = INNODB;
17 INSERT INTO t1 VALUES ('D', 'Darmstadt', NULL,'1', 'dddddddddddddd', '1234', NULL, 0, 0, 0);
18 INSERT INTO t1 VALUES ('B', 'Berlin', 'Mitte', NULL, 'bbbbbbbbbbbbbb', '2345', '2012', 0, 0, 0);
19 INSERT INTO t1 VALUES ('C', 'Cottbus', 'West', '3', NULL, '3456', '2012', 0, 0, 0);
20 INSERT INTO t1 VALUES ('H', NULL, NULL, NULL, 'hhhhhhhhhh', NULL, NULL, 0, 0, 0);
21 ALTER TABLE t1 ADD COLUMN c26 INT DEFAULT 20, ALGORITHM = INSTANT;
22 ALTER TABLE t1 ADD COLUMN c27 BIGINT UNSIGNED DEFAULT 50, ALGORITHM = INSTANT;
23 ALTER TABLE t1 ADD COLUMN c28 VARCHAR(20) DEFAULT 'hello', ALGORITHM = INSTANT;
24 UPDATE t1 SET c27 = 100 WHERE c1 < 'D';
25 INSERT INTO innodb_memcache.containers VALUES ("desc_t1", "test", "t1",
26 "c1", "c2,c21,c22,c23,c24,c25,c26,c27,c28", "c3", "c4", "c5", "PRIMARY");
27 INSTALL PLUGIN daemon_memcached SONAME 'libmemcached.so';
28 Warnings:
29 Warning 1681 'InnoDB Memcached Plugin' is deprecated and will be removed in a future release.
30 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27,c28 FROM t1;
31 c1 c2 c21 c22 c23 c24 c25 c26 c27 c28
32 B Berlin Mitte NULL bbbbbbbbbbbbbb 2345 2012 20 100 hello
33 C Cottbus West 3 NULL 3456 2012 20 100 hello
34 D Darmstadt NULL 1 dddddddddddddd 1234 NULL 20 50 hello
35 H NULL NULL NULL hhhhhhhhhh NULL NULL 20 50 hello
36 Here are the memcached results with D,B,H,C:
37 Darmstadt||1|dddddddddddddd|1234||20|50|hello
38 Berlin|Mitte||bbbbbbbbbbbbbb|2345|2012|20|100|hello
39 |||hhhhhhhhhh|||20|50|hello
40 Cottbus|West|3||3456|2012|20|100|hello
41 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27,c28 FROM t1;
42 c1 c2 c21 c22 c23 c24 c25 c26 c27 c28
43 B Berlin Mitte NULL bbbbbbbbbbbbbb 2345 2012 20 100 hello
44 C Cottbus West 3 NULL 3456 2012 20 100 hello
45 D Darmstadt NULL 1 dddddddddddddd 1234 NULL 20 50 hello
46 H NULL NULL NULL hhhhhhhhhh NULL NULL 20 50 hello
47 Here are the memcached results after set:
48 Essen|5678|2012|'germany'|'western'|'city'|100|200|'Hello world'
49 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27,c28 FROM t1;
50 c1 c2 c21 c22 c23 c24 c25 c26 c27 c28
51 B Berlin Mitte NULL bbbbbbbbbbbbbb 2345 2012 20 100 hello
52 C Cottbus West 3 NULL 3456 2012 20 100 hello
53 D Darmstadt NULL 1 dddddddddddddd 1234 NULL 20 50 hello
54 E Essen 5678 2012 'germany' 'western' 'city' 100 200 'Hello world'
55 H NULL NULL NULL hhhhhhhhhh NULL NULL 20 50 hello
56 Here are the memcached results after add:
57 Frankfurt|Airport|2012||||||
58 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27,c28 FROM t1;
59 c1 c2 c21 c22 c23 c24 c25 c26 c27 c28
60 B Berlin Mitte NULL bbbbbbbbbbbbbb 2345 2012 20 100 hello
61 C Cottbus West 3 NULL 3456 2012 20 100 hello
62 D Darmstadt NULL 1 dddddddddddddd 1234 NULL 20 50 hello
63 E Essen 5678 2012 'germany' 'western' 'city' 100 200 'Hello world'
64 F Frankfurt Airport 2012 NULL NULL NULL NULL NULL NULL
65 H NULL NULL NULL hhhhhhhhhh NULL NULL 20 50 hello
66 Here are the memcached results after replace:
67 Frankfurt a.M.|Sachsenhausen|61|fffff|6789||||
68 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27,c28 FROM t1;
69 c1 c2 c21 c22 c23 c24 c25 c26 c27 c28
70 B Berlin Mitte NULL bbbbbbbbbbbbbb 2345 2012 20 100 hello
71 C Cottbus West 3 NULL 3456 2012 20 100 hello
72 D Darmstadt NULL 1 dddddddddddddd 1234 NULL 20 50 hello
73 E Essen 5678 2012 'germany' 'western' 'city' 100 200 'Hello world'
74 F Frankfurt a.M. Sachsenhausen 61 fffff 6789 NULL NULL NULL NULL
75 H NULL NULL NULL hhhhhhhhhh NULL NULL 20 50 hello
76 Here are the memcached results after delete:
77 Essen|5678|2012|'germany'|'western'|'city'|100|200|'Hello world'
78 SELECT c1,c2,c21,c22,c23,c24,c25,c26,c27,c28 FROM t1;
79 c1 c2 c21 c22 c23 c24 c25 c26 c27 c28
80 B Berlin Mitte NULL bbbbbbbbbbbbbb 2345 2012 20 100 hello
81 C Cottbus West 3 NULL 3456 2012 20 100 hello
82 D Darmstadt NULL 1 dddddddddddddd 1234 NULL 20 50 hello
83 E Essen 5678 2012 'germany' 'western' 'city' 100 200 'Hello world'
84 H NULL NULL NULL hhhhhhhhhh NULL NULL 20 50 hello
85 DROP TABLE t1;
86 UNINSTALL PLUGIN daemon_memcached;
87 DROP DATABASE innodb_memcache;
88 SET @@global.transaction_isolation= @transaction_isolation;