You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Santiago M. Mola (JIRA)" <ji...@apache.org> on 2015/04/07 12:16:12 UTC

[jira] [Created] (SPARK-6740) SQL operator and condition precedence is not honoured

Santiago M. Mola created SPARK-6740:
---------------------------------------

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


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