[jira] [Created] (SPARK-29264) Fix examples for the RLike expression

["Maxim Gekk (Jira)" <ji...@apache.org>]

Maxim Gekk created SPARK-29264:
----------------------------------

             Summary: Fix examples for the RLike expression
                 Key: SPARK-29264
                 URL: https://issues.apache.org/jira/browse/SPARK-29264
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: Maxim Gekk


The example for RLIKE is incorrect: https://github.com/apache/spark/blob/a428f406693f1c372dc0e378f6b413eca9e367ac/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/expressions/regexpExpressions.scala#L174
{code}
spark-sql> SET spark.sql.parser.escapedStringLiterals=true;
spark.sql.parser.escapedStringLiterals	true
spark-sql> SELECT '%SystemDrive%\Users\John' rlike '%SystemDrive%\Users.*';
19/09/26 23:33:13 ERROR SparkSQLDriver: Failed in [SELECT '%SystemDrive%\Users\John' rlike '%SystemDrive%\Users.*']
java.util.regex.PatternSyntaxException: Illegal/unsupported escape sequence near index 14
%SystemDrive%\Users.*
              ^
	at java.util.regex.Pattern.error(Pattern.java:1957)
	at java.util.regex.Pattern.escape(Pattern.java:2473)
	at java.util.regex.Pattern.atom(Pattern.java:2200)
	at java.util.regex.Pattern.sequence(Pattern.java:2132)
	at java.util.regex.Pattern.expr(Pattern.java:1998)
	at java.util.regex.Pattern.compile(Pattern.java:1698)
	at java.util.regex.Pattern.<init>(Pattern.java:1351)
	at java.util.regex.Pattern.compile(Pattern.java:1028)
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org