← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/vcol/t/rpl_vcol.test

Merged vcol stuff.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/vcol/t/rpl_vcol.test
 
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:                                                               #
 
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
# Cleanup
 
23
--source suite/vcol/inc/vcol_cleanup.inc
 
24
 
 
25
#------------------------------------------------------------------------------#
 
26
# General not engine specific settings and requirements
 
27
--source suite/vcol/inc/vcol_init_vars.pre
 
28
 
 
29
#------------------------------------------------------------------------------#
 
30
# Engine specific settings and requirements
 
31
 
 
32
##### Storage engine to be tested
 
33
# Set the session storage engine
 
34
--source include/have_innodb.inc
 
35
SET @@session.storage_engine = 'InnoDB';
 
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 virtual 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