First of all, look up interval laterals in the SQL standard and find out whether it's even valid.
Julian > On Oct 22, 2015, at 21:49, Hsuan Yi Chu <[email protected]> wrote: > > Hi All, > I am trying to resolve CALCITE-922, (interval error, coming from attempting > to get value of Interval Type). > > However, I found another issue regarding the "sign (i.e., + or -)" of > Interval type (see CALCITE-928). To resolve it, can somebody tell me what > this means: > > "INTERVAL -'-1' YEAR" > > Do the two negative signs cancel each other?
