Repository: sentry Updated Branches: refs/heads/master 25c1c6063 -> ea524f1bd
SENTRY-1934: SQL Index name is too long for Oracle 11.2 (Na Li, reviewed by Alexander Kolbasov) Project: http://git-wip-us.apache.org/repos/asf/sentry/repo Commit: http://git-wip-us.apache.org/repos/asf/sentry/commit/ea524f1b Tree: http://git-wip-us.apache.org/repos/asf/sentry/tree/ea524f1b Diff: http://git-wip-us.apache.org/repos/asf/sentry/diff/ea524f1b Branch: refs/heads/master Commit: ea524f1bdf41775a3bbdc205af850d600517904b Parents: 25c1c60 Author: Sergio Pena <[email protected]> Authored: Mon Sep 11 09:30:08 2017 -0500 Committer: Sergio Pena <[email protected]> Committed: Mon Sep 11 09:30:08 2017 -0500 ---------------------------------------------------------------------- .../java/org/apache/sentry/provider/db/service/model/package.jdo | 2 +- .../src/main/resources/008-SENTRY-1569.derby.sql | 2 +- .../src/main/resources/008-SENTRY-1569.mysql.sql | 2 +- .../src/main/resources/008-SENTRY-1569.oracle.sql | 2 +- .../src/main/resources/008-SENTRY-1569.postgres.sql | 2 +- .../sentry-provider-db/src/main/resources/sentry-db2-2.0.0.sql | 2 +- .../sentry-provider-db/src/main/resources/sentry-derby-2.0.0.sql | 2 +- .../sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql | 2 +- .../sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql | 2 +- .../src/main/resources/sentry-postgres-2.0.0.sql | 2 +- .../src/main/resources/sentry-upgrade-db2-1.8.0-to-2.0.0.sql | 2 +- 11 files changed, 11 insertions(+), 11 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/sentry/blob/ea524f1b/sentry-provider/sentry-provider-db/src/main/java/org/apache/sentry/provider/db/service/model/package.jdo ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/java/org/apache/sentry/provider/db/service/model/package.jdo b/sentry-provider/sentry-provider-db/src/main/java/org/apache/sentry/provider/db/service/model/package.jdo index 88d7378..2f2aabb 100644 --- a/sentry-provider/sentry-provider-db/src/main/java/org/apache/sentry/provider/db/service/model/package.jdo +++ b/sentry-provider/sentry-provider-db/src/main/java/org/apache/sentry/provider/db/service/model/package.jdo @@ -320,7 +320,7 @@ <class name="MSentryHmsNotification" table="SENTRY_HMS_NOTIFICATION_ID" identity-type="nondurable" detachable="true"> <field name="notificationId"> <column name="NOTIFICATION_ID" jdbc-type="BIGINT" allows-null="false"/> - <index name="SENTRY_HMS_NOTIFICATION_ID_INDEX"/> + <index name="SENTRY_HMS_NOTIF_ID_INDEX"/> </field> </class> </package> http://git-wip-us.apache.org/repos/asf/sentry/blob/ea524f1b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.derby.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.derby.sql b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.derby.sql index 49b7959..477d224 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.derby.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.derby.sql @@ -28,4 +28,4 @@ CREATE TABLE SENTRY_HMS_NOTIFICATION_ID NOTIFICATION_ID BIGINT NOT NULL ); -CREATE INDEX SENTRY_HMS_NOTIFICATION_ID_INDEX ON SENTRY_HMS_NOTIFICATION_ID (NOTIFICATION_ID); \ No newline at end of file +CREATE INDEX SENTRY_HMS_NOTIF_ID_INDEX ON SENTRY_HMS_NOTIFICATION_ID (NOTIFICATION_ID); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/ea524f1b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.mysql.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.mysql.sql b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.mysql.sql index 0bda5cd..33e36c7 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.mysql.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.mysql.sql @@ -26,4 +26,4 @@ CREATE TABLE `SENTRY_HMS_NOTIFICATION_ID` `NOTIFICATION_ID` BIGINT NOT NULL )ENGINE=INNODB; -CREATE INDEX `SENTRY_HMS_NOTIFICATION_ID_INDEX` ON `SENTRY_HMS_NOTIFICATION_ID` (`NOTIFICATION_ID`); \ No newline at end of file +CREATE INDEX `SENTRY_HMS_NOTIF_ID_INDEX` ON `SENTRY_HMS_NOTIFICATION_ID` (`NOTIFICATION_ID`); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/ea524f1b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.oracle.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.oracle.sql b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.oracle.sql index 8dd8316..db66b13 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.oracle.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.oracle.sql @@ -27,4 +27,4 @@ CREATE TABLE "SENTRY_HMS_NOTIFICATION_ID" "NOTIFICATION_ID" NUMBER NOT NULL ); -CREATE INDEX "SENTRY_HMS_NOTIFICATION_ID_INDEX" ON "SENTRY_HMS_NOTIFICATION_ID" ("NOTIFICATION_ID"); \ No newline at end of file +CREATE INDEX "SENTRY_HMS_NOTIF_ID_INDEX" ON "SENTRY_HMS_NOTIFICATION_ID" ("NOTIFICATION_ID"); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/ea524f1b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.postgres.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.postgres.sql b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.postgres.sql index 2610d6c..2746922 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.postgres.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.postgres.sql @@ -26,4 +26,4 @@ CREATE TABLE "SENTRY_HMS_NOTIFICATION_ID" "NOTIFICATION_ID" bigint NOT NULL ); -CREATE INDEX "SENTRY_HMS_NOTIFICATION_ID_INDEX" ON "SENTRY_HMS_NOTIFICATION_ID" ("NOTIFICATION_ID"); \ No newline at end of file +CREATE INDEX "SENTRY_HMS_NOTIF_ID_INDEX" ON "SENTRY_HMS_NOTIFICATION_ID" ("NOTIFICATION_ID"); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/ea524f1b/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-2.0.0.sql index 1661412..2c1268a 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-2.0.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-2.0.0.sql @@ -249,4 +249,4 @@ CREATE TABLE SENTRY_HMS_NOTIFICATION_ID NOTIFICATION_ID bigint NOT NULL ); -CREATE INDEX SENTRY_HMS_NOTIFICATION_ID_INDEX ON SENTRY_HMS_NOTIFICATION_ID (NOTIFICATION_ID); \ No newline at end of file +CREATE INDEX SENTRY_HMS_NOTIF_ID_INDEX ON SENTRY_HMS_NOTIFICATION_ID (NOTIFICATION_ID); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/ea524f1b/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-2.0.0.sql index 1b95622..1c51049 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-2.0.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-2.0.0.sql @@ -249,4 +249,4 @@ CREATE TABLE SENTRY_HMS_NOTIFICATION_ID NOTIFICATION_ID BIGINT NOT NULL ); -CREATE INDEX SENTRY_HMS_NOTIFICATION_ID_INDEX ON SENTRY_HMS_NOTIFICATION_ID (NOTIFICATION_ID); +CREATE INDEX SENTRY_HMS_NOTIF_ID_INDEX ON SENTRY_HMS_NOTIFICATION_ID (NOTIFICATION_ID); http://git-wip-us.apache.org/repos/asf/sentry/blob/ea524f1b/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql index f033895..9f61154 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql @@ -284,4 +284,4 @@ CREATE TABLE `SENTRY_HMS_NOTIFICATION_ID` `NOTIFICATION_ID` BIGINT NOT NULL )ENGINE=INNODB; -CREATE INDEX `SENTRY_HMS_NOTIFICATION_ID_INDEX` ON `SENTRY_HMS_NOTIFICATION_ID` (`NOTIFICATION_ID`); \ No newline at end of file +CREATE INDEX `SENTRY_HMS_NOTIF_ID_INDEX` ON `SENTRY_HMS_NOTIFICATION_ID` (`NOTIFICATION_ID`); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/ea524f1b/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql index 1b5cd04..58241e5 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql @@ -265,4 +265,4 @@ CREATE TABLE "SENTRY_HMS_NOTIFICATION_ID" "NOTIFICATION_ID" NUMBER NOT NULL ); -CREATE INDEX "SENTRY_HMS_NOTIFICATION_ID_INDEX" ON "SENTRY_HMS_NOTIFICATION_ID" ("NOTIFICATION_ID"); \ No newline at end of file +CREATE INDEX "SENTRY_HMS_NOTIF_ID_INDEX" ON "SENTRY_HMS_NOTIFICATION_ID" ("NOTIFICATION_ID"); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/ea524f1b/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-2.0.0.sql index d6d222e..5d52136 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-2.0.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-2.0.0.sql @@ -272,6 +272,6 @@ CREATE TABLE "SENTRY_HMS_NOTIFICATION_ID" "NOTIFICATION_ID" bigint NOT NULL ); -CREATE INDEX "SENTRY_HMS_NOTIFICATION_ID_INDEX" ON "SENTRY_HMS_NOTIFICATION_ID" ("NOTIFICATION_ID"); +CREATE INDEX "SENTRY_HMS_NOTIF_ID_INDEX" ON "SENTRY_HMS_NOTIFICATION_ID" ("NOTIFICATION_ID"); COMMIT; http://git-wip-us.apache.org/repos/asf/sentry/blob/ea524f1b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.8.0-to-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.8.0-to-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.8.0-to-2.0.0.sql index 6340520..5e8be9c 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.8.0-to-2.0.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.8.0-to-2.0.0.sql @@ -67,7 +67,7 @@ CREATE TABLE SENTRY_HMS_NOTIFICATION_ID NOTIFICATION_ID bigint NOT NULL ); -CREATE INDEX SENTRY_HMS_NOTIFICATION_ID_INDEX ON SENTRY_HMS_NOTIFICATION_ID (NOTIFICATION_ID); +CREATE INDEX SENTRY_HMS_NOTIF_ID_INDEX ON SENTRY_HMS_NOTIFICATION_ID (NOTIFICATION_ID); -- Version update UPDATE SENTRY_VERSION SET SCHEMA_VERSION='2.0.0', VERSION_COMMENT='Sentry release version 2.0.0' WHERE VER_ID=1;
