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; |