Xiao Meng created DRILL-814:
-------------------------------
Summary: Support cast interval format with negative zero
Key: DRILL-814
URL: https://issues.apache.org/jira/browse/DRILL-814
Project: Apache Drill
Issue Type: Bug
Reporter: Xiao Meng
Priority: Minor
Drill cannot identify negative sign before 0 in interval data format.
For example,
*Query 1*
{code}
select cast(cast('P-0DT1H0M0S' as VARCHAR(32)) as interval second) from
cp.`employee.json` limit 1;
{code}
returns
{code}
+------------+
| EXPR$0 |
+------------+
| PT3600S |
+------------+
{code}
*Query 2*
{code}
select cast(cast('PT-1H0M0S' as VARCHAR(32)) as interval second) from
cp.`employee.json` limit 1;
{code}
returns
{code}
+------------+
| EXPR$0 |
+------------+
| PT-3600S |
+------------+
{code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
