[
https://issues.apache.org/jira/browse/CALCITE-5693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhen Chen resolved CALCITE-5693.
--------------------------------
Resolution: Fixed
It has been confirmed in the PR discussion that this has been fixed, so I'm
marking it as resolved.
> 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
> Priority: Major
> Labels: pull-request-available
>
> 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)