Debian Codegraph @

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

raw
1 ################################################################################
2 # t/vcol_rpl.test #
3 # #
4 # Purpose: #
5 # Test replication of tables with virtual columns. #
6 # #
7 #------------------------------------------------------------------------------#
8 # Original Author: Andrey Zhakov #
9 # Original Date: 2008-09-04
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 # Engine specific settings and requirements
27
28 ##### Storage engine to be tested
29 # Set the session storage engine
30 --source include/have_innodb.inc
31 SET @@session.default_storage_engine = 'InnoDB';
32
33 #------------------------------------------------------------------------------#
34 # Cleanup
35 --source suite/vcol/inc/vcol_cleanup.inc
36
37 ##### Workarounds for known open engine specific bugs
38 # none
39
40 #------------------------------------------------------------------------------#
41 # Execute the tests to be applied to all storage engines
42 --source include/master-slave.inc
43
44 connection master;
45 create table t1 (a int, b int as (a+1));
46 show create table t1;
47 insert into t1 values (1,default);
48 insert into t1 values (2,default);
49 select * from t1;
50 save_master_pos;
51
52 connection slave;
53 sync_with_master;
54 select * from t1;
55
56 connection master;
57 drop table t1;
58 save_master_pos;
59
60 connection slave;
61 sync_with_master;
62
63 #------------------------------------------------------------------------------#
64 # Execute storage engine specific tests
65
66
67 #------------------------------------------------------------------------------#
68 # Cleanup
69 --source suite/vcol/inc/vcol_cleanup.inc
70 --source include/rpl_end.inc