Ulrich Kramer created CALCITE-5693: -------------------------------------- Summary: AssertionError with UNION using CTE Key: CALCITE-5693 URL: https://issues.apache.org/jira/browse/CALCITE-5693 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.34.0 Reporter: Ulrich Kramer
Adding the following test to {{JdbcAdapterTest}} {code:java} @Test void testFilterUnionIncludingWithPlan() { CalciteAssert.model(FoodmartSchema.FOODMART_MODEL) .query(" ( with a as (select * from \"sales_fact_1997\") select * from a)\n" + " union all\n" + " ( with b as (select * from \"sales_fact_1998\") select * from b)\n") .runs(); } {code} will throw an {{AssertionError}} in {{SqlValidatorImpl.deduceModality}} -- This message was sent by Atlassian Jira (v8.20.10#820010)