diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-04-09 14:32:06 +0300 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-04-09 14:32:06 +0300 |
commit | 450c017c2d9e490d92c949d5164b4a99b6b3f5db (patch) | |
tree | e050b47636fe0c2019fe38fadee8d763c211ba3f /mysql-test/suite/galera | |
parent | 4c80dcda46e4183df00f9fdb35ed08975e55e8f8 (diff) | |
parent | 5a3151bcda2f279091a1e2f049a7d11cd91065d6 (diff) | |
download | mariadb-git-450c017c2d9e490d92c949d5164b4a99b6b3f5db.tar.gz |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/suite/galera')
-rw-r--r-- | mysql-test/suite/galera/r/galera_virtual_blob.result | 19 | ||||
-rw-r--r-- | mysql-test/suite/galera/t/galera_virtual_blob.test | 10 |
2 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_virtual_blob.result b/mysql-test/suite/galera/r/galera_virtual_blob.result new file mode 100644 index 00000000000..91952b1d52d --- /dev/null +++ b/mysql-test/suite/galera/r/galera_virtual_blob.result @@ -0,0 +1,19 @@ +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; +f a b h +0 0 0 NULL +0 0 0 NULL +0 0 0 NULL +0 0 0 NULL +0 0 0 NULL +connection node_2; +SELECT * from t; +f a b h +0 0 0 NULL +0 0 0 NULL +0 0 0 NULL +0 0 0 NULL +0 0 0 NULL +connection node_1; +DROP TABLE t; diff --git a/mysql-test/suite/galera/t/galera_virtual_blob.test b/mysql-test/suite/galera/t/galera_virtual_blob.test new file mode 100644 index 00000000000..a10e3025668 --- /dev/null +++ b/mysql-test/suite/galera/t/galera_virtual_blob.test @@ -0,0 +1,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; |