[
https://jira.nuxeo.org/browse/NXP-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-5506:
-----------------------------------
Summary: NXQL query with several ecm:fulltext references fails (was: VCS
query with several ecm:fulltext references fails)
> NXQL query with several ecm:fulltext references fails
> -----------------------------------------------------
>
> Key: NXP-5506
> URL: https://jira.nuxeo.org/browse/NXP-5506
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Core SQL Storage, Search / Query
> Affects Versions: 5.3.2
> Environment: PostgreSQL, MySQL, Oracle or SQL Server
> Reporter: Florent Guillaume
> Assignee: Florent Guillaume
> Priority: Major
> Fix For: 5.4
>
>
> When doing a NXQL query involving several ecm:fulltext, the generated SQL
> query is incorrect and fails, because it mentions the fulltext table twice
> without aliasing:
> SELECT "hierarchy"."id" AS "_C1"
> FROM "hierarchy"
> JOIN "fulltext" ON "fulltext"."id" = "hierarchy"."id"
> JOIN "fulltext" ON "fulltext"."id" = "hierarchy"."id"
> ...
> This does not happen with H2.
--
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
