Sean Hsuan-Yi Chu created CALCITE-928:
-----------------------------------------

             Summary: Parsing Issue with Interval
                 Key: CALCITE-928
                 URL: https://issues.apache.org/jira/browse/CALCITE-928
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Sean Hsuan-Yi Chu
            Assignee: Sean Hsuan-Yi Chu


There are two issues with Interval type

1. A case which should be blocked at parsing:
The negative sign is not supposed to be outside of quotes. For example, 

{code}
INTERVAL -'1' hour
{code}

Calcite should have blocked it.

2. The sign is not set correctly in parsing if there is a negative sign in 
quotes. For example, 

{code}
INTERVAL -'1' hour
{code}

If you set a break point at the constructor of IntervalValue (, which will be 
called during parsing), you can see that, in the case above, sign is set to be 
+1.  

 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to