Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 TEXT);
3 SHOW CREATE TABLE t1;
4 Table Create Table
5 t1 CREATE TABLE `t1` (
6 `c1` int NOT NULL,
7 `c2` text,
8 PRIMARY KEY (`c1`)
9 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
10 SHOW TABLES;
11 Tables_in_test
12 t1
13 ERROR 23000: Duplicate entry '1' for key 't1.PRIMARY'
14 TRUNCATE TABLE t1;
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 TRUNCATE TABLE t1;
24 SELECT * FROM t1 ORDER BY c1;
25 c1 c2
26 0 opq
27 1 jkl
28 DROP TABLE t1;