Debian Codegraph @

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

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