Debian Codegraph @

mysql-test/suite/innodb/r/virtual_no_storage.result

raw
1 CREATE TABLE t_8114 (a int) ENGINE = INNODB;
2 ALTER TABLE t_8114 ADD b INT GENERATED ALWAYS AS (a) VIRTUAL;
3 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE "%t_8114";
4 NAME
5 test/t_8114
6 SELECT NAME, POS, MTYPE, PRTYPE, LEN FROM INFORMATION_SCHEMA.INNODB_COLUMNS WHERE TABLE_ID IN (SELECT TABLE_ID FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE "%t_8114") ORDER BY NAME;
7 NAME POS MTYPE PRTYPE LEN
8 a 0 6 1027 4
9 b 65537 6 9219 4
10 INSERT INTO t_8114 VALUES (9, default);
11 INSERT INTO t_8114 VALUES (3, default);
12 INSERT INTO t_8114 VALUES (1, default);
13 INSERT INTO t_8114 VALUES (5, default);
14 SELECT * FROM t_8114;
15 a b
16 9 9
17 3 3
18 1 1
19 5 5
20 DROP TABLE t_8114;
21 CREATE TABLE t_8114 (Column_1 CHAR(5) GENERATED ALWAYS AS (PI()+5), Column_2 CHAR(5));
22 SELECT NAME, FLAG, N_COLS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE "%t_8114";
23 NAME FLAG N_COLS
24 test/t_8114 33 4
25 SELECT NAME, POS, MTYPE, PRTYPE, LEN FROM INFORMATION_SCHEMA.INNODB_COLUMNS WHERE TABLE_ID IN (SELECT TABLE_ID FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE "%t_8114") ORDER BY NAME;
26 NAME POS MTYPE PRTYPE LEN
27 Column_1 65536 13 16720126 20
28 Column_2 0 13 16711934 20
29 INSERT INTO t_8114 VALUES (default, "aa");
30 INSERT INTO t_8114 VALUES (default, "bb");
31 INSERT INTO t_8114 VALUES (default, "ee");
32 INSERT INTO t_8114 VALUES (default, "pp");
33 SELECT * FROM t_8114;
34 Column_1 Column_2
35 8.142 aa
36 8.142 bb
37 8.142 ee
38 8.142 pp
39 ALTER TABLE t_8114 DROP Column_1;
40 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE "%t_8114";
41 NAME
42 test/t_8114
43 SELECT NAME, POS, MTYPE, PRTYPE, LEN FROM INFORMATION_SCHEMA.INNODB_COLUMNS WHERE TABLE_ID IN (SELECT TABLE_ID FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE "%t_8114") ORDER BY NAME;
44 NAME POS MTYPE PRTYPE LEN
45 Column_2 0 13 16711934 20
46 SELECT * FROM t_8114;
47 Column_2
48 aa
49 bb
50 ee
51 pp
52 DROP TABLE t_8114;