You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Bohdan Kazydub (JIRA)" <ji...@apache.org> on 2018/10/08 08:51:00 UTC
[jira] [Created] (DRILL-6783) CAST string literal as INTERVAL
MONTH/YEAR works inconsistently when selecting from a table with multiple
rows
Bohdan Kazydub created DRILL-6783:
-------------------------------------
Summary: 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
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)