[HIVE-13048] Rogue SQL statement in an upgrade SQL file for oracle.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1.0
• Assignee: Naveen Gangam
• Reporter: Naveen Gangam
• Created: 12/Feb/16 15:29
• Updated: 21/Jun/16 15:44
• Resolved: 18/Feb/16 03:44

Description

metastore/scripts/upgrade/oracle/033-HIVE-12892.oracle.sql has

VERSION_COMMENT VARCHAR(255) NOT NULL
CREATE TABLE CHANGE_VERSION (
CHANGE_VERSION_ID NUMBER NOT NULL,
VERSION NUMBER NOT NULL,
TOPIC VARCHAR(255) NOT NULL
);
ALTER TABLE CHANGE_VERSION ADD CONSTRAINT CHANGE_VERSION_PK PRIMARY KEY (CHANGE_VERSION_ID);
CREATE UNIQUE INDEX UNIQUE_CHANGE_VERSION ON CHANGE_VERSION (TOPIC);

The first line appears to be a typo and should not really be there. I noticed that in the METASTORE-Test precommit builds.