← 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

  • Committer: Brian Aker
  • Date: 2009-02-05 11:33:00 UTC
  • Revision ID: brian@tangent.org-20090205113300-0tv4k8k02vg5c3mc
Enabling Archive test for VCOL

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