Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 TEXT);
3 ERROR 23000: Duplicate entry '3' for key 't1.PRIMARY'
4 TRUNCATE TABLE t1;
5 Warnings:
6 Warning 1062 Duplicate entry '3' for key 't1.PRIMARY'
7 SELECT * FROM t1 ORDER BY c1;
8 c1 c2
9 1 abc
10 2 def
11 3 ghi
12 4 opq
13 TRUNCATE TABLE t1;
14 SELECT * FROM t1 ORDER BY c1;
15 c1 c2
16 1 abc
17 2 def
18 3 jkl
19 4 opq
20 DROP TABLE t1;