VCS 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
