Prevents ORA-06532 on huge read ACL
-----------------------------------
Key: NXP-7527
URL: https://jira.nuxeo.com/browse/NXP-7527
Project: Nuxeo Enterprise Platform
Issue Type: Bug
Components: Core SQL Storage
Affects Versions: 5.4.2
Environment: oracle
Reporter: Benoit Delbosc
When having more than 100 principals in a read acls the nx_list_read_acls_for
function raises the following error
{code}
Failed to execute query: ORA-06532: Subscript outside of limit
ORA-06512: at "REFERENTIAL.SPLIT", line 13
ORA-06512: at "REFERENTIAL.NX_LIST_READ_ACLS_FOR", line 18
ORA-06512: at "REFERENTIAL.NX_GET_READ_ACLS_FOR", line 14
{code}
The 100 limit should be increase to something like 300.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
