[DERBY-7121] DROP UNIQUE KEY not working

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.15.2.0
• Component/s: SQL
• Environment: Own Docker Image based on Ubuntu 20.04, please see here: https://hub.docker.com/repository/docker/konnexionsgmbh/apache_derby
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Walter Weinmann
• Created: 31/Jul/21 11:55
• Updated: 02/Aug/21 18:38
• Resolved: 02/Aug/21 17:34

Description

I try to drop the FOREIGN KEY, PRIMARY KEY and UNIQUE KEY constraints before the INSERT. To do this, I use the DatabaseMetaData class from JDBC. When dropping the UNIQUE KEY I get the following error message:

java.sql.SQLSyntaxErrorException: ALTER TABLE failed. There is no constraint 'KXN_SCHEMA.SQL00000166-6f554487-017a-f4fd-c9dc-000016e126' on table '"KXN_SCHEMA". "COUNTRY_STATE"'.

Details about the error and the database environment can be found in the attached PDF document.