snuyanzin commented on code in PR #3733: URL: https://github.com/apache/calcite/pull/3733#discussion_r1573881599
########## babel/src/test/resources/sql/redshift.iq: ########## @@ -523,78 +523,78 @@ select deptno, ratio_to_report(sal) over (partition by deptno) from emp; !} # STDDEV_POP -select empno, stddev_pop(comm) over (order by empno rows unbounded preceding) from emp where deptno = 30 order by 1; +select empno, stddev_pop(CAST(comm AS DECIMAL(12, 4))) over (order by empno rows unbounded preceding) from emp where deptno = 30 order by 1; EMPNO, EXPR$1 -7499, 0 -7521, 100 -7654, 478.42333648024424519462627358734607696533203125 -7698, 478.42333648024424519462627358734607696533203125 -7844, 522.0153254455275373402400873601436614990234375 -7900, 522.0153254455275373402400873601436614990234375 +7499, 0.0000 +7521, 100.0000 +7654, 478.4233 +7698, 478.4233 +7844, 522.0153 +7900, 522.0153 !ok # STDDEV_SAMP (synonym for STDDEV) -select empno, stddev_samp(comm) over (order by empno rows unbounded preceding) from emp where deptno = 30 order by 1; +select empno, stddev_samp(CAST(comm AS DECIMAL(12, 4))) over (order by empno rows unbounded preceding) from emp where deptno = 30 order by 1; EMPNO, EXPR$1 7499, null -7521, 141.421356237309510106570087373256683349609375 -7654, 585.9465277082316561063635163009166717529296875 -7698, 585.9465277082316561063635163009166717529296875 -7844, 602.7713773341707792496890760958194732666015625 -7900, 602.7713773341707792496890760958194732666015625 +7521, 141.4213 +7654, 585.9465 +7698, 585.9465 +7844, 602.7713 +7900, 602.7713 Review Comment: same here -- 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: commits-unsubscr...@calcite.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org