Debian Codegraph @

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

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