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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
