[jira] [Created] (SPARK-21774) The rule PromoteStrings cast string to a wrong data type

["StanZhai (JIRA)" <ji...@apache.org>]

StanZhai created SPARK-21774:
--------------------------------

             Summary: The rule PromoteStrings cast string to a wrong data type
                 Key: SPARK-21774
                 URL: https://issues.apache.org/jira/browse/SPARK-21774
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 2.2.0
            Reporter: StanZhai
            Priority: Critical


Data
{code}
create temporary view tb as select * from values
("0", 1),
("-0.1", 2),
("1", 3)
as grouping(a, b)
{code}

SQL:
{code}
select a, b from tb where a=0
{code}

The result which is wrong:
{code}
+----+---+
|   a|  b|
+----+---+
|   0|  1|
|-0.1|  2|
+----+---+
{code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

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