Andy Lam created SPARK-46683:
--------------------------------

             Summary: 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


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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to