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
17create table t1 (a int, b int as (a+1));
18create table t1 (a int not null);
19--error ER_UNSUPPORTED_ENGINE_FOR_GENERATED_COLUMNS
20alter table t1 add column b int as (a+1);
21drop table t1;
22