Details
-
Bug
-
Status: In Review (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11.2, 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
-
None
Description
Run the following statements, you will see the last statement fails to drop the CHECK constraint, and reports an error ` Can't DROP CONSTRAINT `c1`; check that it exists`
DROP TABLE IF EXISTS t0; |
CREATE TABLE t0 (c1 INT CHECK ( c1 > 0 )); |
SELECT CONSTRAINT_NAME, TABLE_NAME, CONSTRAINT_TYPE FROM information_schema.TABLE_CONSTRAINTS WHERE TABLE_NAME = 't0' AND TABLE_SCHEMA = 'test'; |
ALTER TABLE t0 DROP CONSTRAINT c1; |
Attachments
Issue Links
- is blocked by
-
-
- Stalled
-