mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
21 lines
386 B
Text
21 lines
386 B
Text
connection node_2;
|
|
connection node_1;
|
|
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;
|