This is an automated email from the ASF dual-hosted git repository. struberg pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/openjpa.git
commit db6f6b642203d60ae1fa7576715e180c6bbe6081 Author: Mark Struberg <strub...@apache.org> AuthorDate: Sat Nov 10 20:47:09 2018 +0100 OPENJPA-2756 escape search strings for all Postgres versions Can be disabled via config by explicitly setting the DBDictionary to requiresSearchStringEscapeForLike=false via persistence.xml for example. --- .../main/java/org/apache/openjpa/jdbc/sql/PostgresDictionary.java | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/PostgresDictionary.java b/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/PostgresDictionary.java index 82c3dce..2ba03e0 100644 --- a/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/PostgresDictionary.java +++ b/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/PostgresDictionary.java @@ -753,9 +753,12 @@ public class PostgresDictionary if ((maj >= 9 || (maj == 8 && min >= 3))) { supportsXMLColumn = true; } + + // PostgreSQL requires to escape search strings + requiresSearchStringEscapeForLike = true; + // Old PostgreSQL requires double-escape for strings. if ((maj <= 8 || (maj == 9 && min == 0))) { - requiresSearchStringEscapeForLike = true; searchStringEscape = "\\\\"; } }