summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/vcol/r/cross_db.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/vcol/r/cross_db.result')
-rw-r--r--mysql-test/suite/vcol/r/cross_db.result17
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;