← Back to branch summary

~ubuntu-branches/ubuntu/saucy/drizzle/saucy-proposed

« back to all changes in this revision

Viewing changes to tests/include/test_fieldsize.inc

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-03-18 12:12:31 UTC
  • Revision ID: james.westby@ubuntu.com-20100318121231-k6g1xe6cshbwa0f8
Tags: upstream-2010.03.1347
Import upstream version 2010.03.1347

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/include/test_fieldsize.inc
 
1
#
 
2
# include/test_fieldsize.inc 
 
3
# 
 
4
# This include file is designed to create a table with one column
 
5
# whose size on the master is greater than that on the slave. The
 
6
# test should fail with an error on the slave.
 
7
#
 
8
 
 
9
connection master;
 
10
DROP TABLE IF EXISTS t1;
 
11
 
 
12
sync_slave_with_master;
 
13
STOP SLAVE;
 
14
RESET SLAVE;
 
15
eval $test_table_slave;
 
16
 
 
17
connection master;
 
18
eval $test_table_master;
 
19
RESET MASTER;
 
20
 
 
21
eval $test_insert;
 
22
 
 
23
connection slave;
 
24
START SLAVE;
 
25
wait_for_slave_to_stop;
 
26
--replace_result $MASTER_MYPORT MASTER_PORT
 
27
--replace_column 1 # 4 # 7 # 8 # 9 # 16 # 22 # 23 # 33 # 35 # 36 #
 
28
--query_vertical SHOW SLAVE STATUS
 
29
 
 
30
# The following should be 0
 
31
SELECT COUNT(*) FROM t1;
 
32
STOP SLAVE;
 
33
RESET SLAVE;
 
34
 
 
35
connection master;
 
36
RESET MASTER;
 
37
 
 
38
connection slave;
 
39
START SLAVE;
 
40