Debian Codegraph @

mysql-test/suite/vcol/t/vcol_merge.test

raw
1 ################################################################################
2 # t/vcol_merge.test #
3 # #
4 # Purpose: #
5 # MERGE branch #
6 # #
7 #------------------------------------------------------------------------------#
8 # Original Author: Andrey Zhakov #
9 # Original Date: 2008-09-03 #
10 # Change Author: Oleksandr Byelkin (Monty program Ab)
11 # Date: 2009-03-24
12 # Change: Syntax changed
13 ################################################################################
14
15 #
16 # NOTE: PLEASE DO NOT ADD NOT MYISAM SPECIFIC TESTCASES HERE !
17 # TESTCASES WHICH MUST BE APPLIED TO ALL STORAGE ENGINES MUST BE ADDED IN
18 # THE SOURCED FILES ONLY.
19 #
20
21 #------------------------------------------------------------------------------#
22 # General not engine specific settings and requirements
23 --source suite/vcol/inc/vcol_init_vars.pre
24
25 #------------------------------------------------------------------------------#
26 # Cleanup
27 --source suite/vcol/inc/vcol_cleanup.inc
28
29 #------------------------------------------------------------------------------#
30 # Engine specific settings and requirements
31
32 ##### Storage engine to be tested
33 # Set the session storage engine
34
35 ##### Workarounds for known open engine specific bugs
36 # none
37
38 #------------------------------------------------------------------------------#
39 # Execute the tests to be applied to all storage engines
40
41 #------------------------------------------------------------------------------#
42 # Execute storage engine specific tests
43 --disable_warnings
44 drop table if exists t1, t2, t3;
45 --enable_warnings
46
47 create table t1 (a int, b int as (a % 10));
48 create table t2 (a int, b int as (a % 10));
49 insert into t1 values (1,default);
50 insert into t2 values (2,default);
51 --error ER_UNSUPPORTED_ENGINE_FOR_GENERATED_COLUMNS
52 create table t3 (a int, b int as (a % 10)) engine=MERGE UNION=(t1,t2);
53 drop table t1,t2;
54
55 #------------------------------------------------------------------------------#
56 # Cleanup
57 --source suite/vcol/inc/vcol_cleanup.inc