Debian Codegraph @

mysql-test/suite/galera/r/galera_virtual_column.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE p (id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT) ENGINE = InnoDB;
5 CREATE TABLE c (id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, pid INT UNSIGNED, bitmap TINYINT UNSIGNED NOT NULL DEFAULT 0, bitmap5 TINYINT UNSIGNED GENERATED ALWAYS AS (bitmap&(1<<5)) VIRTUAL, FOREIGN KEY (pid) REFERENCES p (id) ON DELETE CASCADE ON UPDATE CASCADE);
6 CREATE INDEX bitmap5 ON c(bitmap5) USING BTREE;
7 INSERT INTO p VALUES(1);
8 INSERT INTO c(pid) VALUES(1);
9 connection node_2;
10 connection node_1;
11 DELETE FROM p WHERE id=1;
12 SELECT * FROM p;
13 id
14 SELECT * FROM c;
15 id pid bitmap bitmap5
16 connection node_2;
17 connection node_1;
18 DROP TABLE c;
19 DROP TABLE p;