[jira] [Created] (HIVE-13048) Rogue SQL statement in an upgrade SQL file for oracle.

["Naveen Gangam (JIRA)" <ji...@apache.org>]

Naveen Gangam created HIVE-13048:
------------------------------------

             Summary: Rogue SQL statement in an upgrade SQL file for oracle.
                 Key: HIVE-13048
                 URL: https://issues.apache.org/jira/browse/HIVE-13048
             Project: Hive
          Issue Type: Bug
            Reporter: Naveen Gangam
            Assignee: Naveen Gangam


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)