[ https://jira.nuxeo.org/browse/NXP-6199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anahide Tchertchian reassigned NXP-6199: ---------------------------------------- Assignee: Anahide Tchertchian > 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