Tathagata Das created SPARK-34720:
-------------------------------------
Summary: Incorrect star expansion logic MERGE INSERT / UPDATE *
Key: SPARK-34720
URL: https://issues.apache.org/jira/browse/SPARK-34720
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 3.1.1, 3.0.2
Reporter: Tathagata Das
The natural expectation of INSERT * or UPDATE * in MERGE is to assign source
columns to target columns of the same name. However, the current logic here
generates the assignment by position.
https://github.com/apache/spark/commit/7cfd589868b8430bc79e28e4d547008b222781a5#diff-ed19f376a63eba52eea59ca71f3355d4495fad4fad4db9a3324aade0d4986a47R1214
This can very easily lead to incorrect results without the user realizing this
odd behavior.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]