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
24 #------------------------------------------------------------------------------#
25 # Engine specific settings and requirements
26
27 ##### Storage engine to be tested
28 # Set the session storage engine
29
30 ##### Workarounds for known open engine specific bugs
31 # none
32
33 #------------------------------------------------------------------------------#
34 # Execute the tests to be applied to all storage engines
35
36 #------------------------------------------------------------------------------#
37 # Execute storage engine specific tests
38 --disable_warnings
39 drop table if exists t1, t2, t3;
40 --enable_warnings
41
42 create table t1 (a int, b int generated always as (a % 10) virtual);
43 create table t2 (a int, b int generated always as (a % 10) virtual);
44 insert into t1 values (1,default);
45 insert into t2 values (2,default);
46 --error ER_UNSUPPORTED_ENGINE_FOR_GENERATED_COLUMNS
47 create table t3 (a int, b int generated always as (a % 10) virtual) engine=MERGE UNION=(t1,t2);
48 drop table t1,t2;
49
50 #------------------------------------------------------------------------------#
51 # Cleanup
52 --source suite/gcol/inc/gcol_cleanup.inc