You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by "mihaibudiu (via GitHub)" <gi...@apache.org> on 2026/10/02 03:08:39 UTC

Re: [PR] [CALCITE-7822] AssertionError "type mismatch" in SqlToRelConverter for OVER () in a GROUP BY query [calcite]

mihaibudiu commented on PR #5293:
URL: https://github.com/apache/calcite/pull/5293#issuecomment-5944895815

   > A RANGE window without ORDER BY takes an implicit sort key from the FROM item's monotonic column. 
   
   What is a monotonic column?
   
   > select deptno, count(*) over () as c from emp group by deptno on the scott schema now returns DEPTNO=10/20/30 with C=3. The same shape with an explicit RANGE frame and max(max(sal)) over () grouped by job also converts. ROWS framing, an explicit ORDER BY, and GROUP BY of the monotonic column itself are unchanged.
   
   I am not sure I understand this


-- 
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-unsubscribe@calcite.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org