spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xiangrui Meng (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SPARK-17647) SQL LIKE/RLIKE do not handle backslashes correctly
Date Mon, 26 Sep 2016 16:54:20 GMT

     [ https://issues.apache.org/jira/browse/SPARK-17647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Xiangrui Meng updated SPARK-17647:
----------------------------------
    Description: 
Try the following in SQL shell:

{code}
select '\\\\' like '%\\%';
{code}

It returned false, which is wrong.


cc: [~yhuai] [~joshrosen]


A false-negative considered previously):


{code}
select '\\\\' rlike '.*\\\\\\\\.*';
{code}

It returned true, which is correct if we assume that the pattern is treated as a Java string
but not raw string.

  was:
Try the following in SQL shell:

{code}
select '\\\\' like '%\\%';
select '\\\\' rlike '.*\\\\\\\\.*';
{code}

The first returned false and the second returned true. Both are wrong.

cc: [~yhuai] [~joshrosen]


> SQL LIKE/RLIKE do not handle backslashes correctly
> --------------------------------------------------
>
>                 Key: SPARK-17647
>                 URL: https://issues.apache.org/jira/browse/SPARK-17647
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>            Reporter: Xiangrui Meng
>              Labels: correctness
>
> Try the following in SQL shell:
> {code}
> select '\\\\' like '%\\%';
> {code}
> It returned false, which is wrong.
> cc: [~yhuai] [~joshrosen]
> A false-negative considered previously):
> {code}
> select '\\\\' rlike '.*\\\\\\\\.*';
> {code}
> It returned true, which is correct if we assume that the pattern is treated as a Java
string but not raw string.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

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


Mime
View raw message