[SPARK-47511] Canonicalize With expressions by re-assigning IDs

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Kelvin Jiang
• Reporter: Kelvin Jiang
• Created: 21/Mar/24 18:36
• Updated: 05/Apr/24 14:47
• Resolved: 29/Mar/24 03:09

Description

The current canonicalization of `With` expressions takes into account the ID of the common expressions, which comes from a global monotonically increasing ID. This means that queries with `With` expressions (e.g. `NULLIF` expressions) will have inconsistent canonicalizations.

Issue Links

• is duplicated by: SPARK-47527 Cache miss for queries using With expressions
• links to: GitHub Pull Request #45649
• links to: GitHub Pull Request #45871