[HIVE-15724] getPrimaryKeys and getForeignKeys in metastore does not normalize db and table name

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Component/s: Metastore
• Target Version/s: 3.0.0
• Assignee: Daniel Dai
• Reporter: Daniel Dai
• Created: 25/Jan/17 08:22
• Updated: 23/May/18 00:00
• Resolved: 04/Apr/17 16:50

Description

In db, everything is lower case. When we retrieve constraints back, we need to normalize dbname/tablename. Otherwise, the following sample script fail:

alter table Table9 add constraint pk1 primary key (a) disable novalidate;
ALTER TABLE Table9 drop constraint pk1;

Error message: InvalidObjectException(message:The constraint: pk1 does not exist for the associated table: default.Table9