Github user gatorsmile commented on a diff in the pull request:
    --- Diff: 
    @@ -74,6 +107,31 @@ class RegexpExpressionsSuite extends SparkFunSuite with 
ExpressionEvalHelper {
         checkEvaluation("a\nb" like regEx, true, create_row("a%b"))
         checkEvaluation(Literal.create(null, StringType) like regEx, null, 
    +    checkEvaluation("" like regEx, true, create_row(""))
    +    checkEvaluation("a" like regEx, false, create_row(""))
    +    checkEvaluation("" like regEx, false, create_row("a"))
    +    checkEvaluation("""\\\\""" like regEx, true, create_row("""%\\%"""))
    +    checkEvaluation("""%%""" like regEx, true, create_row("""%%"""))
    +    checkEvaluation("""\__""" like regEx, true, create_row("""\\\__"""))
    +    checkEvaluation("""\\\__""" like regEx, false, 
    +    checkEvaluation("""_\\\%""" like regEx, false, create_row("""%\\"""))
    +    // scalastyle:off nonascii
    +    checkEvaluation("a\u20ACa" like regEx, true, create_row("_\u20AC_"))
    +    checkEvaluation("a€a" like regEx, true, create_row("_€_"))
    +    checkEvaluation("a€a" like regEx, true, create_row("_\u20AC_"))
    +    checkEvaluation("a\u20ACa" like regEx, true, create_row("_€_"))
    +    // scalastyle:on nonascii
    +    // TODO: should throw an exception?
    --- End diff --
    See the description of SQL -130
    The ESCAPE clause is not a single character, or the pattern string contains 
an invalid occurrence of the escape character.
    The escape character must be a single character no more than two bytes in 
length. It can only appear in the pattern string if it is followed by itself, a 
percent sign, or an underscore. For more information about the ESCAPE clause on 
the LIKE predicate, refer to the SQL Reference.
    User response
    Correct the pattern string or the escape character accordingly.

If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at or file a JIRA ticket
with INFRA.

To unsubscribe, e-mail:
For additional commands, e-mail:

Reply via email to