You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Denys Ordynskiy (JIRA)" <ji...@apache.org> on 2019/01/18 10:25:00 UTC
[jira] [Commented] (DRILL-6783) CAST string literal as INTERVAL
MONTH/YEAR works inconsistently when selecting from a table with multiple
rows
[ https://issues.apache.org/jira/browse/DRILL-6783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16746137#comment-16746137 ]
Denys Ordynskiy commented on DRILL-6783:
----------------------------------------
Tested with Drill version 1.16.0-SNAPSHOT (commit 172dc7cb4c3323e9650db2bf7fe1eab76c2fbbe1).
Cases verified:
- casting string month interval literal as "interval month";
- casting string month interval literal as "interval year";
- casting string month interval literal as "interval day";
- casting string day interval literal as "interval month";
- casting string day interval literal as "interval day".
> CAST string literal as INTERVAL MONTH/YEAR works inconsistently when selecting from a table with multiple rows
> --------------------------------------------------------------------------------------------------------------
>
> Key: DRILL-6783
> URL: https://issues.apache.org/jira/browse/DRILL-6783
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.15.0
> Reporter: Bohdan Kazydub
> Assignee: Bohdan Kazydub
> Priority: Critical
> Labels: ready-to-commit
> Fix For: 1.15.0
>
>
> Casting string literal as INTERVAL MONTH or INTERVAL YEAR produces different values for each row (actually, with period of 4) when selecting data from table with more than one row.
> For example:
> {code}
> 0: jdbc:drill:zk=local> select cast('P314M' as interval month) from cp.`employee.json` limit 10;
> +--------------------------+
> | EXPR$0 |
> +--------------------------+
> | 26 years 2 months |
> | 81089877 years 5 months |
> | 1714858 years 8 months |
> | 6698 years 8 months |
> | 26 years 2 months |
> | 81089877 years 5 months |
> | 1714858 years 8 months |
> | 6698 years 8 months |
> | 26 years 2 months |
> | 81089877 years 5 months |
> +--------------------------+
> 10 rows selected (0.186 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)