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 >
