[
https://jira.nuxeo.org/browse/NXP-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thierry Martins resolved NXP-5506.
----------------------------------
Resolution: Fixed
> 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.
> PostgreSQL error message:
> ERROR: table name "fulltext" specified more than once
> MySQL error message:
> Not unique table/alias: 'fulltext'
> Oracle error message:
> ORA-00918: column ambiguously defined
> SQL Server error message:
> The objects "fulltext" and "fulltext" in the FROM clause have the same
> exposed names. Use correlation names to distinguish them.
--
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
