Thanks a lot for the added context and pointers Julian and Leonard, I've fixed it by going down to the arithmetics as suggested in one of the Calcite discussions.
The changes proposed by FLIP-126 definitely look good. I'll check its details further. Best Regards, On Thu, 4 Mar 2021 at 04:18, Leonard Xu <xbjt...@gmail.com> wrote: > Hi, Sebastián Ramírez Magrí > (Sorry for wrong name in above mail) > > Flink follows old version calcite’s behaviour which lead to the wrong > behavior. snd Julian is right that calcite has corrected FLOOR and CEIL > functions in CALCITE-3412, Flink has upgraded calcite to 1.26 version > which contains the patch, what we need is only to adapt it in Flink code, > I’d like to make this as a part of FLIP-162 and fix it soon. > > Thanks Julian and Timo for the reminder. > > > Best, > Leonard > > 在 2021年3月4日，12:14，Leonard Xu <xbjt...@gmail.com> 写道： > > Hi, Jaffe > > Flink follows old version calcite’s behaviour which lead to the wrong > behavior. snd Julian is right that calcite has corrected FLOOR and CEIL > functions in CALCITE-3412, Flink has upgraded calcite to 1.26 version > which contains the patch, what we need is only to adapt it in Flink code, > I’d like to make this as a part of FLIP-162 and fix it soon. > > Thanks Julian and Timo for the reminder. > > > Best, > Leonard > > > -- Sebastián Ramírez Magrí
