GitHub user leborchuk added a comment to the discussion: Support Parallel Processing of Window Functions.
> During develop, I found that the result of Window Agg without Order By clause > is unstable. > > Referring to the SQL 2011 standard, it states that if ORDER BY is omitted, > the order of rows in the partition is undefined. While using a window > function without ORDER BY is valid, the resulting output seems unpredictable. > > To pass parallel test cases, we need to modify the SQL in that case. I have faced this issue many times, not only in CBDB but also in Postgres and Oracle. People write SQL queries with window functions without ordering by, then filter the output (the most common case being getting the maximum value) and report that the database has given the wrong result. But SQL is wrong, not the answer. I believe we need to modify our test cases. GitHub link: https://github.com/apache/cloudberry/discussions/1216#discussioncomment-13779390 ---- This is an automatically sent email for dev@cloudberry.apache.org. To unsubscribe, please send an email to: dev-unsubscr...@cloudberry.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@cloudberry.apache.org For additional commands, e-mail: dev-h...@cloudberry.apache.org
