[PHOENIX-2946] Projected comparison between date and timestamp columns always returns true

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.6.0, 4.8.0
• Fix Version/s: 4.9.0, 4.8.1
• Labels: comparison date timestamp
• Assignee: James R. Taylor
• Reporter: Kevin Liew
• Created: 28/May/16 01:11
• Updated: 28/Sep/16 05:15
• Resolved: 08/Sep/16 19:32

Description

0: jdbc:phoenix:thin:url=http://localhost:876> create table test (dateCol DATE primary key, timestampCol TIMESTAMP);
No rows affected (2.559 seconds)

0: jdbc:phoenix:thin:url=http://localhost:876> upsert into test values (TO_DATE('1990-01-01'), NOW());
1 row affected (0.255 seconds)

0: jdbc:phoenix:thin:url=http://localhost:876> select dateCol = timestampCol from test;
+------------------------------------------+
|          DATECOL = TIMESTAMPCOL          |
+------------------------------------------+
| true                                     |
+------------------------------------------+
1 row selected (0.019 seconds)

Issue Links

• links to: GitHub Pull Request #206