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