You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2016/06/14 18:30:27 UTC
[jira] [Created] (DRILL-4722) date_add() function returns incorrect
result with interval hour, minute and second
Krystal created DRILL-4722:
------------------------------
Summary: date_add() function returns incorrect result with interval hour, minute and second
Key: DRILL-4722
URL: https://issues.apache.org/jira/browse/DRILL-4722
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Reporter: Krystal
Fix For: 1.7.0, 1.6.0
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 |
+------------------------+------------------------+------------------------+
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)