Debian Codegraph @

mysql-test/suite/engines/funcs/r/ld_unique_error3_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' (@c1,c2) SET c1 = @c1 % 2;
4 Warnings:
5 Warning 1062 Duplicate entry '1' for key 't1.PRIMARY'
6 Warning 1062 Duplicate entry '1' for key 't1.PRIMARY'
7 Warning 1062 Duplicate entry '0' for key 't1.PRIMARY'
8 SELECT * FROM t1 ORDER BY c1;
9 c1 c2
10 0 def
11 1 abc
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' (@c1,c2) SET c1 = @c1 % 2;
15 Warnings:
16 Warning 1062 Duplicate entry '1' for key 't1.PRIMARY'
17 Warning 1062 Duplicate entry '1' for key 't1.PRIMARY'
18 Warning 1062 Duplicate entry '0' for key 't1.PRIMARY'
19 SELECT * FROM t1 ORDER BY c1;
20 c1 c2
21 0 def
22 1 abc
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' (@c1,c2) SET c1 = @c1 % 2;
26 SELECT * FROM t1 ORDER BY c1;
27 c1 c2
28 0 opq
29 1 jkl
30 DROP TABLE t1;