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)
