diff options
Diffstat (limited to 'mysql-test/suite/vcol/inc/vcol_blocked_sql_funcs_main.inc')
-rw-r--r-- | mysql-test/suite/vcol/inc/vcol_blocked_sql_funcs_main.inc | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/suite/vcol/inc/vcol_blocked_sql_funcs_main.inc b/mysql-test/suite/vcol/inc/vcol_blocked_sql_funcs_main.inc index 8124e4df888..571fe75560b 100644 --- a/mysql-test/suite/vcol/inc/vcol_blocked_sql_funcs_main.inc +++ b/mysql-test/suite/vcol/inc/vcol_blocked_sql_funcs_main.inc @@ -102,6 +102,18 @@ if (!$skip_full_text_checks) -- error ER_VIRTUAL_COLUMN_FUNCTION_IS_NOT_ALLOWED create table t1 (a varchar(1024), b varchar(1024) as (benchmark(a,3))); +--echo # CHARSET() +-- error ER_CONST_EXPR_IN_VCOL +create table t1 (a varchar(64), b varchar(64) as (charset(a))); + +--echo # COERCIBILITY() +-- error ER_CONST_EXPR_IN_VCOL +create table t1 (a varchar(64), b int as (coercibility(a))); + +--echo # COLLATION() +-- error ER_CONST_EXPR_IN_VCOL +create table t1 (a varchar(64), b varchar(64) as (collation(a))); + --echo # CONNECTION_ID() -- error ER_VIRTUAL_COLUMN_FUNCTION_IS_NOT_ALLOWED create table t1 (a int as (connection_id())); |