[
https://jira.nuxeo.org/browse/NXP-5410?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=78294#action_78294
]
Florent Guillaume commented on NXP-5410:
----------------------------------------
This seems to be an Oracle bug. When the Oracle-JOIN syntax is used instead of
the ANSI JOIN syntax, it works:
SELECT * FROM (
SELECT H1.ID
FROM HIERARCHY H1, FULLTEXT
WHERE FULLTEXT.ID = H1.ID
AND (CONTAINS(FULLTEXT.FULLTEXT, 'testNote1', 1) > 0)
UNION ALL
SELECT H2.ID
FROM HIERARCHY H2, HIERARCHY_READ_ACL R
WHERE H2.ID = R.ID
AND R.ACL_ID IN
(SELECT * FROM TABLE(nx_get_read_acls_for(nx_string_table('Everyone')))
T)
)
> VCS Oracle queries failing
> --------------------------
>
> Key: NXP-5410
> URL: https://jira.nuxeo.org/browse/NXP-5410
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Core SQL Storage
> Affects Versions: 5.3.1
> Reporter: Florent Guillaume
> Assignee: Florent Guillaume
> Priority: Major
> Fix For: 5.3.2
>
>
> The following NXQL query fails when used with security check:
> SELECT * FROM Document WHERE ecm:fulltext LIKE 'testNote1' AND
> ecm:mixinType != 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND
> ecm:currentLifeCycleState != 'deleted'
> -> ORA-00918: column ambiguously defined
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/secure/Administrators.jspa
-
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
