1let $MYSQLD_DATADIR= `select @@datadir`; 2 3--echo # 4--echo # Test that we can use tables created in MySQL 5.7 5--echo # 6 7--copy_file std_data/mysql57_virtual.frm $MYSQLD_DATADIR/test/mysql57_virtual.frm 8--copy_file std_data/mysql57_virtual.MYD $MYSQLD_DATADIR/test/mysql57_virtual.MYD 9--copy_file std_data/mysql57_virtual.MYI $MYSQLD_DATADIR/test/mysql57_virtual.MYI 10 11SHOW CREATE TABLE mysql57_virtual; 12insert into mysql57_virtual (a) values (1),(2); 13select * from mysql57_virtual; 14 15# We can't do online changes, as the MariaDB storage is incompatible with MySQL 16--error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON 17alter online table mysql57_virtual comment "I am now a MariaDB table"; 18 19alter table mysql57_virtual comment "I am now a MariaDB table"; 20SHOW CREATE TABLE mysql57_virtual; 21DROP TABLE mysql57_virtual; 22 23--echo # 24--echo # Check MySQL 5.7 syntax 25--echo # 26 27create table t1 (a int, b int generated always as (a+1) STORED, c int generated always as (a+2) VIRTUAL); 28show create table t1; 29drop table t1; 30