Debian Codegraph @

mysql-test/suite/gcol/r/innodb_virtual_rebuild.result

raw
1 CREATE TABLE t1 (j SERIAL, i INT, v INT AS (i) VIRTUAL) ENGINE=InnoDB;
2 CREATE TABLE t2 (j SERIAL, i INT, v INT AS (i) VIRTUAL) ENGINE=InnoDB
3 ROW_FORMAT=REDUNDANT;
4 CREATE TABLE t3 (i INT, v INT AS (i) VIRTUAL) ENGINE=InnoDB;
5 CREATE TABLE t4 (i INT, v INT AS (i) VIRTUAL) ENGINE=InnoDB
6 ROW_FORMAT=REDUNDANT;
7 INSERT INTO t4 SET i=1;
8 ALTER TABLE t4 ADD INDEX(v), LOCK=NONE;
9 ALTER TABLE t4 ADD COLUMN k INT, ALGORITHM=INPLACE, LOCK=NONE;
10 ERROR 0A000: LOCK=NONE is not supported. Reason: online rebuild with indexed virtual columns. Try LOCK=SHARED
11 ALTER TABLE t4 DROP k, ALGORITHM=INPLACE, LOCK=NONE;
12 ERROR 42000: Can't DROP COLUMN `k`; check that it exists
13 ALTER TABLE t4 DROP INDEX v, LOCK=NONE;
14 INSERT INTO t3 SET i=1;
15 ALTER TABLE t3 ADD INDEX(v), LOCK=NONE;
16 ALTER TABLE t3 ADD COLUMN k INT, ALGORITHM=INPLACE, LOCK=NONE;
17 ERROR 0A000: LOCK=NONE is not supported. Reason: online rebuild with indexed virtual columns. Try LOCK=SHARED
18 ALTER TABLE t3 DROP k, ALGORITHM=INPLACE, LOCK=NONE;
19 ERROR 42000: Can't DROP COLUMN `k`; check that it exists
20 ALTER TABLE t3 DROP INDEX v, LOCK=NONE;
21 INSERT INTO t2 SET i=1;
22 ALTER TABLE t2 ADD INDEX(v), LOCK=NONE;
23 ALTER TABLE t2 ADD COLUMN k INT, ALGORITHM=INPLACE, LOCK=NONE;
24 ERROR 0A000: LOCK=NONE is not supported. Reason: online rebuild with indexed virtual columns. Try LOCK=SHARED
25 ALTER TABLE t2 DROP k, ALGORITHM=INPLACE, LOCK=NONE;
26 ERROR 42000: Can't DROP COLUMN `k`; check that it exists
27 ALTER TABLE t2 DROP INDEX v, LOCK=NONE;
28 INSERT INTO t1 SET i=1;
29 ALTER TABLE t1 ADD INDEX(v), LOCK=NONE;
30 ALTER TABLE t1 ADD COLUMN k INT, ALGORITHM=INPLACE, LOCK=NONE;
31 ERROR 0A000: LOCK=NONE is not supported. Reason: online rebuild with indexed virtual columns. Try LOCK=SHARED
32 ALTER TABLE t1 DROP k, ALGORITHM=INPLACE, LOCK=NONE;
33 ERROR 42000: Can't DROP COLUMN `k`; check that it exists
34 ALTER TABLE t1 DROP INDEX v, LOCK=NONE;
35 connect ddl,localhost,root,,test;
36 connection default;
37 connection ddl;
38 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL copied WAIT_FOR dml';
39 ALTER TABLE t4 FORCE;
40 connection default;
41 SET DEBUG_SYNC = 'now WAIT_FOR copied';
42 BEGIN;
43 UPDATE t4 SET i = 0;
44 ROLLBACK;
45 SET DEBUG_SYNC = 'now SIGNAL dml';
46 connection ddl;
47 connection default;
48 SELECT * FROM t4;
49 i v
50 1 1
51 DROP TABLE t4;
52 connection ddl;
53 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL copied WAIT_FOR dml';
54 ALTER TABLE t3 FORCE;
55 connection default;
56 SET DEBUG_SYNC = 'now WAIT_FOR copied';
57 BEGIN;
58 UPDATE t3 SET i = 0;
59 ROLLBACK;
60 SET DEBUG_SYNC = 'now SIGNAL dml';
61 connection ddl;
62 connection default;
63 SELECT * FROM t3;
64 i v
65 1 1
66 DROP TABLE t3;
67 connection ddl;
68 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL copied WAIT_FOR dml';
69 ALTER TABLE t2 FORCE;
70 connection default;
71 SET DEBUG_SYNC = 'now WAIT_FOR copied';
72 BEGIN;
73 UPDATE t2 SET i = 0;
74 ROLLBACK;
75 SET DEBUG_SYNC = 'now SIGNAL dml';
76 connection ddl;
77 connection default;
78 SELECT * FROM t2;
79 j i v
80 1 1 1
81 DROP TABLE t2;
82 connection ddl;
83 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL copied WAIT_FOR dml';
84 ALTER TABLE t1 FORCE;
85 connection default;
86 SET DEBUG_SYNC = 'now WAIT_FOR copied';
87 BEGIN;
88 UPDATE t1 SET i = 0;
89 ROLLBACK;
90 SET DEBUG_SYNC = 'now SIGNAL dml';
91 connection ddl;
92 connection default;
93 SELECT * FROM t1;
94 j i v
95 1 1 1
96 DROP TABLE t1;
97 disconnect ddl;
98 SET DEBUG_SYNC = 'RESET';