Debian Codegraph @

mysql-test/suite/innodb/r/innodb-virtual-columns-debug.result

raw
1 CREATE TABLE t1 (a INT, b INT AS (a), KEY(b)) ENGINE=InnoDB;
2 INSERT INTO t1 () VALUES (),();
3 connect con1,localhost,root,,test;
4 ALTER TABLE t1 ADD COLUMN x INT as (a), add key(x), ALGORITHM=COPY;
5 SET debug_sync= "ib_open_after_dict_open SIGNAL delete_open WAIT_FOR another_open";
6 DELETE FROM t1;
7 connection default;
8 SET debug_sync= "now WAIT_FOR delete_open";
9 SELECT a FROM t1;
10 a
11 NULL
12 NULL
13 SET debug_sync= "now SIGNAL another_open";
14 connection con1;
15 disconnect con1;
16 connection default;
17 SET debug_sync= "RESET";
18 DROP TABLE t1;