From c76fad30a5f41b8da8a6a90d568bf81d3fff84f8 Mon Sep 17 00:00:00 2001 From: Jakob Odersky Date: Fri, 7 Oct 2016 18:10:20 -0700 Subject: Add more tests for various combinations of backslashes and SQL pattern characters --- .../sql/catalyst/expressions/RegexpExpressionsSuite.scala | 14 ++++++++++++++ 1 file changed, 14 insertions(+) diff --git a/sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/expressions/RegexpExpressionsSuite.scala b/sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/expressions/RegexpExpressionsSuite.scala index 9b42489cb2..9316f76190 100644 --- a/sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/expressions/RegexpExpressionsSuite.scala +++ b/sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/expressions/RegexpExpressionsSuite.scala @@ -55,6 +55,20 @@ class RegexpExpressionsSuite extends SparkFunSuite with ExpressionEvalHelper { checkEvaluation("a\nb" like "a%b", true) checkEvaluation("""\\\\""" like """%\\%""", true) // triple quotes to avoid java string escaping + checkEvaluation("""\_%""" like """%\\__""", true) + checkEvaluation("""\_%""" like "%\\\\__", true) + checkEvaluation("""\_%""" like """%\\_%""", true) + checkEvaluation("""\\\\%%""" like """\\%""", true) + checkEvaluation("""\%\""" like """%\%%""", true) + checkEvaluation("\\\n\n%\\" like "\\\\___\\\\", true) + checkEvaluation("""%%""" like """%%""", true) + checkEvaluation("""\__""" like """\\\__""", true) + + checkEvaluation("""\\\__""" like """%\\%\%""", false) + checkEvaluation("""\_""" like """\_\_""", false) + checkEvaluation("""_\\\%""" like """%\\""", false) + checkEvaluation("""_\\__""" like """_\___""", false) + } test("LIKE Non-literal Regular Expression") { -- cgit v1.2.3