← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_LD_INFILE.result

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-03-17 14:56:02 UTC
  • Revision ID: james.westby@ubuntu.com-20100317145602-x7e30l1b2sb5s6w6
Tags: upstream-5.1.45
Import upstream version 5.1.45

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_LD_INFILE.result
 
1
stop slave;
 
2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
3
reset master;
 
4
reset slave;
 
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
6
start slave;
 
7
DROP TABLE IF EXISTS test.t1;
 
8
CREATE TABLE test.t1 (a VARCHAR(255), PRIMARY KEY(a));
 
9
LOAD DATA INFILE '../../std_data/words2.dat' INTO TABLE test.t1;
 
10
DELETE FROM test.t1 WHERE a = 'abashed';
 
11
DELETE FROM test.t1;
 
12
LOAD DATA INFILE '../../std_data/words2.dat' INTO TABLE test.t1;
 
13
SELECT * FROM test.t1 ORDER BY a DESC;
 
14
a
 
15
aberration
 
16
aberrant
 
17
Abernathy
 
18
Aberdeen
 
19
Abelson
 
20
Abelian
 
21
Abel
 
22
abed
 
23
Abe
 
24
abducts
 
25
abductors
 
26
abductor
 
27
abductions
 
28
abduction
 
29
abducted
 
30
abduct
 
31
abdominal
 
32
abdomens
 
33
abdomen
 
34
Abby
 
35
abbreviations
 
36
abbreviation
 
37
abbreviating
 
38
abbreviates
 
39
abbreviated
 
40
abbreviate
 
41
Abbott
 
42
abbots
 
43
abbot
 
44
abbeys
 
45
abbey
 
46
abbe
 
47
Abba
 
48
abating
 
49
abates
 
50
abater
 
51
abatements
 
52
abatement
 
53
abated
 
54
abate
 
55
abasing
 
56
abashing
 
57
abashes
 
58
abashed
 
59
abash
 
60
abases
 
61
abasements
 
62
abasement
 
63
abased
 
64
abase
 
65
SELECT * FROM test.t1 ORDER BY a DESC;
 
66
a
 
67
aberration
 
68
aberrant
 
69
Abernathy
 
70
Aberdeen
 
71
Abelson
 
72
Abelian
 
73
Abel
 
74
abed
 
75
Abe
 
76
abducts
 
77
abductors
 
78
abductor
 
79
abductions
 
80
abduction
 
81
abducted
 
82
abduct
 
83
abdominal
 
84
abdomens
 
85
abdomen
 
86
Abby
 
87
abbreviations
 
88
abbreviation
 
89
abbreviating
 
90
abbreviates
 
91
abbreviated
 
92
abbreviate
 
93
Abbott
 
94
abbots
 
95
abbot
 
96
abbeys
 
97
abbey
 
98
abbe
 
99
Abba
 
100
abating
 
101
abates
 
102
abater
 
103
abatements
 
104
abatement
 
105
abated
 
106
abate
 
107
abasing
 
108
abashing
 
109
abashes
 
110
abashed
 
111
abash
 
112
abases
 
113
abasements
 
114
abasement
 
115
abased
 
116
abase
 
117
DROP TABLE test.t1;