[HIVE-19365] Index on COMPLETED_TXN_COMPONENTS in Metastore RDBMS has different names in different scripts

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.1.0, 3.0.0
• Component/s: Metastore
• Assignee: Alan Gates Assign to me
• Reporter: Alan Gates
• Created: 30/Apr/18 22:28
• Updated: 27/Feb/24 22:23
• Resolved: 01/May/18 21:02

Description

In mysql and mssql install scripts the index is called COMPLETED_TXN_COMPONENTS_IDX2  Everywhere else it is called COMPLETED_TXN_COMPONENTS_IDX, which is breaking upgrade scripts for 3.0 to 3.1 since they don't know which index to update.  One name should be chosen and used everywhere.