diff options
Diffstat (limited to 'mysql-test/suite/gcol/inc/gcol_column_def_options.inc')
| -rw-r--r-- | mysql-test/suite/gcol/inc/gcol_column_def_options.inc | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/suite/gcol/inc/gcol_column_def_options.inc b/mysql-test/suite/gcol/inc/gcol_column_def_options.inc index 6f4a8ab7240..f4f654c9f46 100644 --- a/mysql-test/suite/gcol/inc/gcol_column_def_options.inc +++ b/mysql-test/suite/gcol/inc/gcol_column_def_options.inc @@ -134,12 +134,16 @@ drop table t1; create table t2 (a int); +--error ER_PARSE_ERROR create table t1 (a int, b int generated always as (a % 2) stored references t2(a)); +create table t1 (a int, b int generated always as (a % 2) stored); show create table t1; drop table t1; create table t1 (a int, b int generated always as (a % 2) virtual); --error ER_PARSE_ERROR alter table t1 modify b int generated always as (a % 2) stored references t2(a); +--error ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN +alter table t1 modify b int generated always as (a % 2) stored; show create table t1; drop table t1; drop table t2; |