mysql-test/suite/galera/t/galera_virtual_blob.test


1
2
3
4
5
6
7
8
9
10

--source include/galera_cluster.inc

CREATE TABLE t (f INT GENERATED ALWAYS AS (a+b)VIRTUAL,a INT,b INT,h BLOB);
INSERT INTO t (a,b)VALUES(0,0), (0,0), (0,0), (0,0), (0,0);
SELECT * from t;

--connection node_2
SELECT * from t;
--connection node_1
DROP TABLE t;