Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
11.4.2
-
None
-
ubuntu 20.04
Description
CREATE TABLE test (c1 VARCHAR(255), PRIMARY KEY(c1)); |
INSERT INTO test(c1) VALUES ('A'); |
INSERT INTO test(c1) VALUES ('a'); |
--ERROR 1062 (23000): Duplicate entry 'a' for key 'test.PRIMARY' |
When inserting a, it will report a duplicate primary key. But there's only 'A' in the table and there's no 'a'.