Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.2(EOL)
-
None
Description
This script:
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a INT);
|
ALTER TABLE t1 ADD CONSTRAINT c1 CHECK (a > 0);
|
ALTER TABLE t1 ADD CONSTRAINT c1 CHECK (a > 0);
|
SHOW CREATE TABLE t1;
|
returns:
CREATE TABLE `t1` (
|
`a` int(11) DEFAULT NULL,
|
CONSTRAINT `c1` CHECK (a > 0),
|
CONSTRAINT `c1` CHECK (a > 0)
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1
|
Notice, two constrains with a duplicate name are allowed.
Attachments
Issue Links
- is duplicated by
-
-
- Closed
-