Thanks Mark, that's really helpful. I have logged https://issues.apache.org/jira/browse/CALCITE-7233 to tackle this issue.
On Thu, Oct 16, 2025 at 4:14 PM Mark Lewis <[email protected]> wrote: > I tried to create a representative reproducing test here: > > https://github.com/apache/calcite/pull/4583 > > For me this test succeeds with the Calcite 1.40.0 codebase but fails on > queries 40, 67 and 80 with the current codebase. > > > On 2025/10/16 09:08:22 我 wrote: > > I attempted to construct TPC-DS tables and data using WITH clauses in a > test[1], but I'm uncertain if it can simulate the query scenario properly. > I selected q80 for verification and didn't reproduce the error mentioned in > the email. As Mihai mentioned, Calcite has many configurations. Could it be > that certain configurations are causing the issue? Therefore, it would be > best to provide a reproducible test case based on Calcite's current code to > facilitate problem analysis. > > > > > > [1] https://github.com/apache/calcite/pull/4582 > > > >
