diff options
Diffstat (limited to 'mysql-test/suite/vcol/r/cross_db.result')
-rw-r--r-- | mysql-test/suite/vcol/r/cross_db.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/suite/vcol/r/cross_db.result b/mysql-test/suite/vcol/r/cross_db.result new file mode 100644 index 00000000..c99f8e91 --- /dev/null +++ b/mysql-test/suite/vcol/r/cross_db.result @@ -0,0 +1,17 @@ +create database mysqltest1; +create table mysqltest1.t1 (i int, j int as (i) persistent); +show create table mysqltest1.t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `i` int(11) DEFAULT NULL, + `j` int(11) GENERATED ALWAYS AS (`i`) STORED +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +alter table mysqltest1.t1 add index (i); +show create table mysqltest1.t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `i` int(11) DEFAULT NULL, + `j` int(11) GENERATED ALWAYS AS (`i`) STORED, + KEY `i` (`i`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +drop database mysqltest1; |