[
https://jira.nuxeo.org/browse/NXP-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=80153#action_80153
]
Raimund Sacherer commented on NXP-5506:
---------------------------------------
Ok, I understand, it is not *that* urgent for me anymore because I just tried
to downgrade to 5.3.1 and basically it is working (well, it does not matter
where i put the items to search in the advanced search, it searches only in the
fulltext.fulltext column), but for now I can live with that.
Is there an estimate when 5.4 will be out? I think I was reading something
along september? On another note, is this not a often used feature, include
document specific metadata in advanced search? Why did this not come up
earlier? 5.3.2 is out quite some time, makes me wonder how Nuxeo is used mainly
... or is the fulltext search not that important for most of the installed
userbase?
Or are there better ways and I implemented it the wrong way?
thank you and best regards
Raimund
> 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
