[SPARK-5526] expression [date '2011-01-01' = cast(timestamp('2011-01-01 23:24:25') as date)] return false

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Component/s: SQL
• Target Version/s: 1.3.0
• Assignee: Unassigned
• Reporter: xukun
• Created: 02/Feb/15 09:41
• Updated: 04/Feb/15 02:13
• Resolved: 04/Feb/15 02:13

Description

previous work for test case，
create table date_1(d date);
insert overwrite table date_1 select cast('2011-01-01' as date) from src tablesample (1 rows);

In Hive，execute sql

{select date '2011-01-01' = cast(timestamp('2011-01-01 23:24:25') as date) from date_1 limit 1; }

return true,but in spark SQL, return false

Issue Links

• links to: [Github] Pull Request #4307 (viper-kun)