Karen Feng created SPARK-39376:
----------------------------------
Summary: Do not output duplicated columns in star expansion of
subquery alias of NATURAL/USING JOIN
Key: SPARK-39376
URL: https://issues.apache.org/jira/browse/SPARK-39376
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 3.2.0
Reporter: Karen Feng
A bug was introduced in https://issues.apache.org/jira/browse/SPARK-34527 such
that the duplicated columns within a NATURAL/USING JOIN were output from the
qualified star of a subquery alias. For example:
```
val df1 = Seq((3, 8)).toDF("a", "b")
val df2 = Seq((8, 7)).toDF("b", "d")
val joinDF = df1.join(df2, "b")
joinDF.alias("r").select("r.*")
```
Output two duplicate `b` columns.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
