[
https://jira.nuxeo.com/browse/NXP-8004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-8004:
-----------------------------------
Description:
Giving that we have a note and a file that match the following criteria:
{code}
SELECT * from Note, File WHERE ecm:isProxy = 0 AND (dc:title =
'testfile1_Title' OR content/name = 'testfile.txt')
{code}
This is returning only the file document instead of both the file and the note.
Here is the SQL statement executed:
{noformat}
SELECT DISTINCT "HIERARCHY"."ID" AS "_C1" FROM "HIERARCHY"
LEFT JOIN "DUBLINCORE" "_F1" ON "HIERARCHY"."ID" = "_F1"."ID"
JOIN "HIERARCHY" "_H1" ON "HIERARCHY"."ID" = "_H1"."PARENTID"
LEFT JOIN "CONTENT" "_F2" ON "_H1"."ID" = "_F2"."ID"
WHERE
("HIERARCHY"."PRIMARYTYPE" IN ('File2', 'File', 'Note')
AND ("_F1"."TITLE" = 'testfile1_Title' OR "_F2"."NAME" = 'testfile.txt'))
AND "_H1"."NAME" = 'content'
{noformat}
was:
Giving that we have a note and file that matches the following criterias
{code}
SELECT * from Note,File WHERE ecm:isProxy = 0 and ( dc:title =
'testfile1_Title' or content/name = 'testfile.txt')"
{code}
Is returning only the file document.
Here is the SQL statement executed
{code}
SQL: SELECT DISTINCT "HIERARCHY"."ID" AS "_C1" FROM "HIERARCHY"
LEFT JOIN "DUBLINCORE" "_F1" ON "HIERARCHY"."ID" = "_F1"."ID"
JOIN "HIERARCHY" "_H1" ON "HIERARCHY"."ID" = "_H1"."PARENTID"
LEFT JOIN "CONTENT" "_F2" ON "_H1"."ID" = "_F2"."ID" WHERE
(("HIERARCHY"."PRIMARYTYPE" IN ('File2', 'File', 'Note')) AND
(("_F1"."TITLE" = 'testfile1_Title') OR ("_F2"."NAME" = 'testfile.txt'))) AND
"_H1"."NAME" = 'content'
{code}
> NXQL complex type clauses select only a subset of the documents
> ---------------------------------------------------------------
>
> Key: NXP-8004
> URL: https://jira.nuxeo.com/browse/NXP-8004
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Core SQL Storage
> Affects Versions: 5.5-SNAPSHOT
> Reporter: Stéphane Lacoin
> Assignee: Florent Guillaume
> Priority: Major
> Fix For: 5.5
>
>
> Giving that we have a note and a file that match the following criteria:
> {code}
> SELECT * from Note, File WHERE ecm:isProxy = 0 AND (dc:title =
> 'testfile1_Title' OR content/name = 'testfile.txt')
> {code}
> This is returning only the file document instead of both the file and the
> note.
> Here is the SQL statement executed:
> {noformat}
> SELECT DISTINCT "HIERARCHY"."ID" AS "_C1" FROM "HIERARCHY"
> LEFT JOIN "DUBLINCORE" "_F1" ON "HIERARCHY"."ID" = "_F1"."ID"
> JOIN "HIERARCHY" "_H1" ON "HIERARCHY"."ID" = "_H1"."PARENTID"
> LEFT JOIN "CONTENT" "_F2" ON "_H1"."ID" = "_F2"."ID"
> WHERE
> ("HIERARCHY"."PRIMARYTYPE" IN ('File2', 'File', 'Note')
> AND ("_F1"."TITLE" = 'testfile1_Title' OR "_F2"."NAME" = 'testfile.txt'))
> AND "_H1"."NAME" = 'content'
> {noformat}
--
This message is automatically generated by JIRA.
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
