mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
f93e087d74
Virtual column fields are not found in prebuilt data type, so we should match InnoDB fields with `get_innobase_type_from_mysql_type` method. Reviewed-by: Jan Lindström <jan.lindstrom@mariadb.com>
10 lines
262 B
Text
10 lines
262 B
Text
--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;
|