You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Ulrich Kramer (Jira)" <ji...@apache.org> on 2023/05/08 08:09:00 UTC
[jira] [Commented] (CALCITE-5693) AssertionError with UNION using CTE
[ https://issues.apache.org/jira/browse/CALCITE-5693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17720431#comment-17720431 ]
Ulrich Kramer commented on CALCITE-5693:
----------------------------------------
I opened a PR for this: https://github.com/apache/calcite/pull/3191
> 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)