Github user gatorsmile commented on the issue:
https://github.com/apache/spark/pull/15398
Also checked SQL Server. It behaves differently from both `Postgre` and
`DB2`. It simply ignores it.
> If there is no character after an escape character in the LIKE pattern,
the pattern is not valid and the LIKE returns FALSE. If the character after an
escape character is not a wildcard character, the escape character is discarded
and the character following the escape is treated as a regular character in the
pattern. This includes the percent sign (%), underscore (_), and left bracket
([) wildcard characters when they are enclosed in double brackets ([ ]). Also,
within the double bracket characters ([ ]), escape characters can be used and
the caret (^), hyphen (-), and right bracket (]) can be escaped.
Let me check Oracle now
---
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 infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org
