Debian Codegraph @

mysql-test/suite/gcol/inc/gcol_unsupported_storage_engines.inc

raw
1 ################################################################################
2 # inc/gcol_unsupported_storage_engines.inc #
3 # #
4 # Purpose: #
5 # Ensure that defining a generated column for an unsupported table type #
6 # results in a graceful error. #
7 # #
8 #------------------------------------------------------------------------------#
9 # Original Author: Andrey Zhakov #
10 # Original Date: 2008-09-02 #
11 # Change Author: #
12 # Change Date: #
13 # Change: #
14 ################################################################################
15
16 --error ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN
17 create table t1 (a int, b int generated always as (a+1) virtual);
18 create table t1 (a int);
19 --error ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN
20 alter table t1 add column b int generated always as (a+1) virtual;
21 drop table t1;