You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Wenchen Fan (Jira)" <ji...@apache.org> on 2024/01/23 09:51:00 UTC

[jira] [Assigned] (SPARK-46683) Write a subquery generator that generates subqueries of different variations to increase testing coverage in this area

     [ https://issues.apache.org/jira/browse/SPARK-46683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Wenchen Fan reassigned SPARK-46683:
-----------------------------------

    Assignee: Andy Lam

> Write a subquery generator that generates subqueries of different variations to increase testing coverage in this area
> ----------------------------------------------------------------------------------------------------------------------
>
>                 Key: SPARK-46683
>                 URL: https://issues.apache.org/jira/browse/SPARK-46683
>             Project: Spark
>          Issue Type: Test
>          Components: Optimizer, SQL
>    Affects Versions: 3.5.1
>            Reporter: Andy Lam
>            Assignee: Andy Lam
>            Priority: Major
>              Labels: correctness, pull-request-available, testing
>
> There are a lot of subquery correctness issues, ranging from very old bugs to new ones that are being introduced due to work being done on subquery correlation optimization. This is especially in the areas of COUNT bugs and null behaviors.
> To increase test coverage and robustness in this area, we want to write a subquery generator that writes variations of subqueries, producing SQL tests that also run against Postgres (from my work in SPARK-46179).



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org