diff options
Diffstat (limited to 'mysql-test/suite/vcol/r/vcol_column_def_options_innodb.result')
-rw-r--r-- | mysql-test/suite/vcol/r/vcol_column_def_options_innodb.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/suite/vcol/r/vcol_column_def_options_innodb.result b/mysql-test/suite/vcol/r/vcol_column_def_options_innodb.result index 0f80365f6a7..c0008f8f179 100644 --- a/mysql-test/suite/vcol/r/vcol_column_def_options_innodb.result +++ b/mysql-test/suite/vcol/r/vcol_column_def_options_innodb.result @@ -1,4 +1,4 @@ -SET @@session.storage_engine = 'InnoDB'; +SET @@session.default_storage_engine = 'InnoDB'; # # Section 1. Wrong column definition options # - NOT NULL @@ -126,7 +126,7 @@ a b 2 0 drop table t1; create table t2 (a int); -create table t1 (a int, b int as (a % 2) persistent references t2(a)); +create table t1 (a int, b int as (a % 2) persistent); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( @@ -135,8 +135,8 @@ t1 CREATE TABLE `t1` ( ) ENGINE=InnoDB DEFAULT CHARSET=latin1 drop table t1; create table t1 (a int, b int as (a % 2)); -alter table t1 modify b int as (a % 2) persistent references t2(a); -ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'references t2(a)' at line 1 +alter table t1 modify b int as (a % 2) persistent; +ERROR HY000: This is not yet supported for generated columns show create table t1; Table Create Table t1 CREATE TABLE `t1` ( |