spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Armbrust (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SPARK-6740) SQL operator and condition precedence is not honoured
Date Wed, 17 Jun 2015 21:52:01 GMT

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

Michael Armbrust updated SPARK-6740:
------------------------------------
    Target Version/s: 1.5.0
            Shepherd: Michael Armbrust

> SQL operator and condition precedence is not honoured
> -----------------------------------------------------
>
>                 Key: SPARK-6740
>                 URL: https://issues.apache.org/jira/browse/SPARK-6740
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 1.3.0
>            Reporter: Santiago M. Mola
>            Assignee: Santiago M. Mola
>
> The following query from the SQL Logic Test suite fails to parse:
> SELECT DISTINCT * FROM t1 AS cor0 WHERE NOT ( - _2 + - 39 ) IS NULL
> while the following (equivalent) does parse correctly:
> SELECT DISTINCT * FROM t1 AS cor0 WHERE NOT (( - _2 + - 39 ) IS NULL)
> SQLite, MySQL and Oracle (and probably most SQL implementations) define IS with higher
precedence than NOT, so the first query is valid and well-defined.



--
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