Debian Codegraph @

mysql-test/suite/vcol/r/cross_db.result

raw
1 create database mysqltest1;
2 create table mysqltest1.t1 (i int, j int as (i) persistent);
3 show create table mysqltest1.t1;
4 Table Create Table
5 t1 CREATE TABLE `t1` (
6 `i` int(11) DEFAULT NULL,
7 `j` int(11) GENERATED ALWAYS AS (`i`) STORED
8 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
9 alter table mysqltest1.t1 add index (i);
10 show create table mysqltest1.t1;
11 Table Create Table
12 t1 CREATE TABLE `t1` (
13 `i` int(11) DEFAULT NULL,
14 `j` int(11) GENERATED ALWAYS AS (`i`) STORED,
15 KEY `i` (`i`)
16 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
17 drop database mysqltest1;