[
https://jira.nuxeo.org/browse/NXP-6199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anahide Tchertchian resolved NXP-6199.
--------------------------------------
Resolution: Fixed
No more default escaper:
http://hg.nuxeo.org/nuxeo/nuxeo-services/rev/aba68e622a73
> 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, 5.4.0.1
> Reporter: Anahide Tchertchian
> Assignee: 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
ECM-tickets@lists.nuxeo.com
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
