[DRILL-4722] Fix EqualityVisitor for interval day expressions with millis - ASF JIRA

Voters

Watch issue

Watchers

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 1.11.0
Component/s: Functions - Drill
Labels:
None

Description

Issue
The following query returns the same data for the second column as the first:

select date_add(cast('2015-01-24 07:27:05.0' as timestamp), interval '3' HOUR), date_add(cast('2015-01-24 07:27:05.0' as timestamp), interval '5' HOUR) from (values(1));
+------------------------+------------------------+
|         EXPR$0         |         EXPR$1         |
+------------------------+------------------------+
| 2015-01-24 10:27:05.0  | 2015-01-24 10:27:05.0  |
+------------------------+------------------------+

If each column is run separately, then it produces correct result:

select date_add(cast('2015-01-24 07:27:05.0' as timestamp), interval '3' HOUR) from (values(1));
+------------------------+
|         EXPR$0         |
+------------------------+
| 2015-01-24 10:27:05.0  |
+------------------------+

select date_add(cast('2015-01-24 07:27:05.0' as timestamp), interval '5' HOUR) from (values(1));
+------------------------+
|         EXPR$0         |
+------------------------+
| 2015-01-24 12:27:05.0  |
+------------------------+

Same problem is seen for interval of minute and second:

select date_add(cast('2015-01-24 07:27:05.0' as timestamp), interval '50' MINUTE), date_add(cast('2015-01-24 07:27:05.0' as timestamp), interval '40' MINUTE) from (values(1));
+------------------------+------------------------+
|         EXPR$0         |         EXPR$1         |
+------------------------+------------------------+
| 2015-01-24 08:17:05.0  | 2015-01-24 08:17:05.0  |
+------------------------+------------------------+

select date_add(cast('2015-01-24 07:27:05.0' as timestamp), interval '50' second), date_add(cast('2015-01-24 07:27:05.0' as timestamp), interval '40' second) from (values(1));
+------------------------+------------------------+
|         EXPR$0         |         EXPR$1         |
+------------------------+------------------------+
| 2015-01-24 07:27:55.0  | 2015-01-24 07:27:55.0  |
+------------------------+------------------------+

select date_add(cast('2015-01-24 07:27:05.0' as timestamp), interval '3' HOUR), date_add(cast('2015-01-24 07:27:05.0' as timestamp), interval '50' MINUTE), date_add(cast('2015-01-24 07:27:05.0' as timestamp), interval '50' second) from (values(1));
+------------------------+------------------------+------------------------+
|         EXPR$0         |         EXPR$1         |         EXPR$2         |
+------------------------+------------------------+------------------------+
| 2015-01-24 10:27:05.0  | 2015-01-24 10:27:05.0  | 2015-01-24 10:27:05.0  |
+------------------------+------------------------+------------------------+