You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sentry.apache.org by sp...@apache.org on 2017/09/11 14:30:41 UTC
sentry git commit: SENTRY-1934: SQL Index name is too long for Oracle
11.2 (Na Li, reviewed by Alexander Kolbasov)
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 <se...@cloudera.com>
Authored: Mon Sep 11 09:30:08 2017 -0500
Committer: Sergio Pena <se...@cloudera.com>
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;