This is an automated email from the ASF dual-hosted git repository.
ilgrosso pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/syncope.git
The following commit(s) were added to refs/heads/master by this push:
new 7a9533ae59 [SYNCOPE-1769] Fix index creation for AnyObject table (#489)
7a9533ae59 is described below
commit 7a9533ae59213a2755fadbe1f73bcb9c9d1d5663
Author: Francesco Chicchiriccò <[email protected]>
AuthorDate: Tue Jul 11 10:16:56 2023 +0200
[SYNCOPE-1769] Fix index creation for AnyObject table (#489)
---
core/persistence-jpa-json/src/main/resources/myjson/indexes.xml | 2 +-
core/persistence-jpa-json/src/main/resources/ojson/indexes.xml | 2 +-
core/persistence-jpa-json/src/main/resources/pgjsonb/indexes.xml | 4 ++--
core/persistence-jpa/src/main/resources/indexes.xml | 2 +-
core/persistence-jpa/src/main/resources/oracle_indexes.xml | 2 +-
5 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/core/persistence-jpa-json/src/main/resources/myjson/indexes.xml
b/core/persistence-jpa-json/src/main/resources/myjson/indexes.xml
index 64e0d7a675..2dc39c44c9 100644
--- a/core/persistence-jpa-json/src/main/resources/myjson/indexes.xml
+++ b/core/persistence-jpa-json/src/main/resources/myjson/indexes.xml
@@ -31,7 +31,7 @@ under the License.
<entry key="SyncopeGroup_name">CREATE UNIQUE INDEX SyncopeGroup_name ON
SyncopeGroup(name)</entry>
<entry key="AnyObject_realm_id">CREATE INDEX AnyObject_realm_id ON
AnyObject(realm_id)</entry>
- <entry key="AnyObject_name">CREATE UNIQUE INDEX AnyObject_name ON
AnyObject(name)</entry>
+ <entry key="AnyObject_name">CREATE UNIQUE INDEX AnyObject_name ON
AnyObject(type_id,name)</entry>
<entry key="UDynGroupMembers_any_id">CREATE INDEX UDynGroupMembers_any_id ON
UDynGroupMembers(any_id)</entry>
<entry key="UDynGroupMembers_group_id">CREATE INDEX
UDynGroupMembers_group_id ON UDynGroupMembers(group_id)</entry>
diff --git a/core/persistence-jpa-json/src/main/resources/ojson/indexes.xml
b/core/persistence-jpa-json/src/main/resources/ojson/indexes.xml
index b50d063222..c123fb7d41 100644
--- a/core/persistence-jpa-json/src/main/resources/ojson/indexes.xml
+++ b/core/persistence-jpa-json/src/main/resources/ojson/indexes.xml
@@ -31,7 +31,7 @@ under the License.
<entry key="SyncopeGroup_lower_name">CREATE INDEX SyncopeGroup_lower_name ON
SyncopeGroup(LOWER(name))</entry>
<entry key="AnyObject_realm_id">CREATE INDEX AnyObject_realm_id ON
AnyObject(realm_id)</entry>
- <entry key="AnyObject_lower_name">CREATE INDEX AnyObject_lower_name ON
AnyObject(LOWER(name))</entry>
+ <entry key="AnyObject_lower_name">CREATE INDEX AnyObject_lower_name ON
AnyObject(type_id,LOWER(name))</entry>
<!-- The following indexes require Oracle TEXT to be installed on the given
Oracle database:
http://dbaflavours.blogspot.com/2012/09/ora-29833-indextype-does-not-exist_18.html
-->
diff --git a/core/persistence-jpa-json/src/main/resources/pgjsonb/indexes.xml
b/core/persistence-jpa-json/src/main/resources/pgjsonb/indexes.xml
index f93e8ac8b7..dc9981f4d8 100644
--- a/core/persistence-jpa-json/src/main/resources/pgjsonb/indexes.xml
+++ b/core/persistence-jpa-json/src/main/resources/pgjsonb/indexes.xml
@@ -36,8 +36,8 @@ under the License.
<entry key="SyncopeGroup_plainAttrs_idx">CREATE INDEX
SyncopeGroup_plainAttrs_idx ON SyncopeGroup USING gin ((plainAttrs)
jsonb_path_ops)</entry>
<entry key="AnyObject_realm_id">CREATE INDEX AnyObject_realm_id ON
AnyObject(realm_id)</entry>
- <entry key="AnyObject_name">CREATE UNIQUE INDEX AnyObject_name ON
AnyObject(name)</entry>
- <entry key="AnyObject_lower_name">CREATE INDEX AnyObject_lower_name ON
AnyObject(LOWER(name))</entry>
+ <entry key="AnyObject_name">CREATE UNIQUE INDEX AnyObject_name ON
AnyObject(type_id,name)</entry>
+ <entry key="AnyObject_lower_name">CREATE INDEX AnyObject_lower_name ON
AnyObject(type_id,LOWER(name))</entry>
<entry key="AnyObject_plainAttrs_idx">CREATE INDEX AnyObject_plainAttrs_idx
ON AnyObject USING gin ((plainAttrs) jsonb_path_ops)</entry>
<entry key="UDynGroupMembers_any_id">CREATE INDEX UDynGroupMembers_any_id ON
UDynGroupMembers(any_id)</entry>
diff --git a/core/persistence-jpa/src/main/resources/indexes.xml
b/core/persistence-jpa/src/main/resources/indexes.xml
index 7626e7b58e..e864514038 100644
--- a/core/persistence-jpa/src/main/resources/indexes.xml
+++ b/core/persistence-jpa/src/main/resources/indexes.xml
@@ -31,7 +31,7 @@ under the License.
<entry key="SyncopeGroup_name">CREATE UNIQUE INDEX SyncopeGroup_name ON
SyncopeGroup(name)</entry>
<entry key="AnyObject_realm_id">CREATE INDEX AnyObject_realm_id ON
AnyObject(realm_id)</entry>
- <entry key="AnyObject_name">CREATE UNIQUE INDEX AnyObject_name ON
AnyObject(name)</entry>
+ <entry key="AnyObject_name">CREATE UNIQUE INDEX AnyObject_name ON
AnyObject(type_id,name)</entry>
<entry key="UDynGroupMembers_any_id">CREATE INDEX UDynGroupMembers_any_id ON
UDynGroupMembers(any_id)</entry>
<entry key="UDynGroupMembers_group_id">CREATE INDEX
UDynGroupMembers_group_id ON UDynGroupMembers(group_id)</entry>
diff --git a/core/persistence-jpa/src/main/resources/oracle_indexes.xml
b/core/persistence-jpa/src/main/resources/oracle_indexes.xml
index 3d864abf7f..bb2d4d4499 100644
--- a/core/persistence-jpa/src/main/resources/oracle_indexes.xml
+++ b/core/persistence-jpa/src/main/resources/oracle_indexes.xml
@@ -31,7 +31,7 @@ under the License.
<entry key="SyncopeGroup_lower_name">CREATE INDEX SyncopeGroup_lower_name ON
SyncopeGroup(LOWER(name))</entry>
<entry key="AnyObject_realm_id">CREATE INDEX AnyObject_realm_id ON
AnyObject(realm_id)</entry>
- <entry key="AnyObject_lower_name">CREATE INDEX AnyObject_lower_name ON
AnyObject(LOWER(name))</entry>
+ <entry key="AnyObject_lower_name">CREATE INDEX AnyObject_lower_name ON
AnyObject(type_id,LOWER(name))</entry>
<entry key="APlainAttrUniqueValue_U">CREATE UNIQUE INDEX
APlainAttrUniqueValue_U on APlainAttrUniqueValue(booleanValue, dateValue,
stringValue, doubleValue, longValue, schema_id)</entry>
<entry key="UPlainAttrUniqueValue_U">CREATE UNIQUE INDEX
UPlainAttrUniqueValue_U on UPlainAttrUniqueValue(booleanValue, dateValue,
stringValue, doubleValue, longValue, schema_id)</entry>
