alamb opened a new issue, #6720:
URL: https://github.com/apache/arrow-datafusion/issues/6720

                 To me this doesn't look right. The previous test seems 
correct. When putting a negation in front of interval I believe it should 
negate the entire interval statement.
   
   `interval '5' - '1' - '2' year` is one interval statement.
   
   I think the statement
   
   ```
   select -interval '5' - '1' - '2' year;
   ```
   
   Should be interpreted as:
   
   ```
   select - (interval '5' - '1' - '2' year);
   ```
   
   Rather than
   
   ```
   select (- interval '5') - '1' - '2' year;
   ```
   
   If the user wants to negate only `5`, they should write it as follows (below 
are all equivalents):
   
   ```
   select interval '-5' - '1' - '2' year;
   select interval - '5' - '1' - '2' year;
   select - interval '5' year - interval '1' year - interval '2' year;
   ```
   
   _Originally posted by @aprimadi in 
https://github.com/apache/arrow-datafusion/pull/6698#discussion_r1232607304_
               


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to