Fix error in advanced search when searching for a source holding the '-'
character
----------------------------------------------------------------------------------
Key: NXP-6199
URL: https://jira.nuxeo.org/browse/NXP-6199
Project: Nuxeo Enterprise Platform
Issue Type: Bug
Affects Versions: 5.4.0.1, 5.4
Reporter: Anahide Tchertchian
Fix For: 5.4.1
In advanced search screen, in the "source", type "test-test" => the following
error occurs:
Failed to execute query: Error in LIKE ESCAPE: test\[*]-test; SQL statement:
SELECT "_C1" FROM (SELECT "HIERARCHY"."ID" AS "_C1", "DUBLINCORE"."TITLE" AS
"_C2" FROM "HIERARCHY" LEFT JOIN "DUBLINCORE" ON "HIERARCHY"."ID" =
"DUBLINCORE"."ID" LEFT JOIN "MISC" ON "HIERARCHY"."ID" = "MISC"."ID" LEFT JOIN
"VERSIONS" ON "HIERARCHY"."ID" = "VERSIONS"."ID" WHERE
(("HIERARCHY"."PRIMARYTYPE" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?)) AND ("VERSIONS"."ID" IS NULL) AND ("DUBLINCORE"."SOURCE" LIKE ?) AND
((("MISC"."LIFECYCLESTATE" = ?) OR ("MISC"."LIFECYCLESTATE" = ?)) OR
("MISC"."LIFECYCLESTATE" = ?)) AND ("HIERARCHY"."PRIMARYTYPE" IN (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?)) AND ("VERSIONS"."ID" IS NULL)) UNION ALL SELECT "_H"."ID" AS "_C1",
"DUBLINCORE"."TITLE" AS "_C2" FROM "HIERARCHY" "_H" JOIN "PROXIES" ON "_H"."ID"
= "PROXIES"."ID" JOIN "HIERARCHY" ON "HIERARCHY"."ID" = "PROXIES"."TARGETID"
LEFT JOIN "DUBLINCORE" ON "HIERARCHY"."ID" = "DUBLINCORE"."ID" LEFT JOIN "MISC"
ON "HIERARCHY"."ID" = "MISC"."ID" LEFT JOIN "VERSIONS" ON "_H"."ID" =
"VERSIONS"."ID" WHERE (("HIERARCHY"."PRIMARYTYPE" IN (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ("VERSIONS"."ID" IS NULL) AND
("DUBLINCORE"."SOURCE" LIKE ?) AND ((("MISC"."LIFECYCLESTATE" = ?) OR
("MISC"."LIFECYCLESTATE" = ?)) OR ("MISC"."LIFECYCLESTATE" = ?)) AND
("HIERARCHY"."PRIMARYTYPE" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ("VERSIONS"."ID" IS
NULL))) ORDER BY "_C2" [22025-114]
The error does not occur when typing the same value in the "required words"
field as it's not using a LIKE operator but translates it into a fulltext query.
In any case, this should not be up to the query builder but to the core session
as escaping may vary depend on the backend => just disable current escaper by
default.
--
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
