Description
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,
INTERVAL -'1' hour
Calcite should have blocked it.
2. The sign is not set correctly in parsing if there is a negative sign in quotes. For example,
INTERVAL '-1' hour
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.
Attachments
Issue Links
- is part of
-
CALCITE-922 AssertionError extracting value from an INTERVAL literal
- Closed