[SPARK-7098] Inconsistent Timestamp behavior when used in WHERE clause

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.1
• Fix Version/s: 1.4.0
• Component/s: SQL

Environment

Windows, Linux, Mac OS X with Java 1.7

• Target Version/s: 1.4.0
• Assignee: L. C. Hsieh
• Reporter: Peter Hagelund
• Created: 23/Apr/15 19:02
• Updated: 15/May/15 03:50
• Resolved: 15/May/15 03:50

Description

java.sql.Timestamps containing a nano value of 0 are not matched in a WHERE clause like SELECT ... FROM ... WHERE TS_COL = '2015-04-23 02:55:00.0'. When used with an explicit cast like SELECT ... FROM ... WHERE TS_COL = CAST('2015-04-23 02:55:00.0' AS TIMESTAMP) things work as expected.

Issue Links

• links to: [Github] Pull Request #5682 (viirya)