[
https://jira.nuxeo.org/browse/NXP-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=81802#action_81802
]
Thierry Martins commented on NXP-5506:
--------------------------------------
Fix the problem using only one JOIN for the fulltext tables even if the query
references ecm:fulltext several times.
Tested on PostgreSQL, MySQL, Oracle and SQL Server
Fix for 5.4: http://hg.nuxeo.org/nuxeo/nuxeo-core/rev/1b6c4b5ea299
Also did a backport on branch 5.3.2:
http://hg.nuxeo.org/nuxeo/nuxeo-core/rev/e4d1b36aba5b
> 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
