[SPARK-48419] Foldable propagation replace foldable column should use origin column

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.3, 3.1.3, 3.2.4, 4.0.0, 3.5.1, 3.3.4
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Knight Chess
• Reporter: Knight Chess
• Created: 25/May/24 01:07
• Updated: 03/Jun/24 04:11
• Resolved: 31/May/24 00:53

Description

column name will be change by `FoldablePropagation` in optimizer

befor optimizer:

```shell

'Project ['x, 'y, 'z]
+- 'Project 'a AS x#112, str AS Y#113, 'b AS z#114
   +- LocalRelation <empty>, a#0, b#1

```

after optimizer:

```shell

Project x#112, str AS Y#113, z#114
+- Project a#0 AS x#112, str AS Y#113, b#1 AS z#114
   +- LocalRelation <empty>, a#0, b#1

```

column name `y` will be replace to 'Y'

Issue Links

• links to: GitHub Pull Request #46742