Debian Codegraph @

mysql-test/suite/engines/funcs/r/ld_unique_error1_local.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 TEXT);
3 LOAD DATA LOCAL INFILE 'suite/engines/funcs/t/load_unique_error1.inc' INTO TABLE t1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
4 Warnings:
5 Warning 1062 Duplicate entry '3' for key 't1.PRIMARY'
6 SELECT * FROM t1 ORDER BY c1;
7 c1 c2
8 1 abc
9 2 def
10 3 ghi
11 4 opq
12 DROP TABLE t1;
13 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 TEXT);
14 LOAD DATA LOCAL INFILE 'suite/engines/funcs/t/load_unique_error1.inc' IGNORE INTO TABLE t1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
15 Warnings:
16 Warning 1062 Duplicate entry '3' for key 't1.PRIMARY'
17 SELECT * FROM t1 ORDER BY c1;
18 c1 c2
19 1 abc
20 2 def
21 3 ghi
22 4 opq
23 DROP TABLE t1;
24 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 TEXT);
25 LOAD DATA LOCAL INFILE 'suite/engines/funcs/t/load_unique_error1.inc' REPLACE INTO TABLE t1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
26 SELECT * FROM t1 ORDER BY c1;
27 c1 c2
28 1 abc
29 2 def
30 3 jkl
31 4 opq
32 DROP TABLE t1;