Debian Codegraph @

mysql-test/suite/vcol/inc/vcol_unsupported_storage_engines.inc

raw
1 ################################################################################
2 # inc/vcol_unsupported_storage_engines.inc #
3 # #
4 # Purpose: #
5 # Ensure that defining a virtual 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: Oleksandr Byelkin (Monty program Ab)
12 # Date: 2009-03-24
13 # Change: Syntax changed
14 ################################################################################
15
16 --error ER_UNSUPPORTED_ENGINE_FOR_GENERATED_COLUMNS
17 create table t1 (a int, b int as (a+1));
18 create table t1 (a int not null);
19 --error ER_UNSUPPORTED_ENGINE_FOR_GENERATED_COLUMNS
20 alter table t1 add column b int as (a+1);
21 drop table t1;