openjpa-commits mailing list archives

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 <struberg@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 = "\\\\";
         }
     }