Debian Codegraph @

mysql-test/suite/gcol/t/gcol_merge.test

raw
1 ################################################################################
2 # t/gcol_merge.test #
3 # #
4 # Purpose: #
5 # MERGE branch #
6 # #
7 #------------------------------------------------------------------------------#
8 # Original Author: Andrey Zhakov #
9 # Original Date: 2008-09-03 #
10 # Change Author: #
11 # Change Date: #
12 # Change: #
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/gcol/inc/gcol_init_vars.pre
24
25 #------------------------------------------------------------------------------#
26 # Engine specific settings and requirements
27
28 ##### Storage engine to be tested
29 # Set the session storage engine
30
31 ##### Workarounds for known open engine specific bugs
32 # none
33
34 #------------------------------------------------------------------------------#
35 # Execute the tests to be applied to all storage engines
36
37 #------------------------------------------------------------------------------#
38 # Execute storage engine specific tests
39 --disable_warnings
40 drop table if exists t1, t2, t3;
41 --enable_warnings
42
43 create table t1 (a int, b int generated always as (a % 10) virtual);
44 create table t2 (a int, b int generated always as (a % 10) virtual);
45 insert into t1 values (1,default);
46 insert into t2 values (2,default);
47 --error ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN
48 create table t3 (a int, b int generated always as (a % 10) virtual) engine=MERGE UNION=(t1,t2);
49 drop table t1,t2;
50
51 #------------------------------------------------------------------------------#
52 # Cleanup
53 --source suite/gcol/inc/gcol_cleanup.inc