mySQL 5.0.11 sources for tomato
[tomato.git] / release / src / router / mysql / mysql-test / suite / ndb / r / ndb_load.result
blobf990b12e7354951f1da097f1820caadce78be44a
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (word CHAR(20) NOT NULL PRIMARY KEY) ENGINE=NDB;
3 LOAD DATA INFILE '../../../std_data/words.dat' INTO TABLE t1 ;
4 ERROR 23000: Can't write; duplicate key in table 't1'
5 DROP TABLE t1;
6 CREATE TABLE t1 (word CHAR(20) NOT NULL) ENGINE=NDB;
7 LOAD DATA INFILE '../../../std_data/words.dat' INTO TABLE t1 ;
8 SELECT * FROM t1 ORDER BY word;
9 word
10 Aarhus
11 Aarhus
12 Aaron
13 Aaron
14 Ababa
15 Ababa
16 aback
17 aback
18 abaft
19 abaft
20 abandon
21 abandon
22 abandoned
23 abandoned
24 abandoning
25 abandoning
26 abandonment
27 abandonment
28 abandons
29 abandons
30 abase
31 abased
32 abasement
33 abasements
34 abases
35 abash
36 abashed
37 abashes
38 abashing
39 abasing
40 abate
41 abated
42 abatement
43 abatements
44 abater
45 abates
46 abating
47 Abba
48 abbe
49 abbey
50 abbeys
51 abbot
52 abbots
53 Abbott
54 abbreviate
55 abbreviated
56 abbreviates
57 abbreviating
58 abbreviation
59 abbreviations
60 Abby
61 abdomen
62 abdomens
63 abdominal
64 abduct
65 abducted
66 abduction
67 abductions
68 abductor
69 abductors
70 abducts
71 Abe
72 abed
73 Abel
74 Abelian
75 Abelson
76 Aberdeen
77 Abernathy
78 aberrant
79 aberration
80 DROP TABLE t1;